http://winksite.com/cleverhack/g33k
Don’t know if it will really work, but I figured might as well try since I have a phone with a keyboard now.
[tags]Web, Mobile Web, Mobile Web Browsers, Moblogging, Moblogs [/tags]
WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'jlarkin_wrdp1.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 < '2018-09-19 16:18:45' 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
Subscribe to Cleverhack