An Error Was Encountered

Error Number: 1064

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 'ORDER BY subcategory_name' at line 1

SELECT distinct artist_id, subcategory_name FROM images, gallery_subcategories WHERE artist_id=gallery_subcategories.subcategory_id AND published=1 AND city_id=728 AND style_id= ORDER BY subcategory_name