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-10-20 16:08:32' 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





























Speedos are Back!

The AP reports that Speedos are now legal again for men in Cape May, NJ.  For more than 30 years, this resort area in New Jersey said a resounding NO! to men wearing the skimpy little suits.

Not that everyone’s cheering. It’s often the older guys - the ones with beer guts, or wrinkly skin, or unsightly tufts of hair - who wear the tiny swimsuits.

Oh, you mean like this guy?

"The people you want to see in the Speedos, you don’t," said Maggie Creighton, 19, who works in a downtown lingerie store.

I think young Maggie was hoping to see this guy there:

Sorry, Maggie.  Ain’t gonna happen!  That’s the stuff of Speedo catalogs, I’m afraid!

"A lot of people do come in and say ‘Do you carry Speedos?’ said Becky Fitzgerald, sales clerk at Della’s General Store. "It’s the 40- to 50-year-old group who ask. And it’s funny, their bodies aren’t the shape for Speedos."

Whodathunkit?

Crossposted at The Wideawakes

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


The Greatest Daughter in the World is Now Four

On May 1, 2001, a beautiful little girl came into this world.  She weighed a mere 8 pounds, 8 ounces but brought us tons and tons of love.

Her smile brings so much joy to others - to us, particularly - but to complete strangers routinely.  We have to be on our guard because she wants to hug and talk to every single person that she sees. 

Her biggest wish today, her fourth birthday, was to have a "Giant Care Bear" and it was supposed to be "THIIIIIIISSSS BIGGGGG" so Mommy got lucky and found the perfect one for her. 

You can tell that she really, really liked her presents.  Her Barbie has been dressed, undressed, put to bed, woke up, workout clothes put on and then back to bed oh, about 372 times during the past hour.  She has called her friend Kayla about 85 times on her "Barbie Princess cell phone" and she has done a few cheers as well, with her new cheerleading stuff.

Happy, Happy Birthday, Bug - I love you!  I can’t believe it was already 4 years ago that you came into our lives.  We couldn’t imagine life without you!

Happy Birthday to me!  Happy Birthday to me!  I’m Four Years today, and now I’m not three!

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

    May 2005
    M T W T F S S
         
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  
    • 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-10-20 16:08:32' 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