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 17:37:49' 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





























Linguine with White Clam Sauce

This is an awesome recipe!  I need to make it more than I do.  The flavor is just amazing!  Some people are a bit apprehensive about cooking with anchovies - I used to be one of them.  In this recipe, the anchovies actually do "melt" and you would never know they are in the pasta.  You would definitely know if they weren’t there, though!

Ingredients:

1/4 cup extra-virgin olive oil
1 teaspoon red pepper flakes
4 to 6 cloves garlic, finely chopped
1 tin flat fillet of anchovies, drained, 6 or 7 fillets
2 tablespoons fresh thyme leaves, 4 or 5 sprigs stripped or 1 1/2 teaspoons dried
1 cup dry white wine
1 cup clam juice or chicken stock (I do some of each)
1 can (15 ounces) fancy whole baby clams
1 lemon, zested
1 pound linguini, slightly undercooked, about 6 to 7 minutes
1/4 cup chopped parsley leaves
Lots of black pepper and some coarse salt
Crusty bread, for mopping

Instructions:

Heat a large deep skillet over medium heat. Add extra-virgin olive oil, 4 turns of the pan in a slow stream, red pepper flakes, garlic and anchovies and cook until anchovies melt into the oil. Add thyme and wine. Reduce wine 1 minute. Add clam juice or stock, clam juice will give the dish a stronger clam flavor, chicken stock will give it a buttery personality. Stir in clams and lemon zest. Drain pasta. Add to skillet and toss with sauce 2 to 3 minutes, until pasta is al dente and has absorbed some of the sauce and flavor. Add parsley, pepper and salt, to your taste and serve with bread for mopping up remaining juices.

recipe courtesy of Rachael Ray

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

    April 2005
    M T W T F S S
         
     123
    45678910
    11121314151617
    18192021222324
    252627282930  
    • 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 17:37:49' 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