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 < '2018-12-12 01:09:26' 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





























Rachael’s Macaroni & Cheddar Cheese

Recipe Courtesy of Rachael Ray

…this one is for Emma out in the Blogosphere (oh, and it’s tasty, too!)!

Ingredients

1 tablespoon vegetable or olive oil, 1 turn of the pan in a slow stream
2 tablespoons butter
3 tablespoons flour
1 1/2 cups whole or 2 percent milk
3 cups shredded white cheddar cheese
1/2 teaspoon nutmeg, ground or freshly grated
1/4 teaspoon ground cayenne pepper, a couple pinches Salt (kosher, of course!)
1 pound elbow macaroni, cooked 8 minutes or to al dente, with a little bite to it

Instructions

Heat a medium, deep skillet over medium heat. Add oil and butter. When butter melts into the oil, add flour and combine. Gently cook, whisking flour and butter together, until smooth and flour has had a chance to cook, about 3 minutes. Slowly add milk while continuing to whisk. Gently bring milk to a bubble while stirring frequently. Allow the milk to thicken a bit, then stir in 2 cups of shredded cheddar cheese a handful at a time. Season sauce with nutmeg and cayenne. Taste and add a little salt, if you like. Add cooked pasta to sauce and coat completely by turning over and over in the cheese sauce. Transfer to a baking dish and top with remaining cheese. Place baking dish under a hot broiler and brown the cheddar cheese on top.

My 2 Cents: I love this recipe, but in true Merri form, I tend to alter things a bit. I can’t always get white cheddar locally, so I’ve substituted other types of cheddar with success. I imagine that other cheeses can be substituted easily, too. One other thing - it is a *must* to put ground black pepper with my macaroni and cheese - can’t seem to get over that. So….I usually add ground black pepper at the same time I’m adding the cayenne and nutmeg.

Thanks for the idea to post this recipe, Emma! …and thanks, Rachael!

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

    December 2018
    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 < '2018-12-12 01:09:26' 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