array(2) {
[0]=>
string(815) "
select r.*,
rc.info,
t.title as threadtitle,
u.username as username,
u.anonymous as useranonymous,
`f`.`value` AS `flairvalue`,
`ft`.`name` AS `flairname`,
`ft`.`colour` AS `flaircolour`,
`ft`.`icon` AS `flairicon`
from reply as r
join thread as t on t.id = r.threadid
join replycontent as rc on rc.replyid = r.id
join user as u on u.id = r.userid
left join `flair` `f` on `f`.`userid` = `u`.`id` and `f`.`categoryid` = `t`.`categoryid`
left join `flairoption` `ft` on `ft`.`id` = `f`.`flairoptionid`
where r.businessid = :businessId
and r.threadid = :threadId
group by r.id
order by r.utcdated desc
limit 0,50
"
[1]=>
array(2) {
["businessId"]=>
int(1)
["threadId"]=>
int(41443)
}
}
Their Facebook claims it will be televised in Australia but I cannot find anything more than that. https://m.facebook.com/story.php?story_fbid=709255562595967&substory_index=0&id=588787837976074
Apologies, it was aired at 8 Monday night in the States so probably has been on. None of the sessions will be aired live though. Games played Sunday and on TV Mondays.
For something that has had a big push of publicity and some pretty big names attached to it, they seem to have fallen over on actually showing games... I was just on their facebook page and their highlight snippets are worse than a joke...
<p><p><p>Selection of images from the games at Starplex on Saturday night, Centrals v Southern: <br><br><br><br><a href=" http://yvonnemilbank.com/gallery.cfm?d=Sport/Basketball - Central ABL/2011-05-07_Centrals v Southern Men">Men</p><br></p>
<br><a href=" http://yvonnemilbank.com/gallery.cfm?d=/Sport/Basketball - Central ABL/2011-05-07_Centrals v Southern Women">Women</p><br></p><br><br>