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-04-23 19:28: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





























Cooking ‘Round the Clock by Rachael Ray
I got a copy of this book for Valentine’s Day. Okay, so my 3 year old daughter, who knows I like Rachael Ray, just happened to see it on the shelf, walked over and said "Momma - there’s Rachael Ray for you." I took it as an invitation.
I’ve had a chance to glance over this book, and love it. The book is designed to be a companion to Rachael’s Food Network show "30 Minute Meals." What I like about it is that it’s not all about full meals - there are muchies as well as full-blown dinners in the book. It is themed by hours of the day - breakfast, brunch, late night, etc.
The main reason I enjoy Rachael Ray is for her approach to cooking - simple, quick and full of flavor. This book chronicles many recipes that meet that standard. I’m including one of my favorites:

Bacon-Wrapped shrimp and Scallops

Ingredients:

12 jumbo shrimp (16-20 count per pound), raw, peeled and deveined 12 large sea scallops, trimmed and well drained Grated zest and juice of 1 lime 1 tablespoon flavored oil* 1 tablespoon grill seasoning blend (Montreal Seasoning by McCormick), or coarse salt and freshly ground black pepper 1 teaspoon crushed red pepper flakes 12 slices center-cut bacon, cut in half toothpicks 3 scallions, very thinly sliced on an angle

Instructions:

Preheat oven to 425 degrees.

Place shrimp and scallops in a shallow dish or bowl. Dress seafood with lime zest and juice, oil, grill seasoning blend, and red pepper flakes. Wrap each shrimp and scallop in a half-slice of bacon. Wrap each shrimp working from head to tail, pulling bacon snugly around the shrimp. Wrap the bacon around the outside of each scallop. Fasten bacon in place as necessary with toothpicks.

Arrange shrimp and scallops on a slotted baking pan, such as a broiler pan, to allow draining while bacon crisps. Bake shrimp and scallops until shrimp is pink and curled, scallops are opaque, and bacon is crisp, 10 to 14 minutes (shrimp may finish before the scallops).

Arranged cooked seafood on platter and sprinkle with chopped scallions.

*Rachael’s recipe calls for toasted sesame oil, but I don’t care for it due to its very strong odor/flavor. I recommend really any flavored oil. I use one that is flavored with garlic, ginger and chile, if I use flavored oil. The bacon gives it such flavor you could use just a regular, light colored oil.

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

    April 2024
    M T W T F S S
         
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  
    • 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-04-23 19:28:27' 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