The Author Page and WP Posts Shows 0 Entries with Plugin Enabled!

I inherited a weird bug to troubleshoot. — We have an author with over 3k posts.

**With the co-authors plugin enabled:**

- The author page and WP Posts pages show the author has no entries
- The author field on their post is empty

**With the co-authors plugin disabled:**
- The author page and WP Posts pages show all 3k entries
- The author field on their posts shows their name just fine

**Here is what I've tried:**
1. Deleted the user and re-assigned to a new user using WP CLI tools.
2. Checked: post_author field in the wp-posts table shows the correct author ID.
3. No traces of 'cap-xxx" in wp-postmeta for any entries.
4. No Guest Author with this email or display name

**Here is what I think could help me:**
- What are the possible keywords I can search for in the database to check the post vs. author relation? And what database tables do co-authors use to store relations?
- Any function recommendation to re-assign and correct the relation in the database? (I already tried deleting the user and re-assigning. So it suggests I need to look for a relation by the post ID. But, so far, no luck there either).

Again, disabling the co-authors plugin fixes the issue.

WP: Version 6.0.2 (VIP hosted)
Co-Authors Plus: Version 3.5.2

Start by reproducing the discrepancy with Co-Authors Plus enabled and inspect the reported wp_posts post_author, wp_postmeta, post IDs, and WP CLI reassignment results. Trace how the plugin resolves author and post relationships; done means identifying why the enabled plugin hides valid entries and documenting or fixing the affected relation handling.

Written by the indexing model from the issue text.