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

Years ago
Potential NBL dunk comp format
Huge fan of these ideas !!! As mentioned in another thread , this could really raise the profile of the Blitz Tournament. It would also give fans and media the chance to see some of the new imports and rookies before the season starts.
I got no problems with an all star weekend being at the start of the season with the Blitz :P

Years ago
I think most importantly this would give the league some stock footage to use for promos, especially if you have a few different angles.
You can show some in game footage, with a montage of these dunks throughout.
