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(30629)
}
}
I'm a wildcats member and our announcer is tolerable and can do a bloody good job getting the crowd up as he did in 4th quarter during Crocs game but he did play pointless music at wrong stages and that didn't help the play.
I hear Adelaide's announcer is the worst though but I think announcers should be held accountable for how they perform even more so than players (players shooting 50% can win games more than an announcer that does the right thing half the time)
Oh and congratulations Melbourne/Victoria, good signs as I hear the Tigers owners are really pushing the community but still not enough to deserve a second team in Melbourne.