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(21511)
}
}
The only strange issue I have had this year is the game where Adelaide hosted Melbourne and the scoreboard showed Adelaide winning comfortably, then the ticker kept on piling points on to Mark Worthington and then then next thing you know, the Tigers were on top. Weird.
It's amazing how quickly people start to utlise things when they actually work properly. While those stats showing improvement are good, the league is probably 5 years behind where they need to be because of past failings.
Now if they sort out the player stats on the NBL website, they might actually get more hits there too.