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(33059)
}
}
Any system would need to ensure that juniors are not compromised. It would be terrible to see a player who started in U10's not be able to play CABL due to an administrative ruling. Perhaps those players who have come through the junior ranks are exempt.
I think the real issue with the CABL is the distribution of elite players between the clubs. Having a draw like the Crows used to have could help, but having elite players play is better than not having them play at all. (ie dummy spit because they are forced to play somewhere)
I know a former SOS member was talking about allocating a Sixer per club to try to build the relationships between clubs and the Sixers, but never grew legs.
As with any system, planning is the key. Why is it needed in the first place? What are the aims? How will one know if it is working? What is the process to refine it if needed?