DBConnect Errors : Expression #1 of ORDER BY clause is not in SELECT list, references column 'fehdnewdb.hkied_centre_resources_live.date' which is not in SELECT list; this is incompatible with DISTINCT
SELECT distinct(DATE_FORMAT(date,'%Y')) as year FROM hkied_centre_resources_live WHERE deleted='N' AND type='online_resources' AND site=_utf8'celt' AND status='A' ORDER BY date desc