SELECT * FROM tbl_exhibition LEFT JOIN tbl_artist ON tbl_artist.artistID = tbl_exhibition.artistID LEFT JOIN tbl_ex_type ON tbl_ex_type.ex_typeID = tbl_exhibition.ex_typeID WHERE tbl_exhibition.ex_typeID != '3' AND tbl_exhibition.ex_active = 'Yes' ORDER BY tbl_exhibition.ex_actualdates ASC