SELECT * FROM tbl_works INNER JOIN tbl_exhibitions ON tbl_exhibitions.exhibition_id = tbl_works.exhibition_id INNER JOIN tbl_artists ON tbl_works.artist_id = tbl_artists.artist_id WHERE work_active = 'Yes' AND tbl_exhibitions.exhibition_id = '625' ORDER BY ex_rank ASC,work_id desc