SELECT distinct YEAR (ex_start_date) AS ex_year FROM tbl_exhibitions LEFT JOIN tbl_exhibition_type ON tbl_exhibition_type.ex_typeID = tbl_exhibitions.ex_typeID WHERE tbl_exhibitions.ex_typeID = '3' AND tbl_exhibitions.ex_active = 'Yes' AND tbl_exhibitions.newyork = 'Yes' AND tbl_exhibitions.ex_start_date > '2017-01-01' ORDER BY tbl_exhibitions.ex_start_date DESC