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(9786)
}
}
Solution to the problem, don't have people sitting in front of horn blowers, put the horn blowers in the front row of the east and west stands. Ideally have them change sides at half time so they are always at the opposition's end.
Ricey, it wouldn't work to have individual clubs make a decision on them as individual clubs would not ban them and create an advantage to the visitors when their own team plays away and is disadvantaged by a club agreeing to their use. It needs to be a standard ruling across the whole NBL.
I think the problem is the onus in the past has been on the clubs to control the noise makers/generated fromt the crowd.
It's a case of one individual taking it too far and ruining it for everyone.
I remember people at the Powerhouse, Melbourne Park, Vodafone and the SNAHC being asked to refrain from using the horns or they would be confiscated. After people around them had complained - this I thought was a good way of handling it.