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 MV133251.FNAME, MV133251.LNAME, MV133251.CITY, MV133251.STATE, MV133251.SHOT28, MV133251.BROKE28, MV133251.CLASS28, MV133251.AWARD128, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV133251 LEFT JOIN skeet_awards ON MV133251.AWARD128 = skeet_awards.award_id_pk WHERE STATE='MS' and MV133251.AWARD128 > 0) UNION ALL ( SELECT MV133251.FNAME, MV133251.LNAME, MV133251.CITY, MV133251.STATE, MV133251.SHOT28, MV133251.BROKE28, MV133251.CLASS28, MV133251.AWARD228, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV133251 LEFT JOIN skeet_awards ON MV133251.AWARD228 = skeet_awards.award_id_pk WHERE STATE='MS' and MV133251.AWARD228 > 0 ) UNION ALL ( SELECT MV133251.FNAME, MV133251.LNAME, MV133251.CITY, MV133251.STATE, MV133251.SHOT28, MV133251.BROKE28, MV133251.CLASS28, MV133251.AWARD328, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV133251 LEFT JOIN skeet_awards ON MV133251.AWARD328 = skeet_awards.award_id_pk WHERE STATE='MS' and MV133251.AWARD328 > 0 ) UNION ALL ( SELECT MV133251.FNAME, MV133251.LNAME, MV133251.CITY, MV133251.STATE, MV133251.SHOT28, MV133251.BROKE28, MV133251.CLASS28, MV133251.AWARD428, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV133251 LEFT JOIN skeet_awards ON MV133251.AWARD428 = skeet_awards.award_id_pk WHERE STATE='MS' and MV133251.AWARD428 > 0) UNION ALL ( SELECT MV133251.FNAME, MV133251.LNAME, MV133251.CITY, MV133251.STATE, MV133251.SHOT28, MV133251.BROKE28, MV133251.CLASS28, MV133251.AWARD528, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV133251 LEFT JOIN skeet_awards ON MV133251.AWARD528 = skeet_awards.award_id_pk WHERE STATE='MS' and MV133251.AWARD528 > 0) UNION ALL ( SELECT MV133251.FNAME, MV133251.LNAME, MV133251.CITY, MV133251.STATE, MV133251.SHOT28, MV133251.BROKE28, MV133251.CLASS28, MV133251.AWARD628, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV133251 LEFT JOIN skeet_awards ON MV133251.AWARD628 = skeet_awards.award_id_pk WHERE STATE='MS' and MV133251.AWARD628 > 0) ORDER By sort_order