SELECT * FROM tbl_exhibition_join INNER JOIN tbl_exhibition ON tbl_exhibition.exhibitionID = tbl_exhibition_join.exhibitionID INNER JOIN tbl_works ON tbl_works.workID = tbl_exhibition_join.workID INNER JOIN tbl_artist ON tbl_works.artistID = tbl_artist.artistID WHERE work_active = 'Yes' AND tbl_exhibition.exhibitionID = '11' ORDER BY work_rank ASC, work_price DESC limit 9,1