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(23394)
}
}
BA should focus on reinvigorating the NBL and then perhaps look to being represented in a Champions League style competition, sort of like the A-League where the minor premier and the championship winning team get invited to take part in...
Having team play in 3 different locations wouldnt work IMO. I like to feel some sort of 'ownership' and having them play home games all over the place wouldnt cut it for me. Id probably watch out of interest, but couldnt see myself as a passionate supporter.
A champions league is an interesting idea, but I see that as more a reward for the top teams who qualify rather than a promotional tool to increase the popularity of bball in Australia. Sure it would gain the competing teams extra publicity and the sponsorship taht coes along with it, but would a Tigers fan really give a toss if the Blaze were paying Shingdingdong in a super league game 4 weeks after the NBL season ended? Maybe but Im not so sure.