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(14080)
}
}
Well, I have no idea which way this game will go. We haven't seen Hodge in action except for 1 game only a few days after he arrived in Adelaide and minimal training. Reports about his training since have all been positive but he still knows nothing about the opposition because he hasn't met any of them on court. Adelaide have had several wins in Perth in the last couple of years so could realistically win this one. The Cats are usually strong at home so Adelaide could lose this one. Oh dear, all this confusion and still don't know which way to turn. Good luck 36ers.