Montana Whitetails
 


Categories

 

Archive

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

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