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-04-24 18:09:25' 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





























June 21st, 2005

Meme Tag - Music!

LindaSoG over at Something…and Half of Something tagged me for a meme that’s all about music:

Total volume of music files on my computer:

511 MB (okay, so I still listen to lots of CD’s - but I’m getting my iPod loaded slowly but surely!

The last CD I bought was:

Soundtrack to "Madagascar."  The kids love the "We Got to Move It" track (and yes, there are Kids Bop CDs in my truck!  ACK!)

Last aquired:

A whole bunch of 80s songs (Blondie, songs from "The Wedding Singer" and much, much more!)

Five songs I listen to a lot, or that mean a lot to me (eclectic, I know):

"Out Here on My Own" - Irene Cara (from the movie Fame)

"Nothing Else Matters" - Metallica

"Break Stuff" - Limp Bizkit (a great song for the drive home from work!)

"Island of Life" - Kitaro with Jon Anderson

"Eyes Wide Open" - Creed

I have to add that I love 80s music (born and raised child of the 80s).  I have tons of 80s music!

Four people to whom I’m passing the baton (if they so desire to take it):

Beth at MY Vast Right Wing Conspiracy

The ‘wife at An American Housewife

Tammy at A Mom and Her Blog

Raven at And Rightly So!

These are merely some shameless linking to some of my favorite sites (and ladies, you don’t have to do anything if you don’t want to).  Wheeeeeeeee!

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='215' 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 | Blogging Musings | Link
Trackback URL for this post:
http://www.merrimusings.mu.nu/index.php/archive/meme-tag-music/trackback/
No Comments
Comments closed

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

    April 2024
    M T W T F S S
         
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    • 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-04-24 18:09:25' 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



    •