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(28104)
}
}
To expect Channel 7 to give many negative reports on AFL is a longshot. C7 are Australian Football through and through. They have invested millions into the TV rights and this means that they need to attract interest in that sport to then create an income stream through on air advertising. The higher the TV audience, the more they can ask for advertising. They don't want you as the armchair couch potato to watch a rival sport.
"Puff pieces" like an AFL player cutting his hair for kid's cancer, or an AFL player retrieving a wallet from the mouth of a crocodile, or proposing to some chick along Cottesloe Beach he met at some nightclub the night before are always going to be received favourable publicity.
The NBL is just one voice shouting in a room. The media is the bouncer on the door of the nightclub letting in who they want.