# SQL Querying in Badges
**URL:** https://meta.discourse.org/t/sql-querying-in-badges/36336
**Category:** Data & reporting
**Tags:** sql-triggered-badge
**Created:** [December 4, 2015, 7:56pm UTC](https://meta.discourse.org/t/sql-querying-in-badges/36336 "2015-12-04T19:56:48Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@ivanrlio](https://meta.discourse.org/u/ivanrlio)
#### Post date: [December 4, 2015, 7:56pm UTC](https://meta.discourse.org/t/sql-querying-in-badges/36336/1 "2015-12-04T19:56:48Z")
Hi guys,
So I’m extremely new to Discourse and I think I’ve just successfully written my first badge that assigns a badge to a user if they have received 5-9 likes. It is as follows:
```
SELECT user_id, users.username username, likes_received, current_timestamp granted_at
FROM user_stats JOIN users ON (user_stats.user_id = users.id)
WHERE likes_received BETWEEN 5 AND 9
AND (:backfill OR users.id IN (:user_ids) )
```
When I click ‘preview granted badges’, it shows the 8 users that have fulfilled this requirement. Does this mean that when the update occurs, this badge will be assigned automatically?
Thanks!
---
### Author:  [@sam](https://meta.discourse.org/u/sam)
#### Post date: [December 4, 2015, 9:20pm UTC](https://meta.discourse.org/t/sql-querying-in-badges/36336/2 "2015-12-04T21:20:21Z")
Yes, as soon as the daily grant runs they will get badges
---
### Author:  [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [June 8, 2024, 12:45pm UTC](https://meta.discourse.org/t/sql-querying-in-badges/36336/3 "2024-06-08T12:45:59Z")
This topic was automatically closed after 3108 days. New replies are no longer allowed.