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(11939)
}
}
I feel like the original idea is interesting, but as touched on before there is one major difference between AFL and the ABL clubs, and that is junior teams.
I agree with Who Me! that if you went up through the ranks with one club, it would be highly difficult to go to your rival (imagine a crows junior all the sudden being drafted by the power?) I feel the only way the draft would work locally would be if the top level ABL sides were not affiliated at all with any junior ranks, removing this issue. As clubs are already established this is obviously not an option.
What do people think about bringing in tougher zoning for players, eg if you live in Marion you must play for South, unless there are extenuating circumstances where you could apply to play for another club, subject to approval.