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(28271)
}
}
If we want to get serious about creating a strong comp in SA then we need the best players/teams playing each other week in week out and if that means the stronger/larger clubs have two teams in div one and 3 in div to then so be it...
Take the U12 girls for an example.
In Div. 1 they only have 8 teams as Centrals and Woodville don't have a team. In this 8 team comp the Eagles are top with a 461% and South are bottom with 11% whilst in Div.2 the Eagles are top with 517%!! Sturt are 2nd 441% and even Sturt 2 (third team) have a 243%...!! Surely one or two of those Div.2 teams are stronger than the bottom 4-5 teams in Div.1?? Surely this is a better option then hoping players in div 3 will leave a strong club to play div 1-2 at a weaker club as this clearly hasn't happened... Ultimately i think Div. 1 should be for the best teams and the standard Div.3 style summer season pro/rel would determine who those best teams are...