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:31:41' 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





























meme……Meme……MEME!!!!!!!!!!

My DEAR friend Beth [ahem….a MEME?] got me out of laziness to respond to her meme tag. How could I refuse such a task? I mean, after all, it’s heavy-hitting, serious journalism such as this that makes me so famous, right? BWHAHAHAHAHAHAHA!

Here’s the meme: Share six non-important things/habits/quirks about yourself.

1. I have texture issues with food. Generally I’m not a picky eater, but I draw the line when people put nuts into food. Cookies, cakes, brownies, fudge, ice cream….they all have to be nut free. I can’t stand having nuts left in my mouth when the rest has melted away! EWWWWWWWWW!

2. I have a completely ridiculous fear of bugs and spiders. More so spiders, but if something has a shell and hairy looking appendages, well, forget about it. Vacuums do wonders…a motto I live by!

3. Quite the opposite of Beth, I could go to a movie theater every weekend. I LOVE the theater, the popcorn and all that. I go out of my way to check for when movies are being released…I have “movies.com” bookmarked. I have the same freakishness about when movies come out on DVD. I’m usually going to a store over lunch on Tuesdays to pick up the next new release.

4. I can remember stupid stuff like full lines from obscure songs and from movies. I know some entire segments from “Good Morning, Vietnam” as one example. But ask me what I’m doing tomorrow, and I have to look at my day planner.

5. I have to have COLD pillows in order to fall asleep. I flip my pillows at least four times a night before I fall asleep. I love summer when the A/C is on because it blows onto my pillows if I position them just right.

6. I love fresh tomatoes! In the summer, I can eat them until I have sores in my mouth and my lips become chapped from all of the acid. Salt, pepper and tomatoes….YUMMMMMY!

Okay, so I think I met the requirements of this meme. I don’t think you could get any more non-important than that, huh?

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

    February 2008
    M T W T F S S
         
     123
    45678910
    11121314151617
    18192021222324
    2526272829  
    • 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:31:41' 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