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(9615)
}
}
I hope Josh Wood does become a 36er in the future, as he has already been to Port Lincoln with the team and i remember Smyth talking highly of him in the paper, i think he is a 6-8 g/f so he and Hill if he stays could fill the roles that people would have like Newley and Ingles to be in for the future, even though it would be sweet to have all 4!!
I think they should keep a track on sites like this one as it gives profiles, stats and stories of all the Aussie college players, one SA boy who they should watch is Ryan Kirsten i remember seeing that doco on him ands Ingles and seeing how there careers turn out with the paths they have chosen