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(27306)
}
}
I just found it interesting/strange that the players didn't rate Jackson very highly as a PG considering he leads the lead in steals, assists and rebounds from the PG position as well as great speed and ball handling skills.
My flatmate chats to him a fair bit on FB and she reckons he seems like a really nice genuine guy who is really enjoying the league and playing with the Breakers guys.
Not heaps of surprises in there, was interesting that Beverdige didn't feature as a coach people wanted to play for. I've done more analysis on my blog
Interesting results. Would love to see the entire list of which coach players would most like to play for...
And apparently Perth has more knowledgeable fans than Adelaide while the Adelaide Arena is no longer a feared place to play. Gee I wonder why that last one is????
And Murray is the best mascot in my biased opinion :P