# Who closed the poll?

**URL:** https://meta.discourse.org/t/who-closed-the-poll/405495
**Category:** Support
**Tags:** polls
**Created:** [June 17, 2026, 10:18am UTC](https://meta.discourse.org/t/who-closed-the-poll/405495 "2026-06-17T10:18:06Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![asa](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/asa/32/184869_2.png) [@asa](https://meta.discourse.org/u/asa)
#### Post date: [June 17, 2026, 12:14pm UTC](https://meta.discourse.org/t/who-closed-the-poll/405495/3 "2026-06-17T12:14:48Z")

</div>

If you using the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) you can try with this (SQL)

```plaintext
SELECT 
    pr.created_at AS "Closed At",
    p.topic_id AS "Topic ID",
    p.post_number AS "Post Number",
    u.username AS "Closed By",
    pr.modifications AS "Modifications"
FROM post_revisions pr
JOIN posts p ON p.id = pr.post_id
JOIN users u ON u.id = pr.user_id
WHERE pr.modifications LIKE '%status=closed%'
ORDER BY pr.created_at DESC

```

---

_[View the full topic](https://meta.discourse.org/t/who-closed-the-poll/405495)._