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 < '2018-12-12 12:16:39' 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





























Bette Midler: Tree Discrimination!!

Environmental activist Bette Midler has gotten herself into a bit of a spot:

LIHUE, Hawaii — Bette Midler cut down more than 230 trees around one of her properties on the island of Kauai without a permit, and the state has recommended she be fined.

The staff of the Board of Land and Natural Resources recommended $6,500 in fines for having the trees felled and for building a graded road without permits required for the land zoned for conservation use.

Ms. Midler “didn’t realize permits were needed to remove the trees on a vacant 58,000-square-foot parcel of land on Kauai’s North Shore.”

“The whole idea with cutting the trees down was with the idea of improving the lot with native species” instead of the nonnative, invasive species that had grown there, Graham said. “It’s unfortunate that a mistake was made.”

The National Tropical Botanical Garden, which maintains three gardens on Kauai, will design a replanting plan that consists of appropriate native plants, Graham said.

A botanist hired by Midler after the fact said 120 Java plum trees, 100 octopus trees and 10 to 20 Madagascar olive trees that were cut down were all nonnative species. Some native trees also were removed from the property, the botanist said.

It’s rather interesting that someone who cares so much about the environment and global warming would fell well over 200 trees. Of course she’ll pay the fine, and of course there will be new, native trees planted in their places…does that make her close to godliness in the tree hugging world again?

Oh, and if Bette Midler, Tree Hugger Extraordinaire, can whack over 200 of her leafy friends, could she possibly remove 200 or so “nonnative, invasive” illegal immigrants from our side of the border? …oh, wait, sorry for my brief moment of EEEEEEEEEVIL Republican Thugdom.

Bette’s sure gonna have one VERY LARGE compost heap when this is all said and done. :-)

Bette? What did this tree ever do to YOU?

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

    August 2007
    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 < '2018-12-12 12:16:39' 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