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(29162)
}
}
, "some clubs are realistic and put their teams in relevant divisions. more likely to get more from these kids long term some others do not - get flogged and kids quit after one / two seasons. pride before the fall"
You are quite correct with that statement. Player turnover is a cancer at clubs. I looked at a group of kids from U12 to U16 and there was a strong correlation between success and retention. The top 3 teams had much higher retention rates (80%) than the next 3 and the bottom 4 teams basically had a 20% retention rate.
Some say it's chicken and egg scenario as well. Is player turnover a symptom, or an issue? The more success, the more motivated players are to continue, whereas the lack of success means lower motivation, breeds dis-interest, they quit and other players need to be found. New players need to catch up to teams that have been together since U10, they can't, a spiral of doom starts.
The best games are those close, tightly fought games. Players never learn by getting whipped by 50 points a game week in week out.