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 MV150651.FNAME, MV150651.LNAME, MV150651.CITY, MV150651.STATE, MV150651.SHOT20, MV150651.BROKE20, MV150651.CLASS20, MV150651.AWARD120, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV150651 LEFT JOIN skeet_awards ON MV150651.AWARD120 = skeet_awards.award_id_pk WHERE STATE='MS' and MV150651.AWARD120 > 0) UNION ALL ( SELECT MV150651.FNAME, MV150651.LNAME, MV150651.CITY, MV150651.STATE, MV150651.SHOT20, MV150651.BROKE20, MV150651.CLASS20, MV150651.AWARD220, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV150651 LEFT JOIN skeet_awards ON MV150651.AWARD220 = skeet_awards.award_id_pk WHERE STATE='MS' and MV150651.AWARD220 > 0 ) UNION ALL ( SELECT MV150651.FNAME, MV150651.LNAME, MV150651.CITY, MV150651.STATE, MV150651.SHOT20, MV150651.BROKE20, MV150651.CLASS20, MV150651.AWARD320, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV150651 LEFT JOIN skeet_awards ON MV150651.AWARD320 = skeet_awards.award_id_pk WHERE STATE='MS' and MV150651.AWARD320 > 0 ) UNION ALL ( SELECT MV150651.FNAME, MV150651.LNAME, MV150651.CITY, MV150651.STATE, MV150651.SHOT20, MV150651.BROKE20, MV150651.CLASS20, MV150651.AWARD420, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV150651 LEFT JOIN skeet_awards ON MV150651.AWARD420 = skeet_awards.award_id_pk WHERE STATE='MS' and MV150651.AWARD420 > 0) UNION ALL ( SELECT MV150651.FNAME, MV150651.LNAME, MV150651.CITY, MV150651.STATE, MV150651.SHOT20, MV150651.BROKE20, MV150651.CLASS20, MV150651.AWARD520, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV150651 LEFT JOIN skeet_awards ON MV150651.AWARD520 = skeet_awards.award_id_pk WHERE STATE='MS' and MV150651.AWARD520 > 0) UNION ALL ( SELECT MV150651.FNAME, MV150651.LNAME, MV150651.CITY, MV150651.STATE, MV150651.SHOT20, MV150651.BROKE20, MV150651.CLASS20, MV150651.AWARD620, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV150651 LEFT JOIN skeet_awards ON MV150651.AWARD620 = skeet_awards.award_id_pk WHERE STATE='MS' and MV150651.AWARD620 > 0) ORDER By sort_order