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 18:01:10' 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





























Roasted Garlic Recipe

My dad and I have often joked about the fact that we must have Italian ancestry through his family - we both love Italian food! We’ll never know for sure - Dad was adopted - but decided it doesn’t matter anyway, because we’ll eat like we are. For me, I am always seeking out Italian style recipes that are new, bold and fun to learn. One element that I discovered in many of the new dishes I found was roasted garlic. I looked awhile before I found a roasted garlic recipe that I liked and was easy to do.

What’s so good about roasted garlic? Garlic has a pretty bad reputation for being bitey, smelly and overpowering, right? Well, roasting garlic will mellow out the flavor and aroma, while developing a flavor that is incredible - sweeter and much more subtle than its raw form. Many of the dishes you see in restaurants that have a garlic cream sauce (or a cream sauce of any kind, at times) will be made with roasted garlic. Additionally, it is unbelievable what roasted garlic will do to a nice garlic bread (I’m drooling just thinking about it!) - and you can even spread it like butter on a piece of crusty bread. Trust me on this - this is a good recipe to have in your hip pocket to pull out as needed.

Ingredients

1 head of fresh garlic
Extra Virgin Olive Oil - aka EVOO - (no substitutes), enough to coat

Instructions

Preheat oven to 400 degrees. Break the head of garlic into individual cloves. Do not peel the skin off. Place the cloves on a sheet of aluminum foil and toss them in a teaspoon or two of EVOO (just enough to coat the cloves).

Fold the foil into an airtight pouch and place in the oven for about 30-45 minutes (I put on a cookie sheet "just in case"). When the garlic is done, and cooled a bit, simply squeeze it out of the skin - the flesh should just slide out simply - like toothpaste. Use it in your favorite recipes, or you can refrigerate in an airtight container for a few days.

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='54' 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-19 18:01:10' 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