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(30984)
}
}
1. Norwood 15 W 3 L
2. North 15 W 3 L
3. Forestville 13/5
4. Centrals 12/6
5. Mavs 10/8
6. Southern 10/8
7. Sturt 6/12
8. West 4/14
9. Woodville 3/15
10. South 2/16
We know there has been a couple of coaching changes that will make things interesting but before anyone can make any predictions, we need to know of any final changes to teams and coaches.
It's fairly safe to say that Norwood (Lightning Flames) should be top 5. Sturt would not be satisfied with that placing and South have been on the hunt to strengthen their squad. West sound like they might still struggle this season and Forestville are the number 1 girl's club at the moment.