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(17826)
}
}
I just saw this as well. Absolutely bloody fantastic!
NBA basketball on FTA TV!!!! That can only be a good thing in my books.
Channel 10 are already showing the American NFL and apparently have been getting good results whcih has led to this decision.
Let's hope they also pick up the rights for show some College Hoops as well! I'd l;ove the chance to be abel to watch AJ and Patty rip up the college hoops scene.
And the NBL - well this opportunity has just fallen into their lap - now if onl they can get organised enough to try and take advantage of it!