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:34:01' 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





























Andrea Yates, Continued

I hope not to appear obsessed with this, but this piece crossed my eyes earlier today and I couldn’t comprehend what I was reading, this particular quote from the Boston Globe (emphasis mine):

Prosecutors agreed that Yates was sick but said she was sane enough to know killing the children was wrong.

“We are extremely disappointed with the verdict,” lead prosecutor Joe Owmby told reporters.

Yates was being tried for the murder of only three of her children, but Owmby said he would recommend to District Attorney Chuck Rosenthal that he not seek a trial for the other two.

Why is that? Why would they stop? What about the justice for the other children and/or the potential for them to seek a sentence that would put her in prison for life, versus the opportunity to walk free (even if it is years later)? What would prevent them from seeking this trial? In many cases they choose to divide up the charges, choosing to pursue only some with the idea that they could follow up with further trials as needed. Do the prosecutors believe her sentence is adequate or do they feel they have no hope in winning?

I have to let it go or it will consume me. I need to go hug my kids now.

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

4 Comments »
Nancy said:

Hopefully Andrea will get the mental help that she needs. I'm sure she'll have a nice room and be able to even bring in some of her own personal belongings to make it feel more like "home" during her "recovery". Everyone should do everything possible to speed her "recovery", so that she, too, can move on with her life.
(Keyword: LIFE!!!) (Please read this with the EXTREME sarcasm which was intended!)



Andrea Yates says...

My kids drove me crazy, but I feel better now.



Yeah, let it go. I think the prosecutors are seeing the handwriting; that they have no chance of getting a stiffer penalty. After all, their first conviction/penalty effort was overturned. And, there is a whole raft of other miscreants to deal with.



Chris said:

Yeah, I understand the mentally incompetent bit, but I'm with you. She did it knowing it was wrong, regardless of her sanity.

It's a messed up world.

Chris
My Blog



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-20 12:34:01' 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