# Discourse Affiliate - Invite to community

**URL:** https://meta.discourse.org/t/discourse-affiliate-invite-to-community/337795
**Category:** Support
**Created:** [November 22, 2024, 6:11pm UTC](https://meta.discourse.org/t/discourse-affiliate-invite-to-community/337795 "2024-11-22T18:11:36Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![Moin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/moin/32/554653_2.png) [@Moin](https://meta.discourse.org/u/Moin)
#### Post date: [November 22, 2024, 6:37pm UTC](https://meta.discourse.org/t/discourse-affiliate-invite-to-community/337795/3 "2024-11-22T18:37:42Z")

</div>

You can use [data explorer](https://meta.discourse.org/t/32566?silent=true)

> [@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. 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/discourse-affiliate-invite-to-community/337795)._