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(9074)
}
}
The 36ers definitely need stronger "Branding" and marketing than is currently used, especially at the Dome.
I notice at Brisbane, they have huge player photos hanging up around the stadium, and somebody has commented on the bus advertising there.
Dragons have their slick "OFFENSIVE" and "EVOLVE" billboard campaigns in the CBD, as well as the TV ads such as the ones shown on ESPN during the NBA Finals series. As well as the huge Dragons logo branding throughout Vodafone Arena, including the huge logo in the centre of the court, and the logos throughout the stands.
The 36ers definitely need to send some of their marketing team around the country (and perhaps to look at what is being done in the US) to see what is being done elsewhere, as well as looking to see what we can come up with as fresh ideas.