# Was ist SQL Badge Query für eingeladene 8+ Personen?

**URL:** <https://meta.discourse.org/t/what-is-sql-badge-query-for-invited-25-people/83451>\
**Category:** Support\
**Created:** [21. März 2018 um 03:22 UTC](https://meta.discourse.org/t/what-is-sql-badge-query-for-invited-25-people/83451 "2018-03-21T03:22:44Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![iidbae](https://avatars.discourse-cdn.com/v4/letter/i/a183cd/32.png) [@iidbae](https://meta.discourse.org/u/iidbae)\
**Post date:** [21. März 2018 um 23:58 UTC](https://meta.discourse.org/t/what-is-sql-badge-query-for-invited-25-people/83451/3 "2018-03-21T23:58:56Z")

</div>

Hi Andrew, thank you for your simple and easy explanation.  
I am really appreciate that.

I just want to confirm if the below query is right:

```plaintext
      SELECT u.id user_id, current_timestamp granted_at
      FROM users u
      WHERE u.id IN (
        SELECT invited_by_id
        FROM invites i
        JOIN users u2 ON u2.id = i.user_id
        WHERE i.deleted_at IS NULL AND u2.active AND u2.trust_level >= 2 AND u2.silenced_till IS NULL
        GROUP BY invited_by_id
        HAVING COUNT(*) >= 25
      ) AND u.active AND u.silenced_till IS NULL AND u.id > 0 AND
        (:backfill OR u.id IN (:user_ids) )

```

So the query will automatically give a badge to a member who has successful invite 25 people when the TL is 2. Am I right?

Thank you very much. 🙏

---

_[View the full topic](https://meta.discourse.org/t/what-is-sql-badge-query-for-invited-25-people/83451)._