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(18208)
}
}
I suppose if you got the media on board, then advertising and promotion would be right down.
Sounds like $3M for a "budget" club, and possibly $10M for a big club. Still outside the range of my chequebook.
What would the deal be with the NBL? Is there an annual fee per club, or does the NBL distribute excess funds to clubs based on profits from global merchandising, TV rights etc ala the AFL. With the AFL, they seem to control the direction of the sport and then pay each club a "dividend". The Crows are owned by SANFL and distribute their profits to the nine SANFL clubs at the end of the season.