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(28968)
}
}

Years ago
NH: Reported that Primus has been sacked
As an avid Norwood Redlegs fan I'm hoping he takes over as head coach there. Brings back another ex norwood boy, he's young and can hopefully continue on from Bassett who I'm 99% sure will get a gig in the AFL next year.
Port should definitely look at Bassett and Bassett should definitely look at Port. Young coach that has already turned around a proud SANFL club and made them into a dominant force. Bassett I would expect would welcome the chance to stay in Adelaide, he's coached the likes of Rodan, Renouf, Pfeiffer, Phillips, Jonas and Thomas, all who could be regulars in the side. Throw in good mates Rehn and Edwards beside him and I think he'd be sold!
