# Jeito mais fácil de exportar uma lista de e-mails de usuários por ID ou nome de usuário?

**URL:** https://meta.discourse.org/t/export-a-list-of-user-emails-by-user-id/373768
**Category:** Data & reporting
**Created:** [10 Julho , 2025 16:35 UTC](https://meta.discourse.org/t/export-a-list-of-user-emails-by-user-id/373768 "2025-07-10T16:35:47Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![Kieran\_Berryman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/kieran_berryman/32/347853_2.png) [@Kieran\_Berryman](https://meta.discourse.org/u/Kieran_Berryman)
#### Post date: [10 Julho , 2025 18:27 UTC](https://meta.discourse.org/t/export-a-list-of-user-emails-by-user-id/373768/3 "2025-07-10T18:27:45Z")

</div>

Nem sabia disso. Resolveu meu problema imediatamente, muito obrigado!

A propósito, a consulta que sugeriu é

```plaintext
SELECT users.id AS user_id, user_emails.email
FROM users
LEFT JOIN user_emails ON users.id = user_emails.user_id AND user_emails.primary
WHERE users.id IN (/* list of user IDs here, e.g. 1,2,3 */)

```

---

_[View the full topic](https://meta.discourse.org/t/export-a-list-of-user-emails-by-user-id/373768)._