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 MV152358.FNAME, MV152358.LNAME, MV152358.CITY, MV152358.STATE, MV152358.SHOT12, MV152358.BROKE12, MV152358.CLASS12, MV152358.AWARD112, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV152358 LEFT JOIN skeet_awards ON MV152358.AWARD112 = skeet_awards.award_id_pk WHERE STATE='MS' and MV152358.AWARD112 > 0) UNION ALL ( SELECT MV152358.FNAME, MV152358.LNAME, MV152358.CITY, MV152358.STATE, MV152358.SHOT12, MV152358.BROKE12, MV152358.CLASS12, MV152358.AWARD212, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV152358 LEFT JOIN skeet_awards ON MV152358.AWARD212 = skeet_awards.award_id_pk WHERE STATE='MS' and MV152358.AWARD212 > 0 ) UNION ALL ( SELECT MV152358.FNAME, MV152358.LNAME, MV152358.CITY, MV152358.STATE, MV152358.SHOT12, MV152358.BROKE12, MV152358.CLASS12, MV152358.AWARD312, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV152358 LEFT JOIN skeet_awards ON MV152358.AWARD312 = skeet_awards.award_id_pk WHERE STATE='MS' and MV152358.AWARD312 > 0 ) UNION ALL ( SELECT MV152358.FNAME, MV152358.LNAME, MV152358.CITY, MV152358.STATE, MV152358.SHOT12, MV152358.BROKE12, MV152358.CLASS12, MV152358.AWARD412, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV152358 LEFT JOIN skeet_awards ON MV152358.AWARD412 = skeet_awards.award_id_pk WHERE STATE='MS' and MV152358.AWARD412 > 0) UNION ALL ( SELECT MV152358.FNAME, MV152358.LNAME, MV152358.CITY, MV152358.STATE, MV152358.SHOT12, MV152358.BROKE12, MV152358.CLASS12, MV152358.AWARD512, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV152358 LEFT JOIN skeet_awards ON MV152358.AWARD512 = skeet_awards.award_id_pk WHERE STATE='MS' and MV152358.AWARD512 > 0) UNION ALL ( SELECT MV152358.FNAME, MV152358.LNAME, MV152358.CITY, MV152358.STATE, MV152358.SHOT12, MV152358.BROKE12, MV152358.CLASS12, MV152358.AWARD612, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV152358 LEFT JOIN skeet_awards ON MV152358.AWARD612 = skeet_awards.award_id_pk WHERE STATE='MS' and MV152358.AWARD612 > 0) ORDER By sort_order