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(25069)
}
}
But here's the interesting one - as good as all these guys were - so was Mitch McCarron - shown the door from the AIS less than a week into 'Stacker time'.
Mitch McCarron
15.7 pts (10th)
9.8 rbds (3rd)
3.7 ass (=2nd)
58.5% FG
14.3% 3Pt (1-7)
70.8% FT
Those numbers stack up pretty well to me - particularly for a 6'1 kid playing out of position at power/small forward, on a team which pushed the Vics all the way. (Naturally a recently-departed AIS attendee (who hasn't gone onto the NBL) doesn't make a good case for the Staunton Award).
Not saying Creek wasn't deserving but as has been pointed out, there were a number of other worthy candidates.
Just wondering what the refs earnt per district game. I understand that this varies from game to game eg seniors and juniors. Also how does this compare with umpires in different sports?