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(22806)
}
}
Nice, agree it would be good to see a commercial like that for TV.
Enjoyed seeing all the old uniforms,really liked the ones worn in the Green and Pearce clips.
Seeing the uniforms have been slightly plain of late thought it would be cool to bring back that funky blue red yellow stripe/pattern down the sides.
That was pretty good. I like the backing track. Someone (Coops) has dug up some nice archive material as well. I love current ownership's continued efforts to sell the club's great history.
Perhaps Cattalini could get a nod in there? He was a key player in a couple of championships for us.
Heh. Reminds me of the idea I came up with last year for the TV commercial. With a bit of tweaking and some enhanced graphics, that could make an awesome commercial for advertising season tickets.
But dayum, that music is so god-awful.
Is this a subtle hint that someone has been signed or is close to signing that could be an exciting new import?