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-18 23:10:19' 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





























Rotisserie Chicken and Veggie Grill

It’s been awhile since I’ve posted a recipe, so I thought I’d share a most recent meal we had, all prepared on our backyard grill:

Rotisserie Chicken

Ingredients:

1 whole chicken (mine was around 3 to 3.5 pounds)
extra virgin olive oil
salt, pepper, thyme, any seasoning you enjoy on chicken (I like McCormick’s Montreal Steak Seasoning)

(below is the basting liquid)
1 bottle of Apple Cider Vinegar
Several cloves of garlic, crushed
1-2 cups of chicken stock (you can use water, if desired)
1 stick of butter, cut into pats
seasonings to taste (I used thyme, a couple of bay leaves, salt and pepper, red pepper flake)

Instructions:

Heat the grill for 15 minutes on high heat. Feed the bird onto the rotisserie rod, ensuring the wings and legs are either tied or tucked so they don’t fall away from the bird. Lightly coat the chicken in olive oil and rub the seasonings lightly into the skin of the bird on all sides. In a rotis pan (a pan that would fit on your grill, under the chicken on the rotisserie), combine the remaining ingredients. What’s cool is that you can pretty much personalize this basting liquid to your own flavorings. One great example would be to throw in some lemon juice to make more of a lemon-pepper flavoring. You could also toss in some BBQ seasoning or some hickory flavored salt to add new flavors - the possibilities are endless! Once you have put the ingredients into the rotis pan, use a whisk to combine. Place on the grill, then connect the rotisserie iron to the grill’s rotisserie motor. Cook for one and a half hours (approximately), basting every 15-20 minutes. The rotis pan should NEVER become dry. If the fluids are cooking away, you can reguarly add more chicken stock and/or water. The bird’s juices will drip into the pan, allowing for further flavor throughout basting.

About 45 minutes before the bird is done, you will want to assemble your veggie packet, which will need about 25-30 minutes on the grill. Again, you can personalize this however fits your lifestyle and your taste. Here’s what I used in the above meal:

Veggie Grill

Ingredients:

3 ears of corn, husked and cut into 3 pieces each
2 cups fresh green beans
1 cup fresh sliced carrot (or baby carrots)
1 container of mushroom caps, cleaned and chopped in half
1 pound of red potatoes (I used a small size), halved or quartered
1 red bell pepper, cut into 1-inch pieces
1-2 tbsp extra virgin olive oil
1 packet of onion soup mix (I use Mrs. Grass)
thyme, salt and pepper to taste
2-3 tbsp butter, cut into pats

Instructions:

In very large bowl, mix all ingredients except the butter. The veggies should all be evenly coated. Place in a foil pouch, spreading out the butter pats on top of the veggies. When creating the pouch, it should be made of two layers of extra heavy aluminum foil (double-fold all edges, allowing space for steam during cooking). At about 30 minutes before the bird will be ready (at the hour mark), place the veggie pouch on the grill. All of the veggies should be fully cooked and ready to eat withn a half an hour at high heat on the grill.

Enjoy!

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

    June 2006
    M T W T F S S
         
     1234
    567891011
    12131415161718
    19202122232425
    2627282930  
    • 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-18 23:10:19' 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