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(13921)
}
}
I actually enjoyed the fact that the 36ers had finally found the "ha ha" sound bite that you hear at every other stadium. Now, we just need to play that after every missed free throw for the opposition, and get the cash register "cha-ching" sound for every free throw that we make.
Dragons have music played but fairly quietly for a good portion of the game, and crank up the 'special tracks' for key moments/exciting plays etc, it's almost like they use it to build the game up to the end of each quarter works really well.
Also they have 2 guys on the bench both on the mike that are more like your tv style commentators than your traditional courtside commentator.
Calling the play without overcalling it (heaven forbid if we had to listen to casey and carfino live at games!) for a game situation, rattling of various stats some really interesting stuff that adds to it all.