Shoot Selection 
Select Single Shooter 
Doubles
All Scores 
Event 1
All Scores 
Event 2
All Scores 
Event 3
All Scores 
Event 4
All Scores 
HOA
All Scores 
HAA
All Scores 
  MS Skeet Homepage 
: ( SELECT MV139619.FNAME, MV139619.LNAME, MV139619.CITY, MV139619.STATE, MV139619.SHOT410, MV139619.BROKE410, MV139619.CLASS410, MV139619.AWARD1410, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV139619 LEFT JOIN skeet_awards ON MV139619.AWARD1410 = skeet_awards.award_id_pk WHERE STATE='MS' and MV139619.AWARD1410 > 0) UNION ALL ( SELECT MV139619.FNAME, MV139619.LNAME, MV139619.CITY, MV139619.STATE, MV139619.SHOT410, MV139619.BROKE410, MV139619.CLASS410, MV139619.AWARD2410, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV139619 LEFT JOIN skeet_awards ON MV139619.AWARD2410 = skeet_awards.award_id_pk WHERE STATE='MS' and MV139619.AWARD2410 > 0 ) UNION ALL ( SELECT MV139619.FNAME, MV139619.LNAME, MV139619.CITY, MV139619.STATE, MV139619.SHOT410, MV139619.BROKE410, MV139619.CLASS410, MV139619.AWARD3410, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV139619 LEFT JOIN skeet_awards ON MV139619.AWARD3410 = skeet_awards.award_id_pk WHERE STATE='MS' and MV139619.AWARD3410 > 0 ) UNION ALL ( SELECT MV139619.FNAME, MV139619.LNAME, MV139619.CITY, MV139619.STATE, MV139619.SHOT410, MV139619.BROKE410, MV139619.CLASS410, MV139619.AWARD4410, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV139619 LEFT JOIN skeet_awards ON MV139619.AWARD4410 = skeet_awards.award_id_pk WHERE STATE='MS' and MV139619.AWARD4410 > 0) UNION ALL ( SELECT MV139619.FNAME, MV139619.LNAME, MV139619.CITY, MV139619.STATE, MV139619.SHOT410, MV139619.BROKE410, MV139619.CLASS410, MV139619.AWARD5410, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV139619 LEFT JOIN skeet_awards ON MV139619.AWARD5410 = skeet_awards.award_id_pk WHERE STATE='MS' and MV139619.AWARD5410 > 0) UNION ALL ( SELECT MV139619.FNAME, MV139619.LNAME, MV139619.CITY, MV139619.STATE, MV139619.SHOT410, MV139619.BROKE410, MV139619.CLASS410, MV139619.AWARD6410, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV139619 LEFT JOIN skeet_awards ON MV139619.AWARD6410 = skeet_awards.award_id_pk WHERE STATE='MS' and MV139619.AWARD6410 > 0) ORDER By sort_order