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 00:31:50' 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





























Merri’s Chili for a Chilly Day

Today was a pretty bad weather day - sleet causing very icy conditions - and we’ve got more coming - they are predicting more sleet tomorrow and then 6-12" of snow on Wednesday - UGH! How do I warm up my hubby, the mail carrier, after a long day of carrying mail in this crud? I know what you may be thinking, but let’s stick with food….hehehe. Honestly, chili is one of his favorite meals on a day like today. Here’s my "quick to put together" recipe that tastes absolutely delicious!

Ingredients:

Extra Virgin Olive Oil (EVOO), two turns around a frying pan
1 medium yellow onion, chopped into small pieces
3 garlic cloves, crushed and chopped
1 pound of lean ground beef or chuck (or venison, for those of you who have a hunter hubby)
Kosher salt to taste
Ground black pepper to taste
crushed red pepper flakes to taste
A couple of glugs of beer (optional)
2 cans of Bush’s Best Chili Beans
1 can of Bush’s "Chili Magic" (I use "Traditional" but any flavor will do)
1 can of tomato sauce
1 tablespoon (or to taste) of dark chili powder

Instructions:

Place a frying pan over high heat, coat with two turns of EVOO and toss in the onion and garlic, stirring and cooking until they are slighly opaque and tender. Break up the ground meat into the frying pan and add salt, pepper and red pepper flakes. Throw in a couple of glugs of beer, if you like (the alcohol cooks out, leaving a nice concentrated flavor). Drain the fat off of the meat and veggie combination.

In a larger pot, put the chili beans, Chili Magic and tomato sauce, gently mixing. Add the meat and onions, as well as the chili powder (at this point I also add more red pepper flake and any additional salt/pepper if needed). Heat through on medium heat, stirring occasionally.

ENJOY - and I hope the weather is treating you better where you are!

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

    January 2005
    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 00:31:50' 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