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(1179)
}
}
Relating this one to Alf's- i was aboused by a parent of an not very liked club physically in under 16's whilst waiting for my dad to come pick me up.
I have also been abused by many a parent whilst refereeing and threatened to be assaulted and other various things.
I have also been apart of teams where there are certain parents who were pains.
But i have also seen parents who are well mannered, and give up effortless amounts of time and energy just to benefit their kids.
Education and the factor of ignorance plays a big part.
Just an idea would be to have all parents of all age groups attend a session or 2 about coaching and refereeing(have to be carefully planned to allow time for babysitters, work etc) in order to increase awareness etc. That way the communication and understanding barrier could be decreased and or eliminated.