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-15 21:06:11' 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





























A Funny Thing Happened On The Way To The Comments Section

Last evening, LGF opened up the register to comment, and I managed to slip in. Normally, I just read the posts and skip the comments, now I’m glad I have an excuse to go in. That’s where I found this.

From MEMRI:

The Last Warning To The American People

“Despite the fact that the New York, Washington, Madrid, and Londonexpeditions have been carried out a few years back. The search for clues on how they were conducted in such a successful manner is still going on and reports upon reports are still being written about them. However, the next expedition might not find someone who can provide analysis for. The top intellects, strategists, and analysts, will be totally clueless as to how to explain what occurred. Let me also inform you that we are talking about two operations, not one. The scale of one of them is larger than the other but both are large and significant. However, we will start with the smaller, and temporarily put the larger on hold to see how serious the Americans are about their lives. Should you value your own life and security, accept Muslims’ demands, but if you shall prefer death (over giving in to Muslims’ demands). Then, we, by the grace of Allah, are the best in bringing it (death) to your door steps.

Follow the link to read it all.

I did a Google News search and there is none, zero, mention of this in the media. The only other two hits I got were the SITE Institute and World Net Daily.

Whether this is a legitimate threat, or some jackoff spouting off, we need to get the word out anyway.

Thanks for keeping us informed, media.

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

    March 2006
    M T W T F S S
         
     12345
    6789101112
    13141516171819
    20212223242526
    2728293031  
    • 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-15 21:06:11' 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