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(11005)
}
}
Numbers should be the focus - Target A) min 1000 spectators to 50% of the games and B)25% increased spectator numbers over the previous season. How do they achieve that?
Part of the answer is move to a venue that can accomodate the numbers - So Wayville is not really a viable venue, the Dome is.
Creating an atmosphere on game day is also part of the answer. Apart from non match entertainment, a venue that is less than half full is a bit of a morgue. A reasonable objective for the light. admin. is to "close up" the dome on game day so that the crowd feel like they're part of the game and are still comfortably seated.
Consitently getting 1000 people to a game? Promotion, Promotion, Promotion and then make the fans feel part of the family.