This is what I get:
SELECT DISTINCT * FROM wp_2posts WHERE 1=1 AND post_date_gmt <= '2006-05-04 10:07:59' AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') AND post_status != "attachment" GROUP BY wp_2posts.ID ORDER BY post_date DESC LIMIT 0, 10
Basically, I just installed a new blog onto a subdomain and created a new database for it. Everything was smooth for a while and all I did was add a few Pages to it. Shortly thereafter it gave me that error and posts didn't show, as well as many aesthetic errors.
I re-installed it to the same database as another WP blog with a different table name and it did the same thing, and now my other blog doesn't show any posts.
I'm not sure what the problem is... any ideas what I could have done to make that happen or any fixes anyone knows of? Any help would be greatly appreciated. :D