WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'merri_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 < '2019-01-19 08:16:52' 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





    • Design by





























September: What Day Is Today?

I love whacky days of observance, recognition or celebration. Here’s a few to mark on your calendars!

September 19 is “Talk Like a Pirate Day!” (truly a day for Teach! Congrats and Arrrrrrrgh!)

September 22 is Elephant Appreciation Day (for my Republican readers) as well as Hobbit Day (for my fanatical LOTR readers!)

September 23 is Fish Amnesty Day, so I think I’ll have some fish sticks (I mean, if they are frozen fish sticks they weren’t caught on Fish Amnesty Day, right?). There is some irony, though, in that September 23 is *also* National Hunting and Fishing Day. I think we’ll confuse the fish, won’t we?

September 24 is Punctuation Day, a day dedicated to my good friend Beth. When is Spelling Day, I wonder? Hmmmm…..

September 25 is National One-Hit Wonder Day, dedicated to you “Soft Cell” fans everywhere!

In preparation for October’s monthly commemorations, please be sure to stock up on trinkets and decorations to celebrate October as the month of….

…Celebrate Sun Dried Tomatoes Month

…Go Hog Wild, Eat Country Ham Month

…National Pajama Month

…National Poppin’ Popcorn Month

…National Toilet Tank Repair Month

…National Spinach Lover’s Month (…and National Talk About Prescriptions Month, which is what you’ll need if you celebrate National Spinach Lover’s Month!!!)

…and there you have it. Be sure to mark your calendars, plan, and celebrate!

WordPress database error: [Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'merri_wrdp1.wp_comments.comment_type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT comment_author, comment_author_url, comment_type, MAX(comment_ID) as comment_ID, SUBSTRING_INDEX(comment_content,'strong',2) as trackback_title, SUBSTRING_INDEX(comment_author,' » ',1) as pingback_blog, SUBSTRING_INDEX(comment_author,' » ',-1) as pingback_title FROM wp_comments WHERE (comment_post_ID='593' AND comment_approved = '1') AND (comment_type = 'trackback' OR comment_type = 'pingback') GROUP BY comment_author, comment_author_url ORDER BY comment_ID DESC LIMIT 50

1 Comment »

Quick links

I’m going to be busy for a while finishing setting up my new laptop (I’m still not loving the touchpad, but I’m getting a mouse tomorrow), and besides, I’ve got blog apathy today (still).

See this from Cassandra–about thi...



Leave a Comment!

:mrgreen: :neutral: :twisted: :arrow: :shock: :smile: :???: :cool: :evil: :grin: :idea: :oops: :razz: :roll: :wink: :cry: :eek: :lol: :mad: :sad: :!: :?:

Please note: Comments may be moderated. It may take a while for them to show on the page.

Back To Main


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

    January 2019
    M T W T F S S
         
     123456
    78910111213
    14151617181920
    21222324252627
    28293031  
    • WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'merri_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 < '2019-01-19 08:16:52' 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