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(28397)
}
}
If I have the ability to find a cost effective way to store games online for download, i'm sure the NBL could.. You'd hope!
If it was a league pass like set up, i think 1 camera in the middle & maybe (because of costs) 1 other camera at one end. If you had the cash, 2 cameras at either end.
As far as commentators go, yeah NBL radio is good enough, or have a comp to get some savvy fans to commentate a few games. Obviously they would need to fit a number of criteria to get the job. None paying job mind you.
Some GMs are pushing to own their teams rights so they can sell them locally, others are pushing for a league pass like set up. But I haven't heard anything official yet.