# An extra badge based on already granted badges number?

**URL:** https://meta.discourse.org/t/an-extra-badge-based-on-already-granted-badges-number/178425
**Category:** Data & reporting
**Tags:** sql-triggered-badge
**Created:** [February 4, 2021, 4:58pm UTC](https://meta.discourse.org/t/an-extra-badge-based-on-already-granted-badges-number/178425 "2021-02-04T16:58:02Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![cosdesign](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cosdesign/32/208585_2.png) [@cosdesign](https://meta.discourse.org/u/cosdesign)
#### Post date: [February 4, 2021, 4:58pm UTC](https://meta.discourse.org/t/an-extra-badge-based-on-already-granted-badges-number/178425/1 "2021-02-04T16:58:02Z")

</div>

Hi. I was wondering if we could create a special badge for users already being granted with 30+ badges ( excluding system and discobot ).  
So far this is [the closest query](https://meta.discourse.org/t/user-badge-counts-with-badge-name-filter/168098/3) I’ve found but is not for this use.

---

<div class="post-metadata">

### Author: ![cosdesign](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cosdesign/32/208585_2.png) [@cosdesign](https://meta.discourse.org/u/cosdesign)
#### Post date: [May 23, 2023, 1:48pm UTC](https://meta.discourse.org/t/an-extra-badge-based-on-already-granted-badges-number/178425/2 "2023-05-23T13:48:50Z")

</div>

I finally succeeded, (my very first created badge 😄 ) if anyone is interested here it is

```
SELECT user_id, current_timestamp granted_at 
FROM user_badges  
GROUP BY user_id 
HAVING count(*) >= 30

```

 ![image](https://global.discourse-cdn.com/meta/original/3X/0/a/0ae8da3e19fda5dcee632c1aa26fce07f656ffca.png)

 ![image](https://global.discourse-cdn.com/meta/original/3X/8/1/8171c6f619f5ab8972f38ba54e5fcd88d1325595.png)

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [May 23, 2023, 1:50pm UTC](https://meta.discourse.org/t/an-extra-badge-based-on-already-granted-badges-number/178425/3 "2023-05-23T13:50:17Z")

</div>