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-19 07:41:45' 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





























Get the Breathmints!

I have got to say one of my most favorite items in the food world is garlic. I love it with meat, with pasta, with potatoes, with most everything (unless we’re talking dessert!).
Enjoy!

I’d like to share two recipes, courtesy of Rachael Ray, that are easy to fix, and are easily served together due to their common theme - garlic!

4 Minute Spicy Garlic Shrimp

Ingredients
2 tbsp extra virgin olive oil (EVOO), 2 turns of the pan
4 cloves of garlic, crushed away from skin
1/2 tsp crushed red pepper flakes
24 jumbo shrimp, peeled and deveined, tails intact
2 tsp grill or steak seasoning blend (Montreal Seasoning by McCormick is best!)
1 lemon, jested and juiced
2 tbsp chopped parsley leaves (a handful)

Instructions
Heat a large skillet over medium high heat. Add EVOO, garlic, red pepper flakes and shrimp. Season with grill seasoning (you can also use course salt and fresh ground pepper) and cook shrimp 3 minutes or until just pink. Toss with lemon zest, juice and chopped parsley. Remove shrimp to a serving platter, leaving the garlic cloves in the pan.

Roast Potatoes with Rosemary (and GARLIC!)

Ingredients
2 pounds small potatoes (baby Yukon gold or red skins)
6 cloves garlic, cracked away from skin
2-3 tbsp EVOO (enough to just coat the potatoes)
2 tbsp fresh rosemary leaves, chopped
kosher salt and freshly ground pepper to taste

Instructions
Preheat oven to 500 degrees or highest setting.

Halve the potatoes and place on cookie sheet (I line mine with Reynolds Wrap Foil - makes for easier clean up!). Combine with garlic. Coat potatoes and garlic with oil and season with rosemary, salt and pepper.

Place on lower rack of oven and roast 20-25 minutes, turning potatoes once (around 12 minutes). Continue roasting until golden and crisp at edges.

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

    February 2005
    M T W T F S S
         
     123456
    78910111213
    14151617181920
    21222324252627
    28  
    • 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-19 07:41:45' 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