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(18282)
}
}
Really tight finish now so all home games are must wins:
Currently sitting 8 & 10 looking for 50% as a min win ratio. We need to knock Sydney out of the top 6. Spirit' last games are NZ (3), Cats (3), Hawks (2), Taipans (2)
We have Hodge who should have learnt the ropes by the next couple of games. That should make a difference to the team going forward compared to what's already been achieved with Tyndale. They can win most of the remaining games but a lot will depend on Ninnis. Also injuries will play a part.