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(3043)
}
}
diddy - from your last two posts, it obviously you know a truck load more then me, but yes, they are in order. Unfortunatly i have no reason for that placing, and can't back myself up. I'll just cross my fingers, and cop the results on the chin in a few months time.
enlighten us with your predictions and well make a contest out of it.
on a side note, did see New Zealand play in Albury in Jan and they looked very impressive (not sure if it was 18's as well, but 16 were awesome, medalled, and dunked ON that's right, on one of my players.)