This data explorer query should reveal all hidden (but not deleted) posts:
SELECT id, user_id, topic_id, post_number
FROM posts p
WHERE p.hidden = true AND p.deleted_at IS NULL
From there you can unhide the posts found.
1 Like