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(3672)
}
}
We played under 12's at Marion and ended up with 2 players on the court out of 7 starters. 12 months later we are back and had 2 players on 4 fouls after 5 minutes of play. The kids didn't deserve that treatment. After some intense discussions with the refs the fouls amazingly balanced out. Before we left the next game had started and I can still see the incredulous look on the Sturt coach as she was trying to fathom out what was happening to her team. She was getting the same treatment, 3 fouls in 2 minutes.
Let's face it. Refs are hard to find, and good refs are rare. Many stadiums have kids from their junior ranks run around with a whistle.
The stadiums I dread going to because you expect to be up against "The Ref Factor" are Pasadena and especially Marion.
Sometimes you feel like giving them a well-deserved serve, but it would only benefit the opposition.
Last round at Marion (Fri nite), 2 players were in charge. Ref 1 made a totally shit call, then threatened the player with a Tech for responding. Ref 2 actually told Ref 1 that he deserved the spray.