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

Years ago
New NBL TV ad on YouTube
I know I'll get shot down for this but my issue with that advertisement is seeing Deleon and Jackson and even Lemanis... As an impressionable little kid watching the ad and wanting to see those players play and to find out that they aren't around... It makes no sense.
I love the concept but that extra time should be spent on showing players in their current teams doing what they do best for example Oscar Foreman knocking down a 3.
As for the coaches... Didn't like Lemanis in it (same league as Woolpert and Bevo in my opinion) but seeing Hammer and others going off; I absolutely love it

Years ago
That's the most I've ever seen any Perth team feature in an advert for a national league, lol
