# יצא רשימה של אנשים שענו לנושא מסוים

**URL:** https://meta.discourse.org/t/export-a-list-of-people-who-replied-to-a-specific-topic/68756
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [25 באוגוסט,‏ 2017,‏ 8:15am UTC](https://meta.discourse.org/t/export-a-list-of-people-who-replied-to-a-specific-topic/68756 "2017-08-25T08:15:39Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![dax](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/dax/32/244677_2.png) [@dax](https://meta.discourse.org/u/dax)
#### Post date: [25 באוגוסט,‏ 2017,‏ 9:44am UTC](https://meta.discourse.org/t/export-a-list-of-people-who-replied-to-a-specific-topic/68756/4 "2017-08-25T09:44:48Z")

</div>

There is a badge query you can modify to make it work with [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin

> [@A badge granted when someone posts a reply in a single specified topic](https://meta.discourse.org/t/a-badge-granted-when-someone-posts-a-reply-in-a-single-specified-topic/276673/2):
>
> SELECT DISTINCT ON (p.user\_id) p.user\_id, p.id post\_id, p.created\_at granted\_at FROM badge\_posts p WHERE p.topic\_id = 32 AND -- 32 is the "please introduce yourself" topic (:backfill OR p.id IN (:post\_ids) ) Triggered on “edit/create a post”.

---

_[View the full topic](https://meta.discourse.org/t/export-a-list-of-people-who-replied-to-a-specific-topic/68756)._