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 11:44:01' 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





























Breakfast Egg Sandwich



Introduction:

I can’t remember when I didn’t make egg sandwiches. They are so simple for breakfast and sooo tasty! When I got married and made them for my hubby, he shared in my love for this simple little sandwich and it has become somewhat of a routine to have egg sandwiches for breakfast on our days off.

Ingredients:

1-2 tbsp butter (depends on the size of your skillet - you want a nice layer with no dry spots)
1 large egg
kosher salt, pepper to taste
1 slice of American Cheese (real and processed are both good!)
2 slices of wheat bread (or bread of your choice), toasted
spray butter, or soft butter to spread on toast

Instructions:

Place butter in cool skillet on stove, melting butter over medium heat. Once butter is melted, and pan is hot, start toasting your bread in the toaster. Crack open your egg into the pan and sprinkle with salt and pepper. Once the egg has cooked to a consistency that allows you to flip it, turn the egg over, lightly sprinkling the other side with salt and pepper. Place the cheese slice on the egg, and turn the burner off. The egg will continue to cook and the cheese will melt. Once the toast is done, place it on a plate and either generously spray with spray butter, or lightly spread soft butter on both slices of bread. Place the egg/cheese on once slice of bread and put the other slice of bread on top. Lastly, enjoy this sandwich as the yolk runs down over your hand!

What I serve this with: In a previous post, I mentioned my love for cast iron skillets. They are GREAT to cook bacon in! Bacon is a great side for this sandwich, and you can even throw the bacon on top of the sandwich. YUM!

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

No Comments

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

    January 2019
    M T W T F S S
         
     123456
    78910111213
    14151617181920
    21222324252627
    28293031  
    • 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 11:44:01' 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