SELECT * FROM tbl_artists WHERE ny_artist = 'Yes' AND artist_ny_type_id = 1 ORDER BY artist_lName, artist_fName ASC