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-19 15:15:30' 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





























Tough Competition!

So, the finalists of the 2006 Weblog Awards have been announced and I’m proud to say that Merri Musings is a finalist on one of the categories. Check it out here!

HOWEVER….

This fella got nominated, too. In the same category. Who gets to sleep on the couch each night may actually be a regular conversation once the voting begins. Heh.

I’ll let you know when voting begins, if ya think my blog is worthy of your vote. :-)

…to be continued!

UPDATE:

In all fairness, I feel a need to confess. While Hubby and I are in the same category competing, he DID nominate me, so THANK YOU my darling for nominating me for this category! [insert much smooching and hugging here…are you still watching? Perverts! Heh!]

So here’s the official badge (soon to come to my sidebar!).

The 2006 Weblog Awards

Once the polls open, Now that the polls are open, you’ll be able to click on the image and it will take you to the particular category Merri Musings is in and you can vote, vote, vote (even every day if you’d like!!!).

I would also add that Nancy seems to forget she’s my partner in crime and should be as excited about this nomination as I am. I don’t know what I’d do without her posts - especially when *real life* kicks in!

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


EVOO is Now a REAL WORD!

Yes, ladies and gentlemen. THAT is a picture of Rachael Ray get a certificate from a very smart looking woman. The certificate authenticates that “EVOO” is now in the Oxford Dictionary.

“In order for a word to get into the dictionary it has to be useful to people. It’s not just enough to be a fabulous celebrity to get your word in. You have to make a word that people like to use. There are words that are connected with celebrities that are not going to make it in the dictionary anytime soon; we’re not going to put in “Brangelina.” But “EVOO” we see people using. We have a big database of about a billion and a half English words. In that database we found evidence of “EVOO” being used and in more than half of the examples, “Rachael” is also in the same sentence.”

How cool is that?

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

    December 2006
    M T W T F S S
         
     123
    45678910
    11121314151617
    18192021222324
    25262728293031
    • 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-19 15:15:30' 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