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(25195)
}
}
i.e. a div 1 player with a possible sasi / state / well credentialled coach pays the same fees as a div 5 player with a mum / dad coach (or even no coach)
obviously the clubs have a basic expectation for their budget ie 100 players @ $250 fees etc - but teams that have mum and dad coaches (or none) should be discounted.
Which leads me to the next topic - should we be offering a coaching payment for teams that can not get a coach ie a club appoints a "flying coach" who will move around on game day and cover what games are short - they can be reimbursed / paid a small fee ie $15 a game
ie they fill in at 0800 for u10s then 0930 for u14s then 1130 for u16s etc - where ever the clubs shortfall is.
If a young person could make $30-40 from this it may attract some