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:42: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





    • The 2006 Weblog Awards



      Design by





























Children Shouldn’t Have to Suffer Like This…

Over at Signal 94 is a story that articulates why some people should not be parents. Be prepared to want to lock and load and take a trip to NY.

“The police chief said it was one of the worst cases of child abuse his department has seen.”

No emotions, no feelings, just a robot-like attention to duty and detail. Take photos, collect and bag the evidence, type the affidavits and write the reports.

“The officers were horrified,” Nichols said Friday. “The doctors described the boy as dangerously malnourished and showing signs of starvation. If this neglect had continued, he could have died.”

Because if you don’t you’re gonna kill some asshole.

Police also found an 11-year-old girl and 12-year-old boy in the home. Like their younger brother, Nichols said, both suffered from malnourishment and neglect.

And then there’s those who just don’t care…

“Christina Stevens, who lived next door in the same two-family house for several months last year, said the 5-year-old boy next door looked as though he were 10 to 12 months old. Stevens said she called Cortland County child protective services workers at least three times last year about the family.”

…and yet another case of the CPS not responding timely when they should have helped those kids. I couldn’t have put it any better than sig, but to have to write about this kind of tragedy is virtually a sin.

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


Hee Haw!

I grew up in a household full of country music, and shows like “The Osmonds” and “Solid Gold.” One show I clearly remember gracing the television regularly was “Hee Haw.”

Washington - Buck Owens, who popularized country music in the United States with a string of 1960s hits and a long-running television show, died Saturday, associates said. He was 76.

Owens’ family said he died in his sleep at his home in Bakersfield, California, according to the website of a concert hall and restaurant he owned. The cause of death was not immediately known.

hee haw.bmp

Now, with shows like Hee Haw, one gains useless, non-disposing information. Like these lyrics from a Hee Haw song:

Where, oh where are you tonight?
Why did you leave me here all alone?
I searched the world over and I thought I found true love…
But you met another and PHPPPHT you were gone.

G’night, Buck!

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

    March 2006
    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:42: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