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 12:03:11' 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





























Pan Seared Rib Eye

Recipe courtesy of Alton Brown

Introduction:

Coming from the Midwest, steak is virtually a staple in our household (we’re in "beef country!"). While this recipe of Alton Brown’s calls for Rib Eye steaks, we have used different cuts such as New York Strip or Filet.

Ingredients:

1-2 boneless rib eye steaks, 1-1/2 inch thick (I typically stick with an inch in thickness)
Canola oil to coat
Kosher salt and ground black pepper

Instructions:

Place 10 to 12 inch cast iron skillet in oven and heat oven to 500 degrees. Bring steak(s) to room temperature (this is very important!).

When oven reaches temperature, remove pan and place on range over high heat. Coat steak lightly with oil and season both sides with a generous pinch of salt. Grind on black pepper to taste.

Immediately place steak in the middle of hot, dry pan. Cook 30-45 seconds without moving. Turn with tongs and cook another 30-45 seconds, then put the pan straight into the oven for 2 minutes (the thicker the steak, the longer this time may need to be). Flip steak and cook for another 2 minutes (This time is for medium rare steak. If you prefer medium, add a minute to both of the oven turns).

Remove steak from pan, cover losely with foil, and rest for 2 minutes (this allows juices to redistribute so they don’t all flow out with the first cut of your steak).

What I serve this with: Of course this would work with a nice baked potato and a salad or other veggie (corn on the cob…yum!). I also like to serve it with garlic parsley new potatoes, whose recipe I will post in my next blog.

My 2 Cents: I love Alton Brown, mostly because of this recipe! He helped me appreciate the finer side of cast iron! I can’t describe the difference between this steak preparation versus others, other than to say it is a step up from most! I will say that we’ve never been able to get a medium rare steak by cooking 2 minutes on each side, as the recipe calls for. We are typically cooking closer to 3-4 minutes per side, and for thicker steaks, closer to 5-6 minutes. This could be due to a variance in our oven temperature, or my impatience while bringing the steak up to room temperature. You will want to experiment to get the right "doneness" for you. It comes highly recommended, though!

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='14' 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 12:03:11' 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