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(36627)
}
}
I don't think Ten/One care very much. I might have been the only one watching it, but the One coverage of Sunday's Perth/Cairns match was embarrassing.
They forgot to play adverts during the half time break, reverting to the NBL TV coverage. This included the sound check and other dodgy stuff I have never seen on free to air TV before. Seriously, a test pattern would have been more professional.
Then, as someone finally remembered to run the adverts, they repeated the half time segment and then ran more adverts, only to jump back into the third quarter with 6 minutes to play. It reflected very badly on the NBL, don't know whether that was the NBL's fault or Ten/One.
I think running some Sixers adverts after the end of the season is the least of their problems.