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_artists.artist_id = '289' AND tbl_artists.ny_artist = 'Yes' AND tbl_works.newyork = 'Yes' ORDER BY work_rank, work_type_id ASC LIMIT 0,100