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-19 07:47:02' 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





























One Potato, Two Potato, Three Potato…YUM!

This time of year, I really like stuff you can throw into the oven - it warms the house in the dead of winter, and is easy. I also love potatoes (you won’t see *me* on any low carb diet!). About 9 years ago, I got this recipe from my hubby’s Aunt Roxanne (a really cool aunt, by the way!). It is yummy!

Ingredients

1 stick butter, melted
1 small jar of Cheez Wiz (I use the spicy version, but both are good) - melt in the microwave
8 oz sour cream
1 can cream of mushroom soup (Campbells, of course!)
2 pounds frozen hashbrowns (cubed, not the shreds)
kosher salt and fresh ground pepper to taste
3 tbsp butter, melted (this is for the topping)
Corn flakes, crushed (enough to cover the top of the dish to your liking)

Instructions

Mix the stick of melted butter, Cheez Wiz, sour cream and cream of mushroom soup together until blended. Fold in the hashbrowns, salt and pepper until the hashbrowns are well coated. Place in a baking pan (9×13). Spread the crushed corn flakes over the top and drizzle the remaining melted butter across the cornflakes.

Bake at 350 degrees for 45-60 minutes.

Enjoy!

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

    January 2005
    M T W T F S S
         
     12
    3456789
    10111213141516
    17181920212223
    24252627282930
    31  
    • 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-19 07:47:02' 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