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-03-28 06:59:14' 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





























Kung Pao Beef Recipe

This is the first year we are growing a *real* garden (let’s not discuss the tomatoes, though…they have literally taken over most everything!). My hubby has a love for peppers, and we’ve been pulling dozens of peppers out of the garden…including Kung Pao peppers. So….in thinking about some of my favorite Chinese food, I started searching around for a good Kung Pao Beef recipe. I found one from Tyler Florence here, but had to do some modifications to fit our taste and because some of the ingredients aren’t in our regular grocery store. I hope you enjoy this as much as my hubby, who has declared this recipe part of the “top 5″ list!

Kung Pao Beef

Ingredients:

1 1/2 pounds boneless beef sirloin
1 tablespoon Tamari soy sauce (regular will do as well)
2 tablespoons sesame oil
1 tablespoon sherry
1 egg white
1/2 teaspoon Kosher salt
2 tablespoons light colored oil
3 fresh Kung Pao peppers, split
4 cloves garlic, chopped fine
1/2 tablespoon ginger, grated
1 teaspoon whole black pepper, toasted and crushed
3 green onions, cut in pieces
1/2 red bell pepper, cut in very thin strips
2 tablespoons Tamari soy sauce
3 tablespoons sherry
2 tablespoons rice wine vinegar
1 teaspoon sugar
1 cup chicken broth
1 tablespoon cornstarch, stirred into 2 tablespoons water

Instructions:

Very thinly slice steak, against the grain. Combine the soy sauce, sesame oil, sherry, egg white and salt in a bowl. Add the beef and stir to coat. Marinate for 1/2 hour to an hour, covered in the refrigerator.

Place oil in a wok and turn heat on to high. Add the Kung Paos and cook until they begin to darken. At this point, you can choose to remove them from the oil or you can keep them in…I usually remove half of them. Add garlic, ginger and crushed black pepper, cooking for about 30 seconds to a minute. Add the green onions and red bell pepper. Remove the steak from the marinade and add it to the wok. Stir-fry the beef until brown. Add soy sauce, sherry, rice wine vinegar, sugar and chicken broth. Stir the cornstarch mixture and add it to the wok. Stir until slightly thickened. Serve over Jasmine rice (the best rice for Asian food….YUM!).

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

    August 2007
    M T W T F S S
         
     12345
    6789101112
    13141516171819
    20212223242526
    2728293031  
    • 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-03-28 06:59:14' 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