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