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(44189)
}
}
I put this out on Twitter today... How many imports have played in the SEABL before they made an NBL roster? (I'd actually like to have a list on the NBL Wiki site..)
Got some good answers:
Mike Kelly
Matt Reuter
Jason Sedlock
Damon Lowry
Eric Cooks
Shawn Redhage
James Smith
Dave Gruber
McCowan
Tory de Vries
David Biwer
Kevin Ratzch
Thalo Green
Sidney Goodman
Mike Spears
Andre LaFleur
Willie Jennette
Billy Fikes