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

**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:** 4

<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월 21, 2022, 4:25오후 UTC](https://meta.discourse.org/t/use-data-explorer-to-get-a-list-of-users-who-signed-up-via-invitations/224871/4 "2022-04-21T16:25:41Z")

</div>

초대 테이블이 어딘가에서 분리된 것 같습니다. 최신 정보에 대해 이 쿼리를 시도해 보세요:

```plaintext
SELECT iu.user_id, 
       i.invited_by_id AS invited_by_user_id, 
       iu.redeemed_at AS reltime$time 
FROM invited_users iu
JOIN invites i ON iu.invite_id = i.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)._