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-04-18 22:00:43' 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





























Taco Cheesecake Recipe

I was trying to organize some of my recipes tonight, and came across this one. If you ever need to bring a dish to a potluck or if you are having "Mexican food night" at your house, this recipe is AWESOME. It travels well and it is gone in no time!

Ingredients & Instructions

Mix together

1 cup crushed nacho chips (I use Doritos)
3 tbsp butter

Press this crust onto bottom of 9" springform pan and bake at 350 degrees for 15 minutes.

Mix together

2 packages of cream cheese (bricks), softened
2 eggs

Add to this mixture

1/2 (or to taste) package of taco seasoning
1 4-oz can of chopped green chilies
1 package shredded taco cheese (I use the 4-cheese Mexican style cheese)

Pour the mixture onto the crust and bake for 30 minutes at 350 degrees.

Once the cheesecake has cooled, remove from springform pan and place in the refrigerator.

Remove from the refrigerator about 30 minutes before serving and spread with sour cream. Add chopped green onion, tomatoes, black olives to garnish (I chop them very fine). Serve with chips (I use Tostitos Gold since they are nice and sturdy).

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

    March 2005
    M T W T F S S
         
     123456
    78910111213
    14151617181920
    21222324252627
    28293031  
    • 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-04-18 22:00:43' 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