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(28128)
}
}
In the Boys state, I have compared the seedings to the final rankings for summer season. (Yes, I realise BSA only look at it after 9 rounds)
U12B State: Seeds are same as final ladder position at end of season
U14B State: Seeds 1 to 7 same as final ladder position
Forestville Seeded 8th, finished 9th
West seeded 9th, finished 10th
North seeded 10th, finished 8th
U16B State: team,Seed, (ladder)
Forestville 1 (2)
North 2 (1)
Sturt 3 (3)
Norwood 4 (4)
Southern 5 (6)
Mavs 6 (5)
Woodville 7 (7)
West 8 (8)
South 9 (9)
Lions 10 (10)
U18B State: Seeds are same as final ladder position
In the boys state, probably close as can be.
The top two teams per div for me (and the most likely GF)
U12: Forestville v Woodville
U14: Norwood v Southern/Sturt
U16: Forestville v Sturt (The Forestville-North prelim to be the defacto GF)
U18: Forestville v Sturt