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(4167)
}
}


Years ago
Their was some good stuff there! :-)
I think the old banner competition should be re-introduced to encourage the youngsters to get the texta's out and mark up some board. adds to the atmosphere.
Maybe give a prize for the best banner over the season - take a little video tape of banners at each game - parade them on court at half time.
Throw them all up on the new big screen at the last home games and let the fans vote with their voices as to the winner!
Give the winner a nice prize of merchandise or some tix to finals.
