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(30138)
}
}
You can fail level 2
level 2 has changed since i did it back in 2000. Most clubs don't even check anymore if you have a level coaching, they will ask but not follow up because like many they will initerview you and if they like the person they will hire you.
At the bigger metro clubs, all div1 coaches are required to have level 2 credentials.
However, as I understand it the grading system is changing from the level 1-2-3 to a more sectional system with the lower level(s) described as 'youth' or 'school', the intermediate levels being 'district' or along those lines, succeeded by 'higher level' or 'state', for example.
Acquiring level 2 may help your chances, but with the new system (implemented in ~1000 years) it may be made redundant. Anyway, your coaching ability and (sadly) being in favor with the right people are the predominant factors in moving up.