You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ShotHOA,  As ShotHAA,   As BROKEHOA,  As BROKEHAA FROM MV128881 LEFT JOIN ske' at line 1: 
( SELECT MV128881.FNAME, MV128881.LNAME, MV128881.CITY, MV128881.STATE, MV128881.CLASSHAA,  MV128881.AWARD1HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order,  AS ShotHOA,  As ShotHAA,   As BROKEHOA,  As BROKEHAA FROM MV128881 LEFT JOIN skeet_awards ON MV128881.AWARD1HAA = skeet_awards.award_id_pk WHERE MV128881.AWARD1HAA >= 1 )
UNION ALL
( SELECT MV128881.FNAME, MV128881.LNAME, MV128881.CITY, MV128881.STATE, MV128881.CLASSHAA,  MV128881.AWARD2HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order,  AS ShotHOA,  As ShotHAA,   As BROKEHOA,  As BROKEHAA FROM MV128881 LEFT JOIN skeet_awards ON MV128881.AWARD2HAA = skeet_awards.award_id_pk WHERE MV128881.AWARD2HAA >= 1 )
UNION ALL
( SELECT MV128881.FNAME, MV128881.LNAME, MV128881.CITY, MV128881.STATE, MV128881.CLASSHAA,  MV128881.AWARD3HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order,  AS ShotHOA,  As ShotHAA,   As BROKEHOA,  As BROKEHAA FROM MV128881 LEFT JOIN skeet_awards ON MV128881.AWARD3HAA = skeet_awards.award_id_pk WHERE MV128881.AWARD3HAA >= 1 )
UNION ALL
( SELECT MV128881.FNAME, MV128881.LNAME, MV128881.CITY, MV128881.STATE, MV128881.CLASSHAA,  MV128881.AWARD4HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order,  AS ShotHOA,  As ShotHAA,   As BROKEHOA,  As BROKEHAA FROM MV128881 LEFT JOIN skeet_awards ON MV128881.AWARD4HAA = skeet_awards.award_id_pk WHERE MV128881.AWARD4HAA >= 1 )
UNION ALL
( SELECT MV128881.FNAME, MV128881.LNAME, MV128881.CITY, MV128881.STATE, MV128881.CLASSHAA,  MV128881.AWARD5HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order,  AS ShotHOA,  As ShotHAA,   As BROKEHOA,  As BROKEHAA FROM MV128881 LEFT JOIN skeet_awards ON MV128881.AWARD5HAA = skeet_awards.award_id_pk WHERE MV128881.AWARD5HAA >= 1 )
UNION ALL
( SELECT MV128881.FNAME, MV128881.LNAME, MV128881.CITY, MV128881.STATE, MV128881.CLASSHAA,  MV128881.AWARD6HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order,  AS ShotHOA,  As ShotHAA,   As BROKEHOA,  As BROKEHAA FROM MV128881 LEFT JOIN skeet_awards ON MV128881.AWARD6HAA = skeet_awards.award_id_pk WHERE MV128881.AWARD6HAA >= 1 )
ORDER By sort_order