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:01:15' 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 Not So “French Dip” Sandwiches

This is a pretty tasty sandwich that can be made fast!

Merri’s Not So "French Dip" Sandwiches

These are so simple. Sometimes, we need to eat quick, but we don’t want the standard fast food fare. This almost seems faster than fast food!

Ingredients

1 jug of concentrated "Au Jus" sauce (we use one called "Johnny’s" - it is AWESOME), 8 0z
16 oz water
1 lb high quality cooked roast beef, sliced about twice as thick as sandwich sliced (from the deli)
fresh ground black pepper
Steak seasoning to taste (we use McCormick’s Montreal Steak seasoning…yum!)
slices of swiss or provolone cheese
hoagie buns, sliced lengthwise and slightly toasted

Instructions

Place the au jus sauce, water, steak seasoning and pepper in a larger sauce pan, and bring to a simmer. Simmer approximately 5 minutes. Add the roast beef and continue simmering until heated through (approximately 5 minutes…you don’t want to overcook the roast beef or it will get tough). Remove from heat.

Using tongs, pile meat on top of a hoagie and add cheese slices to your liking (sometimes at this point I will place the sandwich half with the cheese on it under the broiler until it is melted…yum!). Ladle out some au jus sauce into a shallow bowl for dipping.

You can make quite a number of variations - different spices or other ingredients will change the flavor of your au jus. Let your creative jus’s flow (alright - I know it was a bad pun…you don’t have to tell me!)!

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='24' 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:01:15' 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