# 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:** [October 3, 2018, 1:39pm 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:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![anon62249317](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@anon62249317](https://meta.discourse.org/u/anon62249317)
#### Post date: [October 3, 2018, 1:39pm UTC](https://meta.discourse.org/t/how-can-i-give-a-badge-just-to-the-early-birds/98631/1 "2018-10-03T13:39:24Z")

</div>

Hello,

I want to give a badge to the early birds users, is there a way to create a badge and just give it to the first 100 users or something like that?

---

<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: [October 3, 2018, 1:43pm 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)`

---

<div class="post-metadata">

### Author: ![cjk77](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cjk77/32/151779_2.png) [@cjk77](https://meta.discourse.org/u/cjk77)
#### Post date: [October 4, 2018, 4:45am UTC](https://meta.discourse.org/t/how-can-i-give-a-badge-just-to-the-early-birds/98631/3 "2018-10-04T04:45:24Z")

</div>

For our forum, we awarded an “Early Adopter” badge to users who joined before a certain date (1 month from the day we publicly announced):

```plaintext
SELECT id AS user_id, created_at AS granted_at, NULL AS post_id
FROM users WHERE created_at < '20180213'

```

---

<div class="post-metadata">

### Author: ![Johani](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/johani/32/176920_2.png) [@Johani](https://meta.discourse.org/u/Johani)
#### Post date: [June 19, 2021, 7:11am UTC](https://meta.discourse.org/t/how-can-i-give-a-badge-just-to-the-early-birds/98631/5 "2021-06-19T07:11:19Z")

</div>