MySQL error!

Expression #1 of ORDER BY clause is not in SELECT list, references column 'theandi_b2new.evo_posts.post_issue_date' which is not in SELECT list; this is incompatible with DISTINCT(Errno=3065)

Your query: Get ID list for Item List (Main|Lastpostdate) Query

SELECT DISTINCT ID
                      FROM (evo_posts INNER JOIN evo_postcats ON ID = postcat_post_ID)
                            INNER JOIN evo_categories ON postcat_cat_ID = cat_ID WHERE cat_blog_ID = 5 AND YEAR(post_issue_date)=2006 AND MONTH(post_issue_date)=07 AND  ( post_status IN ('published') )  AND post_issue_date <= '2020-06-01 01:34:12' ORDER BY post_issue_date DESC