SELECT * FROM tbl_exhibition_join LEFT JOIN tbl_exhibition ON tbl_exhibition.exhibitionID = tbl_exhibition_join.exhibitionID LEFT JOIN tbl_works ON tbl_works.workID = tbl_exhibition_join.workID LEFT JOIN tbl_images ON tbl_images.imageID = tbl_exhibition_join.workID WHERE work_active = 'Yes' AND tbl_exhibition.exhibitionID = '101' ORDER BY tbl_works.ex_rank ASC