# Verleen een badge op basis van het aantal bronzen/zilveren/gouden badges

**URL:** https://meta.discourse.org/t/grant-a-badge-based-on-number-of-bronze-silver-gold-badges/291980
**Category:** Data & reporting
**Tags:** sql-triggered-badge
**Created:** [17 januari 2024 om 17:53 UTC](https://meta.discourse.org/t/grant-a-badge-based-on-number-of-bronze-silver-gold-badges/291980 "2024-01-17T17:53:57Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![manuel](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/manuel/32/468169_2.png) [@manuel](https://meta.discourse.org/u/manuel)
#### Post date: [17 januari 2024 om 17:53 UTC](https://meta.discourse.org/t/grant-a-badge-based-on-number-of-bronze-silver-gold-badges/291980/1 "2024-01-17T17:53:57Z")

</div>

You can use this query for custom member-level badges:

 ![Screenshot 2024-01-17](https://global.discourse-cdn.com/meta/original/4X/b/4/9/b49f2e6688bb89682c25e7ab3474e8e003935247.png)

### SQL query

```plaintext
SELECT user_id, current_timestamp granted_at 
FROM user_badges  
JOIN badges
On user_badges.badge_id = badges.id
WHERE badges.badge_type_id = 3
GROUP BY user_id 
HAVING count(*) >= 15

```

### badge\_type\_ids

bronze: 3  
silver: 2  
gold: 1

Another option if you want to have more than 3 groups of target badges is to collect them in custom sections and then query for badge\_grouping\_id. E.g. here with 4 Pirate crew ranks:

 ![Pirate journey](https://global.discourse-cdn.com/meta/original/4X/0/e/d/0edcfde36d989dad96e7cb3c0d3561cb1b6814e5.png)

### SQL query

```plaintext
SELECT user_id, current_timestamp granted_at 
FROM user_badges  
JOIN badges
On user_badges.badge_id = badges.id
WHERE badges.badge_grouping_id = 1
GROUP BY user_id 
HAVING count(*) >= 10

```

### badge\_grouping\_ids

Getting Started: 1  
Community: 2  
Posting: 3  
Trust Level: 4  
Other: 5

And then count on for your custom sections..