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(4132)
}
}
Adelaide has a large ethnic population that follows the soccer, particularly Italians and Greeks. It is the equivalent to Aussie Rules Football for them. It will always get a good following. For me, soccer does absolutely nothing. I find it one of the most boring games to watch but not everyone thinks the same. I don't think advertising well is going to solve the problem for basketball, its more a case of trying to make a culture change. Not many people understand the rules of basketball and for that reason cannot get enjoyment out of it. One of the things that comes with Australia being a multi cutural country, is that you have to share its audience with many other sports, particularly the ones that are common to the countries that people come from. I doubt its a way of advertising that is successful for Adelaide United, its just that it already has the soccer fan base here in Adelaide.