: ( SELECT MV130951.FNAME, MV130951.LNAME, MV130951.CITY, MV130951.STATE, MV130951.CLASSHOA, MV130951.AWARD1HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV130951 LEFT JOIN skeet_awards ON MV130951.AWARD1HOA = skeet_awards.award_id_pk WHERE MV130951.AWARD1HOA >= 1 AND MV130951.ENTRY = 2 ) UNION ALL ( SELECT MV130951.FNAME, MV130951.LNAME, MV130951.CITY, MV130951.STATE, MV130951.CLASSHOA, MV130951.AWARD2HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV130951 LEFT JOIN skeet_awards ON MV130951.AWARD2HOA = skeet_awards.award_id_pk WHERE MV130951.AWARD2HOA >= 1 AND MV130951.ENTRY = 2 ) UNION ALL ( SELECT MV130951.FNAME, MV130951.LNAME, MV130951.CITY, MV130951.STATE, MV130951.CLASSHOA, MV130951.AWARD3HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV130951 LEFT JOIN skeet_awards ON MV130951.AWARD3HOA = skeet_awards.award_id_pk WHERE MV130951.AWARD3HOA >= 1 AND MV130951.ENTRY = 2 ) UNION ALL ( SELECT MV130951.FNAME, MV130951.LNAME, MV130951.CITY, MV130951.STATE, MV130951.CLASSHOA, MV130951.AWARD4HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV130951 LEFT JOIN skeet_awards ON MV130951.AWARD4HOA = skeet_awards.award_id_pk WHERE MV130951.AWARD4HOA >= 1 AND MV130951.ENTRY = 2 ) UNION ALL ( SELECT MV130951.FNAME, MV130951.LNAME, MV130951.CITY, MV130951.STATE, MV130951.CLASSHOA, MV130951.AWARD5HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV130951 LEFT JOIN skeet_awards ON MV130951.AWARD5HOA = skeet_awards.award_id_pk WHERE MV130951.AWARD5HOA >= 1 AND MV130951.ENTRY = 2 ) UNION ALL ( SELECT MV130951.FNAME, MV130951.LNAME, MV130951.CITY, MV130951.STATE, MV130951.CLASSHOA, MV130951.AWARD6HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV130951 LEFT JOIN skeet_awards ON MV130951.AWARD6HOA = skeet_awards.award_id_pk WHERE MV130951.AWARD6HOA >= 1 AND MV130951.ENTRY = 2 ) ORDER By sort_order