Michigan Points Ranking. Click on the shooters last name to list their points earned.
Rank
First Name
Last Name
City
State
Mins
Avg
Total Points
:SELECT pts.*, nssa.FNAME as nssafname, nssa.LName as nssalname, nssa.city as nssacity, nssa.state as nssastate FROM misa_pts_ pts LEFT JOIN SKEETMAN_MISA nssa ON pts.nssano=nssa.nssano WHERE totalmssapoints > 0 ORDER BY totalmssapoints DESC, l_name