SELECT * FROM tbl_works INNER JOIN tbl_artist ON tbl_artist.artistID = tbl_works.artistID WHERE work_active = 'Yes' AND stockroom = 'Yes' AND tbl_works.artistID = '' ORDER BY work_rank asc, workID desc limit ,1