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(24167)
}
}
I think it will cool off as the season goes on. As soon as some of the big names start getting suspended for having to many techs stern will make the refs ease up....or at least I hope. Anyone see the tech Kevin Martin got in the season opener against the lakers??? running away from the refs shaking you head after a soft as butter foul now constitutes a tech.
I think they'll back off a little bit over the course of the season. What I see them trying to do is restrict 'emotion' to when the ball is not in play - time outs, end of quarter/game. That is a more appropriate time to show emotion and engage the fans; when the ball is being inbounded from a made basket or a foul is called that a player objects to, I think the best thing is to just keep the game going.