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(19804)
}
}
Totally agree with connecting with China. If we can sort out our league and get some financially stable clubs, I think our first priority should be to get an end of season tournament running with the Chinese and perhaps The Phillipines as well. Top two NBL clubs qualify and play the Chinese and Filipino league winners. Sell the rights to One HD and make it a decent amount of prize money. You have the embryonic stages of an Asian Champions League of basketball.
I have very little doubt that this would be a success and attract the kind of domestic interest basketball in this country needs. There would be a lot of people who would tune in to see an 'Aussie' team take on overseas competition on FTA. Get people interested in an NBL team that way, and they will naturally start to pay more attention to how that team goes in the national league.