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(20717)
}
}
I have trawled and found Mickey McConnell's blog on the SMC website...looks like SMC beat the AIS.
"Day 3 - August 11 - In Canberra vs. Australian Institute of Sport
Today we got our first victory of the trip against the AIS, which has been the breeding ground for our Australian players over the years. Patty was in attendance with his parents on his 21st birthday and it was a nice reunion for our players to see him. Also, it was a nice reunion for current teammates Ben Allen and Clint Steindl and coach David Patrick (played for the Canberra Cannons) who took the job of showing us around the facility. The facilities at the Institute was like nothing I had ever seen and had facilities for over 25 different sports.
After the game and a brief ice bath we were back on the road again for Sydney. After the uncomfortable three hour bus ride in our "tour bus" it was time to get some rest before our day of siteseeing tomorrow. "