# 데이터 탐색기를 사용하여 초대장을 통해 가입한 사용자 목록 가져오기

**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:** [4월 20, 2022, 8: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:** 6

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [4월 22, 2022, 8:47오전 UTC](https://meta.discourse.org/t/use-data-explorer-to-get-a-list-of-users-who-signed-up-via-invitations/224871/6 "2022-04-22T08:47:03Z")

</div>

제 SQL 실력은 아직 좀 초보 수준이지만, 이 쿼리를 실행해 보세요. 조회가 제대로 작동하는지 확인해 보려고 합니다. 🙂

```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/use-data-explorer-to-get-a-list-of-users-who-signed-up-via-invitations/224871)._