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(2777)
}
}
DC, the "poor" attendance at Pasadena seems that way because there is plenty of room to move. You shift half of those people (Sturt) and move them into Hillcrest with the other half (North) and you get a very tight squeeze. A stadium seating 2,000 spectators and only having 500 is only a quarter full. A stadium seating 200 and having 500 is bursting at the seams.
Why promote the North vs Sturt game? Hillcrest has got no room to accomodate all the spectators. All you are doing is bringing in hoards of people only to get turned away when they get there. Isaac, you should make a deal with the North Adelaide club that you'll promote it on the condition that they set up a temporary stand to accomodate additional spectators. I hate that stadium, its a health hazard.