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(3712)
}
}
Heres a match report with Oscar getting a good mention:
Sunday, 24 July 2005 @ 8:22 PM
sportal.com.au
An inexperienced Boomers line-up has completed 3-0 sweep of Japan in the Kirin Cup series with an 86-58 win in the final game.
Australia dominated Game Three in Tokyo, taking the lead with five minutes left in the first period and never looking back. The tourists led 21-12 at the first change and 49-23 at the main break.
Japan was more competitive in the second half but was still outscored by two points. Centre Oscar Forman top scored for Australia with 15 points, Alex Loughton scored 13 points while centre Wade Helliwell contributed 12 points.
The victory completes a successful series for the side after a close 69-65 win in the opener on Thursday and a 77-61 win at Omura in western Japan on Saturday.
Brian Goorjian's side now head to China for the Boris Stankovic Cup. The Boomers will face Argentina, Puerto Rico, Angola, Lithuania and China within five days of each other.