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(1396)
}
}
They should do a poll on which days of the week are best for these games. I personally can't understand why Sunday afternoon's do not attract crowds as this is the only time of the week that most people are not usually commited to anything. It is a day of leisure that you devote to doing anything that you want to unless you are an emergency worker. The weather yesterday was not even warm for those who prefer the beach.
If Sixer's admin still hold records of previous season ticket holders who no longer come to games, it would be a good idea to send them a questionnaire on the reasons for not renewing. They could make it worthwhile by giving away a free ticket to a game for every questionnare that comes back. That would serve 2 purposes, firstly to find out the reasons why and then act on it, and secondly, bring these people back to see that it is just as exciting now as it was before.