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 12:24: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





    • Design by





























The MSM is not Biased in their Views!

I usually check the local news before work, mostly to see what the weather is like. But when I see a headline like this, I feel compelled to stop by and rant for just a minute:

“Senior Citizen Loses Bid to Avoid Execution”

You can’t tell me the author of this story doesn’t have bias one way or the other - I mean, c’mon! The senior citizen in question is Clarence Ray Allen, a 76-year-old who could be the oldest man to ever be executed in California. I guess the author has forgotten what Clarence Ray Allen is guilty of.

He was sentenced to death in 1980 for hiring a hit man who killed three people at a Fresno market. Allen already was serving a sentence for murder at the time the hit was ordered.

He had murdered someone, was serving a sentence, and then ordered a hit from his prison cell which caused the death of three additional people. Ah….this guy is just your normal grandfatherly type, right?

It’s interesting that the news station where I got this story is running a poll to see how many people think this death row inmate should get his sentenced reduced to life (I mean after all the poor guy is a sick, elderly man and execution at this point would be inhumane) or whether the execution should take place. When I looked at the poll this morning, 83% of voters felt he should be executed for the crimes he committed. Surprise, surprise…yet another MSM author who doesn’t have the pulse on readership. Go figure.

Update: So I come home from work to find they’ve changed the article’s title to “76-Year-Old Man Faces Execution in California.” Interesting how things change in a matter of hours. It doesn’t mean they still aren’t looking for our sympathy. The article references that his birthday was Monday (today?) and that he is legally blind, nearly deaf and in a wheelchair. What they fail to point out directly is that his victims aren’t legally blind, nearly deaf and in a wheelchair…they are DEAD.

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

No Comments

    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-20 12:24: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