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(44307)
}
}
The only issue I see is whether or not the cost of rights outway the potential audience and reward. Particularly on weekdays.
With ESPN having the rights to a lot of games as well. Is it possible to even get enough high quality games shown on weekends when I would imagine it would rate best.
Yep, in the past there just was not widespread enough interest to warrant a station investing in the rights for only a few thousand to watch. Having said that, I see ESPN games now getting the occasional 30-40K ratings for bigger games, in line with the NBL, which it used to only get for Finals.
So maybe interest has grown and it's worth another crack now basketball's popularity has grown in recent times and there are lot more Aussies in the league.