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(36089)
}
}
@Dazz, I think the plan was initially to establish stability with a one team per town philosophy, but as popularity and change developed the A-League so to it's owners and chiefs realised that cross town rivalry was essential...
The fact the A-League totally re structured and worked towards creating teams with a tribal and cultural following, plus games that are truly considered rival games, is also very important to remember.
Now they are on Foxtel and Free-to-air, so they are flying, but they have proven to be careful not to over cook it in the past as they can spoil what they have worked hard for if they are not careful...
The NBL needs to create and build what the A-League did many years ago, but that would not be an easy task!