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(29838)
}
}
The goal is to bring the Hawks community/Wollongong together behind the Stronger slogan..
In under 24 hours i've already seen countless tweets from fans of the Hawks and some that are not even in this country, tweeting about how much the video moved them, how much they love the video, that they've watched it countless times and one girl/lady even saying that she was going through a hard time at home and the video has inspired her to "get off her arse" as she said.. People relate to things on different levels.
What's it achieved so far? I think club pride and more of a family feel amongst Hawks fans.. Something a few clubs could do with right now.