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_artists.artist_stockroom = 'Yes' AND
			tbl_artists.nyc_no_show != 'Yes' AND
			tbl_works.stockroom = 'Yes' AND
			tbl_works.work_status_id != 2 AND
			tbl_works.work_type_id LIKE  '%' 
		ORDER BY artist_lName, artist_fName asc :Access denied for user ''@'localhost' (using password: NO)