drdes.org

WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column 'drdorg_wrdp1.wp_posts.post_date' which is not in SELECT list; this is incompatible with DISTINCT]
SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year FROM wp_posts WHERE post_date < '2021-08-01' AND post_type = 'post' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1

WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column 'drdorg_wrdp1.wp_posts.post_date' which is not in SELECT list; this is incompatible with DISTINCT]
SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year FROM wp_posts WHERE post_date > '2021-08-01' AND MONTH( post_date ) != MONTH( '2021-08-01' ) AND post_type = 'post' AND post_status = 'publish' ORDER BY post_date ASC LIMIT 1