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(33209)
}
}
I know PERFORM couldn't put a greasy stick up a cat's arse but I appreciate the sentiment that I can watch any game when I want... Only wish this was around when Geelong, Hobart, Canberra and Giants were around... Oh wait they are coming back
Lol @ stop the BBQ and let's watch the basketball... What idiocy!
The beauty of the Internet or atleast NBL.tv is you don't have to watch the games live but on demand which means I can go to my Wildcats game and then come home and enjoy the commentary and try and remember the next highlight coming up.
I'd love it on 7mate as GEM will have cricket and ONE changed it so they don't put sports telecasts on before 9:30pm (or that's atleast the 2012 ideals)
SoccerBoobsSubtitles will focus on soccer and cycling and they are happy with those as they won't upset anyone... Think they have netball too