# List of emails of users watching a specific category

**URL:** <https://meta.discourse.org/t/list-of-emails-of-users-watching-a-specific-category/198171>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [July 26, 2021, 9:19am 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:** 1

<div class="post-metadata">

**Author:** ![alehandrof](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alehandrof/32/119526_2.png) [@alehandrof](https://meta.discourse.org/u/alehandrof)\
**Post date:** [July 26, 2021, 9:19am UTC](https://meta.discourse.org/t/list-of-emails-of-users-watching-a-specific-category/198171/1 "2021-07-26T09:19:46Z")

</div>

I have a [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query that runs this:

```plaintext
SELECT * FROM category_users WHERE category_id = '10'

```

This gives me a result that looks like this:

 ![Screenshot 2021-07-26 at 12.15.57](https://global.discourse-cdn.com/meta/original/3X/1/7/17740f6c5578b996ad2710db09257ba000693f52.png)

How can I also display the users’ email in this output?

_(To forestall privacy discussions let me note the following: we use a private Discourse for paying members, who have individually given consent to our use of their personal information for the purposes of delivering services to them. We have systems that don’t interoperate in an automated fashion and we use emails to manually connect the users in two different systems.)_

---

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