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 |
| Bill Hahm |
| Deb Aukerman |
| Jeanne Gleason |
| John Kastigar |
| Julie Howell |
| Kelly McBride |
| Kevin McCarthy |
| Laurel Schumacher |
| Les Usiak |
| Mary Pinkham |
| Meg Anderson |
| Melissa Adams |
| Merlin Anderson |
| Nigel Keen |
| Paul Peacock |
| Peggy Stark |
| Rich Beal |
| Robyn Walter |
| Roger Aukerman |
| Sherry Detloff |
| Stacie Rood |
| Tammy Knippenberg |
| Tim Rood |
| Tod Williamson |
| Wendy Nafziger |
| 14 and under |
| Shelby Heffron |