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(11393)
}
}
Level 0 and Level 1 umps were paid the same rates on the weekend. There was an absolute shortage of refs and the situation was a joke as some youngsters were at their limits by lunchtime yesterday doing 4 and 5 games straight etc. Thats the only downside I can see of having the champs over one weekend because the refs have no time to regroup and even get some food into them. What also doesnt help is by Sunday some of the Parents need a cup of tea and a good lie down- many out there should be shot for comments, dont they realise without refs there is NO game? Its is after all a game albeit important but surely not life-threatening if there is a no-call or not what u want called? Some people need to have a hard look at themselves. Apart from that congrtas to the winners and the organisers and the refs who will all be very sore and tired today.