Lake Run Club Circuit Points
Award Winners
Return to Lake Run Main Page
Contact our Pointmaster for Corrections
View your races
View total points
View point break down for each race
7 or more races plus 50 volunteer points qualify you for a circuit award. 5 or more races qualify you if you are 14 & under.
Here are the members that have qualified for a circuit award so far.
Resource id #2SELECT szfullname, count( * ) AS cnt
FROM tblCircuitResults
WHERE iMemberID
IN (select p.memberid
from members m
inner join VolunteerPoints p on m.memberid = p.memberid
inner join VolunteerEvents v on p.eventid = v.eventid
group by p.memberid
having sum(v.eventPoints) >= 50)
and iAge > 14
GROUP BY iMemberID
HAVING cnt >6
order by szFullName| Congrats to these members |
| Les Usiak |
| 14 and under |
| Shelby Heffron |