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(44321)
}
}
One game comparison: NBL game call superior to NBA
Tommy Heinson (Boston colour commentator) is known as the worst homer in NBA broadcasting. There are some good crews around, there's isn't one of them. I'm a Jazz fan and can't stand Harpring on any game, will regularly watch the opponents feed. The days Harpring has off, Thurl Bailey comes in and is excellent.
Hard to beat Kevin Calabro (ex Sonics 'magic carpet ride' play by play) who now calls Portland games.
I enjoy most of the NBL guys with the exception of Russell.
The ESPN feed for the Celtics Utah game was the local commentators, it wasn't a nationally televised game so they are supposed to be homers.
The NBL guys are supposed to be neutral.
Also good commentators don't call every play on tv. It's not AFL you can see who has the ball. They are supposed to be able to tell what the refs call though which the NBL guys are hardly ever able to do.