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(35518)
}
}
Man it is so easy to be a knocker! This club obviously has someone with video / editing skills and NBL passion. I wish every club was doing stuff like this to connect with its fans. At the moment the fans dont' really get to see the players personalities etc.
It doesn't matter if this isn't the best song in the world or the best video ever. it gives an insite in to the players. Shows them out of their comfort zone but having a bit of fun.
Well done Hawks for setting a standard in this area, like Melb are now doing with their use of social media and Perth seem to do with jsut about everything else.
Love the concept for a team building exercise. The final product is a bit long though and lacks Jahii Carson dunks, which is really the only appealing thing Hawks have to offer this season.