: ( SELECT MV131934.FNAME, MV131934.LNAME, MV131934.CITY, MV131934.STATE, MV131934.CLASSHAA, MV131934.AWARD1HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV131934 LEFT JOIN skeet_awards ON MV131934.AWARD1HAA = skeet_awards.award_id_pk WHERE MV131934.AWARD1HAA >= 1 AND MV131934.ENTRY = 2 ) UNION ALL ( SELECT MV131934.FNAME, MV131934.LNAME, MV131934.CITY, MV131934.STATE, MV131934.CLASSHAA, MV131934.AWARD2HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV131934 LEFT JOIN skeet_awards ON MV131934.AWARD2HAA = skeet_awards.award_id_pk WHERE MV131934.AWARD2HAA >= 1 AND MV131934.ENTRY = 2 ) UNION ALL ( SELECT MV131934.FNAME, MV131934.LNAME, MV131934.CITY, MV131934.STATE, MV131934.CLASSHAA, MV131934.AWARD3HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV131934 LEFT JOIN skeet_awards ON MV131934.AWARD3HAA = skeet_awards.award_id_pk WHERE MV131934.AWARD3HAA >= 1 AND MV131934.ENTRY = 2 ) UNION ALL ( SELECT MV131934.FNAME, MV131934.LNAME, MV131934.CITY, MV131934.STATE, MV131934.CLASSHAA, MV131934.AWARD4HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV131934 LEFT JOIN skeet_awards ON MV131934.AWARD4HAA = skeet_awards.award_id_pk WHERE MV131934.AWARD4HAA >= 1 AND MV131934.ENTRY = 2 ) UNION ALL ( SELECT MV131934.FNAME, MV131934.LNAME, MV131934.CITY, MV131934.STATE, MV131934.CLASSHAA, MV131934.AWARD5HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV131934 LEFT JOIN skeet_awards ON MV131934.AWARD5HAA = skeet_awards.award_id_pk WHERE MV131934.AWARD5HAA >= 1 AND MV131934.ENTRY = 2 ) UNION ALL ( SELECT MV131934.FNAME, MV131934.LNAME, MV131934.CITY, MV131934.STATE, MV131934.CLASSHAA, MV131934.AWARD6HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV131934 LEFT JOIN skeet_awards ON MV131934.AWARD6HAA = skeet_awards.award_id_pk WHERE MV131934.AWARD6HAA >= 1 AND MV131934.ENTRY = 2 ) ORDER By sort_order