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-11-17 09:30:54' 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





    • Design by





























December 30th, 2007

So……

….I read that the lighted ball they drop at midnight for New Year’s is going ‘green’ this year:

NEW YORK — The Times Square New Year’s Eve ball is celebrating its centennial by going green.

The star of the world-famous holiday extravaganza was revamped this year with more than 9,000 energy-efficient bulbs that use about the same amount of electricity as 10 toasters.

Philips Lighting created the light-emitting diodes specifically for the event. It says they are smaller but more than twice as bright as last year’s lights, which were a mix of more than 600 incandescent and halogen bulbs.

So, um, well….okay….but I only have one question…well, maybe a couple. They used more than 600 incandescent and halogen bulbs last year….for that ball lighting ceremony that lasts, oh, for a brief amount of time, right? Surely the bulbs all didn’t burn out. Is it truly ‘green’ to replace bulbs that could still be used the following year? What happened to the aforementioned 600+ bulbs? I’m just curious, really…someone has to know. Anyone?

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='735' 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

Uttered da Merri | Social Musings | Link
Trackback URL for this post:
http://www.merrimusings.mu.nu/index.php/archive/so/trackback/
4 Comments »
Nigel said:

Merri,

I believe those bulbs were shipped down to Greenwich Village for use thusly (at about 1:42 in the clip:

...

01.01.08 um 2:54 pm


Merri said:

Dooood....I think you are RIGHT! HAHAHAH!

01.01.08 um 10:26 pm


Domestic Divapalooza said:

Happy New Year!! ;)

02.01.08 um 10:49 pm


ptg said:

Green works better as a color than as a philosophy.

05.01.08 um 10:03 am


Leave a Comment!

:mrgreen: :neutral: :twisted: :arrow: :shock: :smile: :???: :cool: :evil: :grin: :idea: :oops: :razz: :roll: :wink: :cry: :eek: :lol: :mad: :sad: :!: :?:

Please note: Comments may be moderated. It may take a while for them to show on the page.

Trackback URL for this post:
http://www.merrimusings.mu.nu/index.php/archive/so/trackback/

Back To Main


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

    November 2024
    M T W T F S S
         
     123
    45678910
    11121314151617
    18192021222324
    252627282930  

    • 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-11-17 09:30:55' 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



    •