# Gebruik data explorer om een lijst te krijgen van gebruikers die zich via uitnodigingen hebben aangemeld

**URL:** https://meta.discourse.org/t/use-data-explorer-to-get-a-list-of-users-who-signed-up-via-invitations/224871
**Category:** Data & reporting
**Tags:** data-explorer, invites
**Created:** [20 april 2022 om 20:47 UTC](https://meta.discourse.org/t/use-data-explorer-to-get-a-list-of-users-who-signed-up-via-invitations/224871 "2022-04-20T20:47:27Z")
**Posts on this page:** 1
**Showing post:** 8

<div class="post-metadata">

### Author: ![tobiaseigen](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tobiaseigen/32/539204_2.png) [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)
#### Post date: [19 november 2024 om 17:39 UTC](https://meta.discourse.org/t/use-data-explorer-to-get-a-list-of-users-who-signed-up-via-invitations/224871/8 "2024-11-19T17:39:02Z")

</div>

I was able to update this [data explorer](https://meta.discourse.org/t/32566?silent=true) query to include the `invite_key` used by the user to join the site.

```plaintext
SELECT u1.username AS invitee, 
       u2.username AS inviter,
       i.invite_key,
       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/use-data-explorer-to-get-a-list-of-users-who-signed-up-via-invitations/224871)._