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.CLASSHOA, MV150651.AWARD1HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, MV150651.SHOT12 + MV150651.SHOT20 + MV150651.SHOT28 + MV150651.SHOT410 As ShotHOA, MV150651.SHOT12 + MV150651.SHOT20 + MV150651.SHOT28 + MV150651.SHOT410 + MV150651.SHOTDBL As ShotHAA, MV150651.BROKE12 + MV150651.BROKE20 + MV150651.BROKE28 + MV150651.BROKE410 As BROKEHOA, MV150651.BROKE12 + MV150651.BROKE20 + MV150651.BROKE28 + MV150651.BROKE410 + MV150651.BROKEDBL As BROKEHAA FROM MV150651 LEFT JOIN skeet_awards ON MV150651.AWARD1HOA = skeet_awards.award_id_pk WHERE STATE='MS' and MV150651.AWARD1HOA > 0) UNION ALL ( SELECT MV150651.FNAME, MV150651.LNAME, MV150651.CITY, MV150651.STATE, MV150651.CLASSHOA, MV150651.AWARD2HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, MV150651.SHOT12 + MV150651.SHOT20 + MV150651.SHOT28 + MV150651.SHOT410 As ShotHOA, MV150651.SHOT12 + MV150651.SHOT20 + MV150651.SHOT28 + MV150651.SHOT410 + MV150651.SHOTDBL As ShotHAA, MV150651.BROKE12 + MV150651.BROKE20 + MV150651.BROKE28 + MV150651.BROKE410 As BROKEHOA, MV150651.BROKE12 + MV150651.BROKE20 + MV150651.BROKE28 + MV150651.BROKE410 + MV150651.BROKEDBL As BROKEHAA FROM MV150651 LEFT JOIN skeet_awards ON MV150651.AWARD2HOA = skeet_awards.award_id_pk WHERE STATE='MS' and MV150651.AWARD2HOA > 0 ) UNION ALL ( SELECT MV150651.FNAME, MV150651.LNAME, MV150651.CITY, MV150651.STATE, MV150651.CLASSHOA, MV150651.AWARD3HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, MV150651.SHOT12 + MV150651.SHOT20 + MV150651.SHOT28 + MV150651.SHOT410 As ShotHOA, MV150651.SHOT12 + MV150651.SHOT20 + MV150651.SHOT28 + MV150651.SHOT410 + MV150651.SHOTDBL As ShotHAA, MV150651.BROKE12 + MV150651.BROKE20 + MV150651.BROKE28 + MV150651.BROKE410 As BROKEHOA, MV150651.BROKE12 + MV150651.BROKE20 + MV150651.BROKE28 + MV150651.BROKE410 + MV150651.BROKEDBL As BROKEHAA FROM MV150651 LEFT JOIN skeet_awards ON MV150651.AWARD3HOA = skeet_awards.award_id_pk WHERE STATE='MS' and MV150651.AWARD3HOA > 0 ) UNION ALL ( SELECT MV150651.FNAME, MV150651.LNAME, MV150651.CITY, MV150651.STATE, MV150651.CLASSHOA, MV150651.AWARD4HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, MV150651.SHOT12 + MV150651.SHOT20 + MV150651.SHOT28 + MV150651.SHOT410 As ShotHOA, MV150651.SHOT12 + MV150651.SHOT20 + MV150651.SHOT28 + MV150651.SHOT410 + MV150651.SHOTDBL As ShotHAA, MV150651.BROKE12 + MV150651.BROKE20 + MV150651.BROKE28 + MV150651.BROKE410 As BROKEHOA, MV150651.BROKE12 + MV150651.BROKE20 + MV150651.BROKE28 + MV150651.BROKE410 + MV150651.BROKEDBL As BROKEHAA FROM MV150651 LEFT JOIN skeet_awards ON MV150651.AWARD4HOA = skeet_awards.award_id_pk WHERE STATE='MS' and MV150651.AWARD4HOA > 0) UNION ALL ( SELECT MV150651.FNAME, MV150651.LNAME, MV150651.CITY, MV150651.STATE, MV150651.CLASSHOA, MV150651.AWARD5HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, MV150651.SHOT12 + MV150651.SHOT20 + MV150651.SHOT28 + MV150651.SHOT410 As ShotHOA, MV150651.SHOT12 + MV150651.SHOT20 + MV150651.SHOT28 + MV150651.SHOT410 + MV150651.SHOTDBL As ShotHAA, MV150651.BROKE12 + MV150651.BROKE20 + MV150651.BROKE28 + MV150651.BROKE410 As BROKEHOA, MV150651.BROKE12 + MV150651.BROKE20 + MV150651.BROKE28 + MV150651.BROKE410 + MV150651.BROKEDBL As BROKEHAA FROM MV150651 LEFT JOIN skeet_awards ON MV150651.AWARD5HOA = skeet_awards.award_id_pk WHERE STATE='MS' and MV150651.AWARD5HOA > 0) UNION ALL ( SELECT MV150651.FNAME, MV150651.LNAME, MV150651.CITY, MV150651.STATE, MV150651.CLASSHOA, MV150651.AWARD6HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, MV150651.SHOT12 + MV150651.SHOT20 + MV150651.SHOT28 + MV150651.SHOT410 As ShotHOA, MV150651.SHOT12 + MV150651.SHOT20 + MV150651.SHOT28 + MV150651.SHOT410 + MV150651.SHOTDBL As ShotHAA, MV150651.BROKE12 + MV150651.BROKE20 + MV150651.BROKE28 + MV150651.BROKE410 As BROKEHOA, MV150651.BROKE12 + MV150651.BROKE20 + MV150651.BROKE28 + MV150651.BROKE410 + MV150651.BROKEDBL As BROKEHAA FROM MV150651 LEFT JOIN skeet_awards ON MV150651.AWARD6HOA = skeet_awards.award_id_pk WHERE STATE='MS' and MV150651.AWARD6HOA > 0) ORDER By sort_order