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(18357)
}
}
While you can't guarantee the Sixers as a team for the new league; you can easily say that they would be one of the teams most likely to survive. Anyone wanting to invest in a team for next year would be able to look at crowd turnouts, season ticket sales, marketing etc. etc. and Adelaide pretty much leads by example in most fields.
Not too bad when you have a strong support base with devoted fans and a track record for brilliant players (not consistently, but it's still there).
I think you would find Clubs like Perth and Adelaide will stay around mainly for their current states. At present I think the hard part is places like melbourne where you have 2 local teams who both have a decent fan base and potential "profitability".
I would like to think that every team would be staying. This season has probably been one of the most up and down starts I've seen in a long time. The "culling" of other teams has made for a stronger overall collections of teams "player wise".