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(33745)
}
}
Yeah, I've often thought that would be a good idea for the Wildcats, too. Guys like Watterson, Torrance, Rogers, etc. deserve recognition, but not retirement.
Weren't the jerseys retired for the same number of years as the number on the jersey? Think that was mentioned on one of the docos Adelaide did.
"the singlets hanging on the wall were definitely retired, however those numbers can still be worn by other players."
You don't know what 'retired' means, do you?
You want a retired jersey to mean something. I like the idea of the retired jerseys begin for the Club Legends, whereas those players who have played X games, or won two titles, get an honoured spot as a fist step to the retirement.
I have often thought that the Sixers could have jersey points around the stadium with a jersey number and who has worn it over the years. Could be something to make the stadium a bit more interesting and also a possible meeting point?