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(20594)
}
}
Yeah, could definately enjoy seeing and hearing the boys do warm ups to "chase that feeling" by the Hoods, then the lights come down for player intros.
After that, National Anthem (whilst lights are warming up again, and a spotlight on the teams, or even the have a display of the court name up on screen), 2 minutes coach pep talk, then THUNDERSTRUCK until we score our first basket...
The problem with that sort of intro is that the players are introduced about 20 minutes before tip off but the stadium is less than a quarter full at that time. Its only in the last 5 minutes or so that the stadium fills. You wouldn't really have a great effect if it was done with so few fans in attendance.