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 < '2024-04-24 19:36:22' 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





























November 4th, 2006

Rachael Ray Show: Friday’s Soldier Surprise

I haven’t commented much on Rachael Rays’ daytime talk show, mostly because I think her website does a fabulous job of wrapping it all up. I can’t help but comment on yesterday’s show. Why? It moved me to tears while I was in the dentist chair. me *and* the hygenist!

I had a 9am appointment yesterday, the same time the Rachael Ray Show was on. She had a *great* show…a woman had written in looking for a way to throw a 39th and 40th birthday for her husband, who will be going to Afghanistan for 18 months. He’s a leap year baby, and will be celebrating number 39 and number 40 while in Afghanistan. Rachael decided to surprise him on the show and brought all of his family members to celebrate as well. It moved the soldier to tears. And here I was…getting my teeth cleaned with tears pouring out of my eyes. When my hygenist saw them, she said “Thank God…I thought I was going to have to explain my weepy self to you!” But even Racahel Ray shed a few tears, so we felt better about it. The whole thing was funny and I had to watch the show on Tivo again last night.

The thing that moved me most were his two absolutely adorable sons. They sure seemed to have nothing but admiration and love for their daddy and my heart was aching with the fact that soon they’d be without him for a year and a half. What a sacrifice our men and women make to protect my - our - freedom.

Rachael has more about the show on here site here.

Bo - best wishes to you and many more Happy Birthdays - go with God and be safe on your journey!

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

So said Merri | Rachael Ray Musings | Comments & Trackbacks (7) | Link

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

    November 2006
    M T W T F S S
         
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    • 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 < '2024-04-24 19:36:22' 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



    •