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

Years ago
AFL TRADES
October 13, 2006 COLLINGWOOD has traded forward Chris Tarrant to Fremantle in a three-way deal that will also see former Dockers key position player Graham Polak line up for Richmond in 2007.
In a complicated three-way deal, the Magpies picked up Dockers small forward Paul Medhurst and draft pick No.8, which was ontraded from Richmond.
In addition to Polak, the Tigers received pick No.13.
here is the link
http://www.foxsports.com.au/story/0,8659,20574119-23211,00.html
