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 07:29:38' 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





























We Are All Mohammed Now

Aaron, in a comment on this post, gave me an idea.

Instead of all of us being Danish, let’s just all be Mohammed.

There are many advantages to living this way.

The Danes and everyone else are on the defensive concerning this issue. By being Mohammed yourself, you get to go on the offensive. And the best defense is a quick offense.

If you are Mohammed, and someone takes your picture, you may behead them. Especially if it’s that obnoxious relative you prayed wouldn’t show up at the family reunion.

You get to breeze through security at most major airports.

You get to rape, pillage, and burn at the most minimal slight of your name.

Everyone will add PBUH after they refer to you.

So, from this point on, anyone who comments on my posts without the name Mohammed, or one of its derivates, will be summarily deleted.*

Of course I, don’t have to change my blog name to Mohammed. I am granted free license to be a hypocrite.

Because we are all Mohammed now.

Note: leave your proper email and URL in your comment. You just have to change your name to Mohammed. Mustafa and PBUH are also accepted. So are Pedophile Prophet, Pedophile Pimp Prophet, and Suicide Troll.

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

    February 2006
    M T W T F S S
         
     12345
    6789101112
    13141516171819
    20212223242526
    2728  
    • 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 07:29:38' 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