# A badge granted when someone posts a reply in a single specified topic
**URL:** https://meta.discourse.org/t/a-badge-granted-when-someone-posts-a-reply-in-a-single-specified-topic/276673
**Category:** Data & reporting
**Tags:** sql-triggered-badge
**Created:** [November 12, 2014, 4:46am UTC](https://meta.discourse.org/t/a-badge-granted-when-someone-posts-a-reply-in-a-single-specified-topic/276673 "2014-11-12T04:46:40Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@downey](https://meta.discourse.org/u/downey)
#### Post date: [November 12, 2014, 4:46am UTC](https://meta.discourse.org/t/a-badge-granted-when-someone-posts-a-reply-in-a-single-specified-topic/276673/1 "2014-11-12T04:46:40Z")
Anyone want a (hopefully easy) challenge? A badge granted when someone posts a reply in a single specified topic. (i.e., A “Please introduce yourself here” topic.)
---
### Author:  [@riking](https://meta.discourse.org/u/riking)
#### Post date: [November 12, 2014, 6:11am UTC](https://meta.discourse.org/t/a-badge-granted-when-someone-posts-a-reply-in-a-single-specified-topic/276673/2 "2014-11-12T06:11:19Z")
```plaintext
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”.
---
### Author:  [@Frasertag](https://meta.discourse.org/u/Frasertag)
#### Post date: [March 27, 2017, 10:52pm UTC](https://meta.discourse.org/t/a-badge-granted-when-someone-posts-a-reply-in-a-single-specified-topic/276673/3 "2017-03-27T22:52:50Z")
Hi
I am seeking some help to do the following badge
I am trying to encourage users to post in a thread, I want them to post in this particular thread 10 times to earn this badge.
I was looking at
> [@riking](#):
>
> 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) )
Which works for a single post, I am just unsure how to expand this out to 10 posts minimum.
---
### Author:  [@Nigel\_Tatschner](https://meta.discourse.org/u/Nigel_Tatschner)
#### Post date: [June 14, 2017, 3:17pm UTC](https://meta.discourse.org/t/a-badge-granted-when-someone-posts-a-reply-in-a-single-specified-topic/276673/4 "2017-06-14T15:17:13Z")
Can’t seem to get this to work,
I’ve added;
> 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 = 172 AND
> (:backfill OR p.id IN (:post\_ids) )
But running the query isn’t bringing anyone back 😢
---
### Author:  [@riking](https://meta.discourse.org/u/riking)
#### Post date: [June 14, 2017, 10:02pm UTC](https://meta.discourse.org/t/a-badge-granted-when-someone-posts-a-reply-in-a-single-specified-topic/276673/5 "2017-06-14T22:02:01Z")
Did you change the topic ID? the 172
---
### Author:  [@Nigel\_Tatschner](https://meta.discourse.org/u/Nigel_Tatschner)
#### Post date: [June 15, 2017, 4:36am UTC](https://meta.discourse.org/t/a-badge-granted-when-someone-posts-a-reply-in-a-single-specified-topic/276673/6 "2017-06-15T04:36:59Z")
> [@riking](#):
>
> Did you change the topic ID? the 172
Yeah, I think 172 is the topic number.
---
### Author:  [@Timothy\_Vail](https://meta.discourse.org/u/Timothy_Vail)
#### Post date: [March 8, 2018, 3:15am UTC](https://meta.discourse.org/t/a-badge-granted-when-someone-posts-a-reply-in-a-single-specified-topic/276673/7 "2018-03-08T03:15:10Z")
> [@riking](#):
>
> 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) )
With the new SQL rules, how would you make a badge for introducing yourself on a topic?
---
### Author:  [@yanokwa](https://meta.discourse.org/u/yanokwa)
#### Post date: [June 19, 2018, 10:10pm UTC](https://meta.discourse.org/t/a-badge-granted-when-someone-posts-a-reply-in-a-single-specified-topic/276673/8 "2018-06-19T22:10:21Z")
I used this query…
```plaintext
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 = 6671 AND -- 6671 is the "Introduce yourself" topic
(:backfill OR p.id IN (:post_ids) )
```
With the following settings
