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(34172)
}
}
By all means bring an orchestra into an enclosed stadium like they do in the USA college games, great atmosphere and people actually get to enjoy it, plus they have a designated area, you won't end up directly in front of them.
Compare this to being stuck in front of some buffoon blowing an obnoxious sounding horn directly into your ear all game, really, patron ends up with a head ache and not returning to the next game!
Great to ban these things from closed stadiums, but I would like to see any sanctioned or coordinated and controlled effort that is approved and in a space of their own considered, that is another story.