WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column 'edubuntu67809.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 < '2024-04-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 'edubuntu67809.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 > '2024-04-01' AND MONTH( post_date ) != MONTH( '2024-04-01' ) AND post_type = 'post' AND post_status = 'publish' ORDER BY post_date ASC LIMIT 1