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_stock = 'Yes' AND work_status_id != 2 AND work_status_id != 3 AND tbl_artists.artist_id = '233' AND tbl_works.work_type_id LIKE '3%' ORDER BY work_rank ASC, work_type_id ASC