# Batch unhide posts

**URL:** <https://meta.discourse.org/t/batch-unhide-posts/27716>\
**Category:** Support\
**Created:** [17. April 2015 um 22:02 UTC](https://meta.discourse.org/t/batch-unhide-posts/27716 "2015-04-17T22:02:46Z")\
**Posts on this page:** 1\
**Showing post:** 14

<div class="post-metadata">

**Author:** ![NomNuggetNom](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/nomnuggetnom/32/122685_2.png) [@NomNuggetNom](https://meta.discourse.org/u/NomNuggetNom)\
**Post date:** [19. April 2015 um 01:55 UTC](https://meta.discourse.org/t/batch-unhide-posts/27716/14 "2015-04-19T01:55:37Z")

</div>

Yup. That’s what we did. Another admin did it because he misunderstood what it did.

@riking How about unlisting topics? Here’s my guess:

```plaintext
ActiveRecord::Base.exec_sql("UPDATE topics
SET hidden = false, hidden_reason_id = NULL, hidden_at = NULL
WHERE user_id = ?", User.find_by_username("fthzoob").id)

```

---

_[View the full topic](https://meta.discourse.org/t/batch-unhide-posts/27716)._