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(253)
}
}
I've been trying to send you e-mails when you mentioned a job, (when I complaiging about mine a couple of weeks ago) but my outbox is busted. I'll get on some uni cpus this week and contact you.
The three ball was paramount to Perths last title. 943 and king only looking at 3pt% to determine if the shot is valuable is borderline idiotic. Did you consider total 3P attempted and made? Even if you didn't having the threat and reputation of multiple players been able to hit the shot is almost as good as players actually hitting the shot at a high % (Terrico last year was a great example)it stretches a defence which allows your offence to rumble along, allows more offensive rebounding opportunities etc. Whether the team hit the threes at a high percentage or not is merely a piece to the puzzle. You just need to compare perth the year we had tokoto, our offence grinded to an absolute halt because him , martin, knight and brandt could all be left half a court and they still couldn't consistently make a three.