# Get list of invited users

**URL:** https://meta.discourse.org/t/get-list-of-invited-users/64184
**Category:** Feature
**Tags:** invites
**Created:** [8 ביוני,‏ 2017,‏ 6:48pm UTC](https://meta.discourse.org/t/get-list-of-invited-users/64184 "2017-06-08T18:48:05Z")
**Posts on this page:** 1
**Showing post:** 6

<div class="post-metadata">

### Author: ![jimkleiber](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jimkleiber/32/121814_2.png) [@jimkleiber](https://meta.discourse.org/u/jimkleiber)
#### Post date: [2 בדצמבר,‏ 2023,‏ 6:13am UTC](https://meta.discourse.org/t/get-list-of-invited-users/64184/6 "2023-12-02T06:13:12Z")

</div>

Heads up, this one no longer seems to work, however, the one below works for me:

[https://meta.discourse.org/t/list-of-users-who-signed-up-via-invitations/224871/6](https://meta.discourse.org/t/list-of-users-who-signed-up-via-invitations/224871/6)

> [@Use data explorer to get a list of users who signed up via invitations](https://meta.discourse.org/t/use-data-explorer-to-get-a-list-of-users-who-signed-up-via-invitations/224871/6):
>
> My SQL skills are still a little fledgling, but try this one and see if I’ve got the look-ups working properly: 🙂
> 
> ```plaintext
> SELECT u1.username AS invitee, 
> u2.username AS inviter,
> iu.redeemed_at
> FROM invited_users iu
> JOIN invites i ON iu.invite_id = i.id
> JOIN users u1 ON iu.user_id = u1.id
> JOIN users u2 ON i.invited_by_id = u2.id
> WHERE iu.redeemed_at IS NOT NULL
> ORDER BY iu.redeemed_at DESC
> 
> ```

---

_[View the full topic](https://meta.discourse.org/t/get-list-of-invited-users/64184)._