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(28087)
}
}
Actually, the Singapore "experiment" had a lot of merit to it. There are a lot of ex-pats in Singapore and a lot of business interests. Big businesses like to keep ex-pats happy so having a basketball team is something that they get behind. I think the thing that killed them off in the NBL was the travel expenses/issues. At least a second or third team based somewhere in Asia (or Darwin) would help.
The league they play in now is the Asian Basketball League and I saw them play a game when I was there passing through. The standard wasn't that great, but the atmosphere was pretty good. There was a guy called the "Turban-ator" who had a mobile phone business. He was holding up signs putting the opposition off when they were taking free throws. Harvey Norman were right into it and had their blimp buzzing around inside the stadium.
We should all write to the NRL saying how bad they are with their current coverage of "live sports".. Seeing as thought apparently no one has complained about the NBL coverage this year..