Shoot Selection  Doubles
All Scores 
MS Points 
12 Gauge
All Scores 
MS Points 
20 Gauge
All Scores 
MS Points 
28 Gauge
All Scores 
MS Points 
410 Bore
All Scores 
MS Points 
HOA
All Scores 
MS Points 
HAA
All Scores 
  MS Skeet Homepage 
: ( SELECT MV116646.FNAME, MV116646.LNAME, MV116646.CITY, MV116646.STATE, MV116646.SHOTDBL, MV116646.BROKEDBL, MV116646.CLASSDBL, MV116646.AWARD1DBL, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV116646 LEFT JOIN skeet_awards ON MV116646.AWARD1DBL = skeet_awards.award_id_pk WHERE STATE='MS' and MV116646.AWARD1DBL > 0) UNION ALL ( SELECT MV116646.FNAME, MV116646.LNAME, MV116646.CITY, MV116646.STATE, MV116646.SHOTDBL, MV116646.BROKEDBL, MV116646.CLASSDBL, MV116646.AWARD2DBL, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV116646 LEFT JOIN skeet_awards ON MV116646.AWARD2DBL = skeet_awards.award_id_pk WHERE STATE='MS' and MV116646.AWARD2DBL > 0 ) UNION ALL ( SELECT MV116646.FNAME, MV116646.LNAME, MV116646.CITY, MV116646.STATE, MV116646.SHOTDBL, MV116646.BROKEDBL, MV116646.CLASSDBL, MV116646.AWARD3DBL, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV116646 LEFT JOIN skeet_awards ON MV116646.AWARD3DBL = skeet_awards.award_id_pk WHERE STATE='MS' and MV116646.AWARD3DBL > 0 ) UNION ALL ( SELECT MV116646.FNAME, MV116646.LNAME, MV116646.CITY, MV116646.STATE, MV116646.SHOTDBL, MV116646.BROKEDBL, MV116646.CLASSDBL, MV116646.AWARD4DBL, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV116646 LEFT JOIN skeet_awards ON MV116646.AWARD4DBL = skeet_awards.award_id_pk WHERE STATE='MS' and MV116646.AWARD4DBL > 0) UNION ALL ( SELECT MV116646.FNAME, MV116646.LNAME, MV116646.CITY, MV116646.STATE, MV116646.SHOTDBL, MV116646.BROKEDBL, MV116646.CLASSDBL, MV116646.AWARD5DBL, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV116646 LEFT JOIN skeet_awards ON MV116646.AWARD5DBL = skeet_awards.award_id_pk WHERE STATE='MS' and MV116646.AWARD5DBL > 0) UNION ALL ( SELECT MV116646.FNAME, MV116646.LNAME, MV116646.CITY, MV116646.STATE, MV116646.SHOTDBL, MV116646.BROKEDBL, MV116646.CLASSDBL, MV116646.AWARD6DBL, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV116646 LEFT JOIN skeet_awards ON MV116646.AWARD6DBL = skeet_awards.award_id_pk WHERE STATE='MS' and MV116646.AWARD6DBL > 0) ORDER By sort_order