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-20 11:56:32' 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





    • The 2006 Weblog Awards



      Design by





























October: What Day Is Today?

It’s that time again, ladies and gentlemen. With Columbus Day and Halloween already marked on your calendar, I thought I’d let you know of a few lesser-known days of celebration for October. But FIRST, be sure to celebrate October for the month that it is (National Celebrate Sun Dried Tomatoes Month, National Cookie Month and Workplace Politics Month!). Oh, and now those daily celebrations:

October 9: National Kick Butt Day (I’ll be traveling, so this may come in handy!)

October 11: National Bring Your Teddy Bear to Work & School Day (awwwwwwww!)

October 12: International Moment of Frustration Scream Day (I’ll be traveling again, so I’m sure this will fit!)

October 13: International Skeptics Day (hmmm….I’m not so sure about that…)

October 15: Be Bald and Be Free Day (um….no. Ain’t going there)

October 25: Sourest Day (pucker up!)

October 26: Mule Day (also known as jackass day? hehehe)

October 27: Cranky Co-Workers Day (and just how would one “celebrate” this?)

October 30: Haunted Refrigerator Night (um…who thinks these things up anyway?)

October 31: National Knock-Knock Jokes Day (and to think Halloween kicked this one off the calendar!)

Enjoy! And just in case you need more reason to celebrate, next week is National Chestnut Week, so go wild!

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='609' 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


    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 < '2006-10-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 > '2006-10-01' AND MONTH( post_date ) != MONTH( '2006-10-01' ) AND post_status = 'publish' ORDER BY post_date ASC LIMIT 1

    October 2006
    M T W T F S S
         
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  
    • 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-20 11:56:32' 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