I don’t know where to find the schema. So, I have added the standard wp_posts table. When I search for post_author = 1 I still get “no results found”. If you need to see the schema, it’s the standard one as installed by WordPress. And there is a post_author with ID 1. An empty search of this table also produces “no results found”.