Unique list of topic participants?

Support
1

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!

2

Create a data explorer query

-- [params]
-- integer :topic_id

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

Perfect, thank you!

1 Like
4

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