# Unieke lijst van topicdeelnemers?

**URL:** https://meta.discourse.org/t/unique-list-of-topic-participants/329314
**Category:** Support
**Created:** [4 oktober 2024 om 07:50 UTC](https://meta.discourse.org/t/unique-list-of-topic-participants/329314 "2024-10-04T07:50:50Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Shauny](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/shauny/32/362012_2.png) [@Shauny](https://meta.discourse.org/u/Shauny)
#### Post date: [4 oktober 2024 om 07:50 UTC](https://meta.discourse.org/t/unique-list-of-topic-participants/329314/1 "2024-10-04T07:50:50Z")

</div>

What’s the best way to output an ordered list of unique topic participants?

This will be used for a prize draw, where simply replying to a topic is entry.

Thanks!

---

<div class="post-metadata">

### Author: ![RGJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/rgj/32/523185_2.png) [@RGJ](https://meta.discourse.org/u/RGJ)
#### Post date: [4 oktober 2024 om 08:03 UTC](https://meta.discourse.org/t/unique-list-of-topic-participants/329314/2 "2024-10-04T08:03:39Z")

</div>

Create a [data explorer](https://meta.discourse.org/t/32566?silent=true) query

```plaintext
-- [params]
-- integer :topic_id

SELECT p.user_id
FROM posts p
WHERE p.topic_id = :topic_id
GROUP BY p.user_id

```

---

<div class="post-metadata">

### Author: ![Shauny](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/shauny/32/362012_2.png) [@Shauny](https://meta.discourse.org/u/Shauny)
#### Post date: [4 oktober 2024 om 08:49 UTC](https://meta.discourse.org/t/unique-list-of-topic-participants/329314/3 "2024-10-04T08:49:31Z")

</div>

Perfect, thank you!

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [3 november 2024 om 08:50 UTC](https://meta.discourse.org/t/unique-list-of-topic-participants/329314/4 "2024-11-03T08:50:17Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.