I did many updates to a WordPress site including a WP update to 5.0.3 for a client. After the updates, many posts were missing from the home landing page and other pages. Although the categories settings were still set as they were before the updates, when I removed/published and then replaced/published the categories the pages returned to their original places.
However, the client says that there are still many posts missing from the site. I looked into the wp_posts table and checked how many records.
SELECT count(*) FROM `wp_posts` WHERE 1 count(*) 371
However, the WordPress dashboard only shows 47 posts in total.
Is there a reason for this? Is there a way to regain those posts by fixing anything that may be wrong in the database? What other options do I have for restoring those posts?