SELECT DISTINCT(tbl_artists.artist_id) FROM tbl_works INNER JOIN tbl_artists ON tbl_artists.artist_id = tbl_works.artist_id WHERE tbl_works.work_active = 'Yes' AND tbl_works.newyork_stock = 'Yes' AND tbl_artists.newyork_stock = 'Yes' AND tbl_works.work_status_id != 2 AND tbl_works.work_type_id LIKE '1%' ORDER BY artist_lName, artist_fName asc :Unknown column 'tbl_artists.newyork_stock' in 'where clause'