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(38806)
}
}
I always thought the GEM deal was just an add on to the TV coverage, and not an essential part of the deal. Thereby we are just lucky to have this given to us.
Personally i'm not really into watching delayed NBL games on Sunday afternoons. Live yes, but not a replay of the Saturday night game. I'd much rather a highlights show instead, or if they have to show a full replay, can't it be one of the better games played in the round rather than be forced to watch whatever game was on Saturday night?
I agree the NBL is shite without reasonable free to air.
It is a major step backwards in bringing Basketball to more of the community as the NBL Aspire sprukes.
Empty words.
Even the game threads aren't getting the usual interest.
I could afford the phone app but I could not enjoy trying to support my team on such a small device. That is certainly a novelty more suited to children.
Maybe after syphoning for a season and the rate of new foxtel contracts decreases they will release some friday night games again.