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:26:29' 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





























Mexican Chef Salad

This is a great recipe for a salad my sister made when I was growing up. It sure brings back memories!

Ingredients

1 pound lean ground beef
1 small to medium onion, chopped fine
2 cloves of garlic, crushed and chopped
1 packet of taco seasoning
1 can of chili beans, a little of the juice drained
1 head of lettuce, chopped into salad sized pieces
3-4 small tomatoes, chopped into pieces
1 package of shredded cheese (I use the Mexican 4-cheese, but you can use any you prefer)
1 small bag of Nacho Cheese Doritos (not the super size)

Instructions

Brown the ground beef, onion and garlic in skillet. Add the taco seasoning during the browning process. Mix in the can of chili beans, heat through.

In very large bowl, toss together lettuce, tomatoes and shredded cheese. Add the beef/bean mixture, mixing thoroughly. Right before serving, crush down the Doritos, and add to the mixture, coating completely. Serve in large bowls. You can serve with Ranch dressing, sour cream, green onions, guacamole, salsa, or any other topping you like.

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='55' 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 < '2019-01-19 18:26:29' 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