WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'author_Colony.wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_date < '2024-04-26 19:26:01' AND post_date != '0000-00-00 00:00:00' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
Thus ends the first novel of the Ex-Earth series. My thanks to all the participants. While I have not had the time to pursue the second book, some of my collaborators have been doing some fine writing of their own. Here are their web sites:
and
My only wish is that I had been born a hundred years from now when some of this might become reality.
Jeff