# Unexpected flags showing up... False flags!

**URL:** <https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857>\
**Category:** Bug\
**Created:** [September 18, 2019, 2:16am UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857 "2019-09-18T02:16:54Z")\
**Posts on this page:** 1\
**Showing post:** 36

<div class="post-metadata">

**Author:** ![jomaxro](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jomaxro/32/126216_2.png) [@jomaxro](https://meta.discourse.org/u/jomaxro)\
**Post date:** [September 18, 2019, 3:35pm UTC](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857/36 "2019-09-18T15:35:01Z")

</div>

This [data explorer](https://meta.discourse.org/t/32566?silent=true) query should reveal all hidden (but not deleted) posts:

```plaintext
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.

---

_[View the full topic](https://meta.discourse.org/t/unexpected-flags-showing-up-false-flags/128857)._