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(33813)
}
}
Squad is as follows:
Brent Hank (centrals)
Marco Bancevic (Southern tigers)
Brad Ficken (southern Tigers)
Aaron Humphries (Southern Tigers)
Luke Surmon (Norwood)
Jackson Frisbee Smith (Norwood)
Cale Matthews (sturt)
Nik Fassos (Sturt)
Jacob rigoni (Sturt)
Angus Rodman (sturt)
Xavier OT (sturt)
Madit Daniel (North)
Ngor Daniel (North)
Will Gleeson (West)
Akol Deng (West)
I know for a fact that isn't true idle one, they have the best defender in the state in that 15 man squad, and half of the other are perfectly adequate, maybe 2 or 3 are solely offence based