I have created a custom post type. Sometime during the last few days, posts are no longer visible in the list, however it still shows the total number of posts.
See here it shows all post(18), published post (13), but it only shows one post in list.
Can you repair database tables and check below solution it can be REGEX issue :
translations.php
line 726
Change this: $pattern = '/LIMIT\s*(\d+)((\s*,?\s*)(\d+)*)(;{0,1})$/is';
to this: $pattern = '/LIMIT\s*(\d+)((\s*,?\s*)(\d+)*);{0,1}$/is';
You can see it on : https://wordpress.stackexchange.com/questions/51134/dashboard-says-no-posts-found-even-though-there-are-some-posts