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-20 12:06:16' 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





























The Year: 1968

I’m sitting here, reflecting on the fact that I was actually born 38 years ago today. It was such a different world then, compared to today. I know my Dad wasn’t here in the states when I was born (he was stationed in Thailand). I know that Martin Luther King, Jr. was killed. I know Lyndon Johnson was president. But what else?

~North Korea seizes US Navy Ship Pueblo, holding 83 on board as spies (the same year they launched the Tet Offensive).

~Senator Robert F. Kennedy is killed in Los Angeles.

~Median Household Income was $7743 (current dollars)

~Cost of a first class stamp was $.05, but increased to $.06 early in 1968.

~Green Bay won the Superbowl!!

~The motion picture rating system debuts with G, PG, R and X.

~2001: A Space Odyessy was released.

~Aminocentesis is developed.

~It was a leap year!

~Color TV is available in Canada for the first time!

~Soap Opera One Life to Live debuts.

~NASA launches Apollo 7.

~Cost of a new home: $26,660

~Cost of a gallon of gas: $.34

~Cost of a dozen eggs: $.53

~Cost of a gallon of milk: $1.07

~The Dow Jones high point was 985.

And these “famous” people were born in 1968:

~Cuba Gooding, Jr.
~Mary Lou Retton
~Lisa Marie Presley
~Ashley Judd
~Debra Messing
~Rachael Ray
~Will Smith
~Hugh Jackman
~Owen Wilson

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

    October 2006
    M T W T F S S
         
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  
    • 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-20 12:06:17' 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