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(36065)
}
}
Fair point HoldenV8, though most of the guys on the list have State or National rep basketball experience so they'd be more than decent. Plus that Nic Nat dunk it just crazy haha. I guess it'd be a structure thing that comes with playing the game. Same if basketball players had a go at footy, even if the skills are there, chemistry and knowing where to be at the right time is key.
Thanks Isaac, will look them up! Tried in include a few of the new crop, so hopefully it's a fresh look at an oft-done concept.