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-29 10:25:41' 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





























Happy Birthday, America!

Oh, say can you see, by the dawn’s early light,
What so proudly we hailed at the twilight’s last gleaming?
Whose broad stripes and bright stars, through the perilous fight,
O’er the ramparts we watched, were so gallantly streaming?
And the rockets’ red glare, the bombs bursting in air,
Gave proof through the night that our flag was still there.
O say, does that star-spangled banner yet wave
O’er the land of the free and the home of the brave?

On the shore, dimly seen through the mists of the deep,
Where the foe’s haughty host in dread silence reposes,
What is that which the breeze, o’er the towering steep,
As it fitfully blows, now conceals, now discloses?
Now it catches the gleam of the morning’s first beam,
In full glory reflected now shines on the stream:
‘Tis the star-spangled banner! O long may it wave
O’er the land of the free and the home of the brave.

And where is that band who so vauntingly swore
That the havoc of war and the battle’s confusion
A home and a country should leave us no more?
Their blood has wiped out their foul footstep’s pollution.
No refuge could save the hireling and slave
From the terror of flight, or the gloom of the grave:
And the star-spangled banner in triumph doth wave
O’er the land of the free and the home of the brave.

Oh! thus be it ever, when freemen shall stand
Between their loved homes and the war’s desolation!
Blest with victory and peace, may the heaven-rescued land
Praise the Power that hath made and preserved us a nation.
Then conquer we must, when our cause it is just,
And this be our motto: “In God is our trust.”
And the star-spangled banner in triumph shall wave
O’er the land of the free and the home of the brave!

If tomorrow all the things were gone I’d worked for all my life,
And I had to start again with just my children and my wife.
I’d thank my lucky stars to be living here today,
‘Cause the flag still stands for freedom and they can’t take that away.

And I’m proud to be an American where at least I know I’m free.
And I won’t forget the men who died, who gave that right to me.
And I’d gladly stand up next to you and defend her still today.
‘Cause there ain’t no doubt I love this land God bless the U.S.A.

From the lakes of Minnesota, to the hills of Tennessee,
across the plains of Texas, from sea to shining sea,

From Detroit down to Houston and New York to LA,
Well, there’s pride in every American heart,
and it’s time to stand and say:

I’m proud to be an American where at least I know I’m free.
And I won’t forget the men who died, who gave that right to me.
And I’d gladly stand up next to you and defend her still today.
‘Cause there ain’t no doubt I love this land God bless the U.S.A.
~Lee Greenwood “God Bless the U.S.A.”

God Bless America! Happy Independence Day!

UPDATE: Something special, below the fold…(thanks Wild Thing!)

…and in true Mrs. Vinnie form, I bring you a nice, fond memory of the Fourth of July:

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

1 Comment »

Happy 4th of July and have a great day celebrating!



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.

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

    March 2024
    M T W T F S S
         
     123
    45678910
    11121314151617
    18192021222324
    25262728293031
    • 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-29 10:25:41' 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