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(26806)
}
}
#338895 is a stark reminder of that season where every game was live on Sky NZ but only one or two aired per week on Australian TV. What a trip down memory lane - only in the NBL.
Why not just use NBLTV? For f*&ck's sake, it's $5 a month. Every game, replays, history, blah blah blah!
And I know that this next bit is going to sound corny..., you would also be supporting the bugger who is actually making it all possible. That's rather an old-fashioned idea by now, I suppose.
Yeah quality isn't great, but it's often it's a case of better than nothing. I stream through my TV (it's not a big one) and if I'm back far enough it does the job. Again, not perfect (it can be hard to tell who has the ball) but better than nothing. By the way, it seems Breakers games from Sky are a bit better quality-wise on these streams.