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(18744)
}
}
So Cat57,
Like I say to all the guys I manage "Don't come to me with problems, come to me with possible solutions"
What sort of things would you like to see at these games? Half time entertainment? Skip could only spread himself so far around the games, but imagine Skip running the musik.
Some other marketing initiatives.....
Centrals could have the Paddle Pop Lion handing out ice cream, Southern could borrow Melbourne's tigger. Forestville have got Eddie the Eagle. Maybe South, Sturt and West could sell scratchies (all are scratchy cats) Norwood could give everyone a candle to light, North could have toy rockets, Mavs could have a shoot off with toy guns and finally Woodville would sell shields and swords to avid fans