SELECT * FROM tbl_works INNER JOIN tbl_artists ON tbl_artists.artist_id = tbl_works.artist_id WHERE tbl_works.newyork_active = 'Yes' AND tbl_works.newyork = 'Yes' AND tbl_artists.artist_id = '380' AND tbl_works.work_type_id LIKE '%' ORDER BY work_rank ASC, work_type_id ASC