dgeri

I can’t even tell you how much you saved my life, koneu.

I changed:
" wp_posts.post_status = 'publish' AND ".
to
" $wpdb->posts.post_status = 'publish' AND ".

SAVED MY LIFE. THANK YOU!

Yes, it has. I’m usually a very persistant “googler” and don’t post questions because I KNOW there is an answer out there. But this was an extremely rare case.

PLEASE, IF YOU HAVE A DIRECT ANSWER, PLEASE POST.

p.s. I ended up using the Custom Permalinks plugin and had to manually change the permalink for ~200 pages.