WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'userweb60364.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 < '2026-06-12 20:39:47' 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
check it out - click on the MAP menu button. From there, you can move the map around, zoom in/out, switch to satellite view or hybrid view, etc. If you see any red map pinpoints, click on them! A bubble will appear with a link to a post about that place. Click on the boldfaced title of the post in the bubble and you’ll be taken to that post!
Pretty sweet, huh?
(24)
(11)
(1)
(1)
(4)
(27)
(4)
(2)
(2)
(18)
(4)
(6)
(9)
(3)
(2)
(4)
(1)
(8)
(5)
(2)
(18)
(1)
(7)
(1)
(8)
(1)
(3)
(6)
(3)
(2)
(6)
(5)
Hey Neenan,
How neat! I can’t wait to try it out when you’re on the road!!
Love, Mom