# How can Data Explorer list invited user link url

**URL:** https://meta.discourse.org/t/how-can-data-explorer-list-invited-user-link-url/336861
**Category:** Support
**Tags:** data-explorer, invites
**Created:** [November 19, 2024, 3:00am UTC](https://meta.discourse.org/t/how-can-data-explorer-list-invited-user-link-url/336861 "2024-11-19T03:00:36Z")
**Posts on this page:** 1
**Showing post:** 3

<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: [November 19, 2024, 5:40pm UTC](https://meta.discourse.org/t/how-can-data-explorer-list-invited-user-link-url/336861/3 "2024-11-19T17:40:14Z")

</div>

I just noticed that you are asking about [data explorer](https://meta.discourse.org/t/32566?silent=true). It certainly is possible to get this data that way - try using the query below.

> [@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/8):
>
> 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/how-can-data-explorer-list-invited-user-link-url/336861)._