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(18596)
}
}
Alot of people keep commenting on Foxtel showing alot of games live. I would be surprised if we get much more than guaranteed 2 games live per week and sometimes 3 games per week live. Other than that we can hope for same night, late night replays of other games.
Studies have shown if games are shown replayed/delayed much more than a day than the majority of people dont bother tuning in as results are already known. (I'm sure us die hards will still love it though).
The big question will be will the FTA games be live. Surely Foxtel would like to be able to hold the claim as the only place to watch live NBL and allow the 2 games they give up to be showed delayed?
Seems to all sound to good to be true that a sport that has very little current market value would be pushed so well by Foxtel and FTA.