# Lista de e-mails de usuários que assistem a uma categoria específica

**URL:** <https://meta.discourse.org/t/list-of-emails-of-users-watching-a-specific-category/198171>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [26 Julho , 2021 09:19 UTC](https://meta.discourse.org/t/list-of-emails-of-users-watching-a-specific-category/198171 "2021-07-26T09:19:46Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![simon](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/simon/32/339122_2.png) [@simon](https://meta.discourse.org/u/simon)\
**Post date:** [26 Julho , 2021 17:20 UTC](https://meta.discourse.org/t/list-of-emails-of-users-watching-a-specific-category/198171/2 "2021-07-26T17:20:30Z")

</div>

> [@alehandrof](#):
>
> Como posso exibir também o e-mail dos usuários nesta saída?

Você precisa fazer um JOIN na tabela `user_emails` com base no `user_id` da tabela `category_users`. Tente algo assim:

```sql
SELECT
cu.*,
ue.email
FROM category_users cu
JOIN user_emails ue
ON ue.user_id = cu.user_id
WHERE category_id = '10'
AND ue.primary = true

```

---

_[View the full topic](https://meta.discourse.org/t/list-of-emails-of-users-watching-a-specific-category/198171)._