# How can I give a badge just to the early birds?

**URL:** https://meta.discourse.org/t/how-can-i-give-a-badge-just-to-the-early-birds/98631
**Category:** Support
**Created:** [03.Октябрь.2018 13:39:24 UTC](https://meta.discourse.org/t/how-can-i-give-a-badge-just-to-the-early-birds/98631 "2018-10-03T13:39:24Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![awesomerobot](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/awesomerobot/32/142900_2.png) [@awesomerobot](https://meta.discourse.org/u/awesomerobot)
#### Post date: [03.Октябрь.2018 13:43:48 UTC](https://meta.discourse.org/t/how-can-i-give-a-badge-just-to-the-early-birds/98631/2 "2018-10-03T13:43:48Z")

</div>

There’s a badge query for exactly that in this post

> [@Some common badge queries](https://meta.discourse.org/t/some-common-badge-queries/31859/1):
>
> - Grant a badge to the first 100 users of the forum
> 
> ```plaintext
> SELECT id AS user_id, created_at AS granted_at, NULL AS post_id
> FROM users WHERE id > 0
> ORDER BY created_at ASC LIMIT 100
> 
> ```

You’d add it under `Admin > Badges > New > Badge Query (SQL)`

---

_[View the full topic](https://meta.discourse.org/t/how-can-i-give-a-badge-just-to-the-early-birds/98631)._