b2 [project page / test blog] [login] [register]

[ This is a test blog, with posts about the development of b2, and comments ]

[ Bugs/suggestions ? Check the Forums ! ]

[powered by b2.]

SELECT DISTINCT YEAR(post_date), MONTH(post_date) FROM posts WHERE post_date < '2021-04-20 12:28:02' AND post_category > 0 ORDER BY post_date DESC
Expression #1 of ORDER BY clause is not in SELECT list, references column 'cafelog_cafelogcom.posts.post_date' which is not in SELECT list; this is incompatible with DISTINCT