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 MV129844.FNAME, MV129844.LNAME, MV129844.CITY, MV129844.STATE, MV129844.SHOTDBL, MV129844.BROKEDBL, MV129844.CLASSDBL, MV129844.AWARD1DBL, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV129844 LEFT JOIN skeet_awards ON MV129844.AWARD1DBL = skeet_awards.award_id_pk WHERE STATE='MS' and MV129844.AWARD1DBL > 0) UNION ALL ( SELECT MV129844.FNAME, MV129844.LNAME, MV129844.CITY, MV129844.STATE, MV129844.SHOTDBL, MV129844.BROKEDBL, MV129844.CLASSDBL, MV129844.AWARD2DBL, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV129844 LEFT JOIN skeet_awards ON MV129844.AWARD2DBL = skeet_awards.award_id_pk WHERE STATE='MS' and MV129844.AWARD2DBL > 0 ) UNION ALL ( SELECT MV129844.FNAME, MV129844.LNAME, MV129844.CITY, MV129844.STATE, MV129844.SHOTDBL, MV129844.BROKEDBL, MV129844.CLASSDBL, MV129844.AWARD3DBL, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV129844 LEFT JOIN skeet_awards ON MV129844.AWARD3DBL = skeet_awards.award_id_pk WHERE STATE='MS' and MV129844.AWARD3DBL > 0 ) UNION ALL ( SELECT MV129844.FNAME, MV129844.LNAME, MV129844.CITY, MV129844.STATE, MV129844.SHOTDBL, MV129844.BROKEDBL, MV129844.CLASSDBL, MV129844.AWARD4DBL, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV129844 LEFT JOIN skeet_awards ON MV129844.AWARD4DBL = skeet_awards.award_id_pk WHERE STATE='MS' and MV129844.AWARD4DBL > 0) UNION ALL ( SELECT MV129844.FNAME, MV129844.LNAME, MV129844.CITY, MV129844.STATE, MV129844.SHOTDBL, MV129844.BROKEDBL, MV129844.CLASSDBL, MV129844.AWARD5DBL, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV129844 LEFT JOIN skeet_awards ON MV129844.AWARD5DBL = skeet_awards.award_id_pk WHERE STATE='MS' and MV129844.AWARD5DBL > 0) UNION ALL ( SELECT MV129844.FNAME, MV129844.LNAME, MV129844.CITY, MV129844.STATE, MV129844.SHOTDBL, MV129844.BROKEDBL, MV129844.CLASSDBL, MV129844.AWARD6DBL, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order FROM MV129844 LEFT JOIN skeet_awards ON MV129844.AWARD6DBL = skeet_awards.award_id_pk WHERE STATE='MS' and MV129844.AWARD6DBL > 0) ORDER By sort_order