Hunting Testimonials

Alberta Waterfowl Hunting

Expression #1 of ORDER BY clause is not in SELECT list, references column 'wingshot_respallinone.airp_testimonials.createdate' which is not in SELECT list; this is incompatible with DISTINCT

SQL:
select distinct(DATE_FORMAT(`createdate`,'%Y')) as `mydate` from `airp_testimonials` where `status`='1' order by `createdate` desc