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 
  Michigan Skeet
Results
 
: ( SELECT MV126750.FNAME, MV126750.LNAME, MV126750.CITY, MV126750.STATE, MV126750.CLASSHOA, MV126750.AWARD1HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV126750 LEFT JOIN skeet_awards ON MV126750.AWARD1HOA = skeet_awards.award_id_pk WHERE MV126750.AWARD1HOA >= 1 AND MV126750.ENTRY = 2 ) UNION ALL ( SELECT MV126750.FNAME, MV126750.LNAME, MV126750.CITY, MV126750.STATE, MV126750.CLASSHOA, MV126750.AWARD2HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV126750 LEFT JOIN skeet_awards ON MV126750.AWARD2HOA = skeet_awards.award_id_pk WHERE MV126750.AWARD2HOA >= 1 AND MV126750.ENTRY = 2 ) UNION ALL ( SELECT MV126750.FNAME, MV126750.LNAME, MV126750.CITY, MV126750.STATE, MV126750.CLASSHOA, MV126750.AWARD3HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV126750 LEFT JOIN skeet_awards ON MV126750.AWARD3HOA = skeet_awards.award_id_pk WHERE MV126750.AWARD3HOA >= 1 AND MV126750.ENTRY = 2 ) UNION ALL ( SELECT MV126750.FNAME, MV126750.LNAME, MV126750.CITY, MV126750.STATE, MV126750.CLASSHOA, MV126750.AWARD4HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV126750 LEFT JOIN skeet_awards ON MV126750.AWARD4HOA = skeet_awards.award_id_pk WHERE MV126750.AWARD4HOA >= 1 AND MV126750.ENTRY = 2 ) UNION ALL ( SELECT MV126750.FNAME, MV126750.LNAME, MV126750.CITY, MV126750.STATE, MV126750.CLASSHOA, MV126750.AWARD5HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV126750 LEFT JOIN skeet_awards ON MV126750.AWARD5HOA = skeet_awards.award_id_pk WHERE MV126750.AWARD5HOA >= 1 AND MV126750.ENTRY = 2 ) UNION ALL ( SELECT MV126750.FNAME, MV126750.LNAME, MV126750.CITY, MV126750.STATE, MV126750.CLASSHOA, MV126750.AWARD6HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV126750 LEFT JOIN skeet_awards ON MV126750.AWARD6HOA = skeet_awards.award_id_pk WHERE MV126750.AWARD6HOA >= 1 AND MV126750.ENTRY = 2 ) ORDER By sort_order