Error: SELECT SQL_CALC_FOUND_ROWS

This wouldn’t be caused by a change in the database. What the error refers to is this:

SELECT SQL_CALC_FOUND_ROWS wp_posts.id
FROM   wp_posts
WHERE  1 = 1
       AND 0
GROUP  BY wp_posts.id
ORDER  BY wp_postmeta.meta_value + 0 DESC,
          wp_posts.post_date DESC
LIMIT  0, 10 

Your code only includes data from the wp_posts table (second line above) but is trying to ORDER BY data from the wp_postmeta table (sixth line). You can’t do that. I doubt this is coming from WordPress Core, so a plugin or your theme is hooking a callback into one of the WP_Query hooks– my guess is the posts_orderby filter. Something about that filter is broken and it is adding that wp_postmeta.meta_value bit indiscriminantly.