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

Years ago
National advertising campaign for NBL
YouTube Video <object width="480" height="295"><param name="movie" value="http://www.youtube.com/v/sCrYhq5Uo1Y?fs=1&amp;hl=en_GB&amp;color1=0xe1600f&amp;color2=0xfebd01"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/sCrYhq5Uo1Y?fs=1&amp;hl=en_GB&amp;color1=0xe1600f&amp;color2=0xfebd01" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="480" height="295"></embed></object>
Anonymous
Years ago
First NBL commercial I've actually liked in recent memory.

Years ago
agreed Isaac, there were alot of football references with the penalty kicks and nil all draws which was uncalled for. they would be better of saying 'no single points awarded for just hitting the rim or back board'

Years ago
Sounds promising, and good to see a well planned integrated marketing communication mix being employed by the NBL.
