# Exporting group members emails as csv

**URL:** https://meta.discourse.org/t/exporting-group-members-emails-as-csv/43756
**Category:** Support
**Created:** [May 5, 2016, 9:11pm UTC](https://meta.discourse.org/t/exporting-group-members-emails-as-csv/43756 "2016-05-05T21:11:55Z")
**Posts on this page:** 1
**Showing post:** 8

<div class="post-metadata">

### Author: ![RGJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/rgj/32/523185_2.png) [@RGJ](https://meta.discourse.org/u/RGJ)
#### Post date: [January 2, 2019, 10:09pm UTC](https://meta.discourse.org/t/exporting-group-members-emails-as-csv/43756/8 "2019-01-02T22:09:30Z")

</div>

Since the email address was moved to the `user_emails` table, this query has changed.

The working query is now

```
-- [params]
-- group_id :group

WITH user_groups AS (
    SELECT gu.user_id
    FROM groups g
    JOIN group_users gu ON gu.group_id = g.id
    WHERE g.id = :group
    GROUP BY gu.user_id
)
SELECT ue.email
FROM users u
INNER JOIN user_emails ue ON u.id = ue.user_id
INNER JOIN user_groups ug ON u.id = ug.user_id
WHERE u.id > 0
ORDER BY u.id DESC

```

---

_[View the full topic](https://meta.discourse.org/t/exporting-group-members-emails-as-csv/43756)._