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-28 12:28:57' 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





























Oh Holy Night!

Night

Oh holy night!

The stars are brightly shining

It is the night of the dear Savior’s birth!

Long lay the world in sin and error pining

Till he appear’d and the soul felt its worth.

A thrill of hope the weary world rejoices

For yonder breaks a new and glorious morn!

Fall on your knees

Oh hear the angel voices

Oh night divine

Oh night when Christ was born

Oh night divine

Oh night divine

Led by the light of Faith serenely beaming

With glowing hearts by His cradle we stand

So led by light of a star sweetly gleaming

Here come the wise men from Orient land

The King of Kings lay thus in lowly manger

In all our trials born to be our friend.

Truly He taught us to love one another

His law is love and His gospel is peace

Chains shall He break for the slave is our brother

And in His name all oppression shall cease

Sweet hymns of joy in grateful chorus raise we,

Let all within us praise His holy name.

May God bless each and every one of you and may the true spirit of Christmas be in your hearts.  May God’s hand reach down and rest upon those who are away from family this Christmas, whether it be in service or in hardship.  May all of you find peace in God’s gift to us - Christ!

(more…)

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

    December 2005
    M T W T F S S
         
     1234
    567891011
    12131415161718
    19202122232425
    262728293031  
    • 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-28 12:28:57' 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