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(11698)
}
}
here's the deal.
the only person to converse with an umpire is the coach or in their absence, the captain of the team. there are guidelines in place and when rules are broken they need to be followed. if there are abusive comments or gestures to an umpire, inexperienced or not it is the UIC responsibility to ensure that umpire follows them. if managers are abusive the technical foul should be used against the bench, if it happens again a second tech can be given and people can be evicted fromt he stadium. it needs to be done more often. its the only way people will learn. more directly, perents can be evicted straight away. soon they will realise that if they want to see their children play they will have to keep their mouth shut or be more respectful when its open!