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(36725)
}
}
I have always wondered why the Adelaide Arena is so special and spectators have to be removed from the ends of the court. I would expect these officials have attended games at Marion Hillcrest, what is the difference?
Access to score/time info for bench personnel - scorers etc as well as coaches - on the 'side' court is a genuine issue, which can hopefully be resolved in the short term by addition of a plug-in [wireless?] extension from the bench to a visible score board.
From a comfort perspective spectators could sit on the far side of the stadium, which would enable them to see the time/score, but it's a long way away from the action, and they would be looking across the action on the 'centre' court, which would likely be distracting.
That said, it was good to have a more 'carnival' atmosphere than you get at a 'home and away' fixture.