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:44:37' 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





























Can We All “Coexist?”

My dear readers - I need your input. I saw a bumper sticker on the way home from work and I want your opinions….would you put one of these on your bumper? Why do you feel that way?

This is the one I actually saw:

The symbols on this one are the Muslim Crescent/Star, Peace Sign, Man & Woman, the Jewish Star of David, Baha’i Star, Taoist Yin Yang and a cross representing Christianity.

Then I found this one on the ‘nets at “Stamp and Shout” (I won’t link, but it’s pretty easy to get there if you want to look):

Slightly different symbols: Islam crescent/star ; pentagram for Wicca; relativity formula standing for science; star of David for Judaism; the Karma Wheel on the ‘i’ representing Buddhism; Tao symbol; and the cross for Chrisitianity.

Talk amongst yourselves….topic….”Coexist!”

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


Those CRAAAAZY Criminals: Juanita Marie Jones Edition

This crazy criminal proves to the rest of us that if drugs don’t kill ya, they just make ya stupider:

ROCHELLE, Ga. (AP) - A woman was arrested after she called police to help “get her money back” after she was unhappy with the crack cocaine she purchased.

Juanita Marie Jones, 53, called Rochelle Police late Thursday night after she purchased what she thought was a $20 piece of crack cocaine, according to police reports.

She called them because once she smoked some, she realized it was fake. When she showed the drugs to the officers, she was promptly arrested.

Score: Smart & Responsible Police Officers - 1 / Crack-smoking, brick-short-of-a-load druggie - 0

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

    August 2007
    M T W T F S S
         
     12345
    6789101112
    13141516171819
    20212223242526
    2728293031  
    • 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:44:38' 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