SELECT * FROM tbl_works WHERE tbl_works.work_active = 'Yes' AND tbl_works.public_site_active = 'Yes' AND tbl_works.workID = '239' ORDER BY work_rank ASC, workID desc