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 < '2024-03-19 00:43:06' 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





























Abu Musab al-Zarqawi DEAD!

As reported by CalTechGirl over at Not Exactly Rocket Science, ABC news is currently reporting that Abu Musab al-Zarqawi has been killed, along with his spiritual advisor. They are saying he wasn’t dead right away, and American troops turned him over to the Iraqis and he subsequently died of his injuries.

It’s now on CNN’s website as a “breaking report” on their website (this is 2:34am Central Time), but there are no additional details. As of yet, Fox isn’t reporting on it, and CBS and NBC are quiet as well.

I, for one, am crossing my fingers. ABC reports were confident in the news as they didn’t say “possibly killed” or “potential news” or anything like that. Let’s hope they are right.

UPDATE: Now FOX News is finally talking about it by interrupting with a Special Report and they have the big ole yellow banner on their site proclaiming the news. …and the news world starts waking up!

UPDATE II: The “official” announcement was just now made in Baghdad (it was reported on Fox News live at 2:45am CDT). The news conference is being broadcast live. Prime Minister Nuri al-Maliki talked about the evil past of Zarqawi and OFFICIALLY confirmed Zarqawi’s death. WHEW! Another evil terrorist down and, as someone said on ABC news, another nail in the coffin of Al Qaida. Now General Casey is now speaking and confirmed that it was not only Zarqawi (identified through visual verification/facial recognition, known scars and fingerprints) but a spiritual advisor (a top lieutenant as he said), Sheikh, Abu Abdul Rahman. This latest effort has spanned over several weeks. The bombing was at a safe house 30 miles NE of Baghdad.

UPDATE III: More over at The Jawa Report (via Hubby!)

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

    June 2006
    M T W T F S S
         
     1234
    567891011
    12131415161718
    19202122232425
    2627282930  
    • 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 < '2024-03-19 00:43:07' 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