# List who muted / ignored users

**URL:** https://meta.discourse.org/t/list-who-muted-ignored-users/206857
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [October 23, 2021, 10:22am UTC](https://meta.discourse.org/t/list-who-muted-ignored-users/206857 "2021-10-23T10:22:26Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![ondrej](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ondrej/32/198804_2.png) [@ondrej](https://meta.discourse.org/u/ondrej)
#### Post date: [October 23, 2021, 10:22am UTC](https://meta.discourse.org/t/list-who-muted-ignored-users/206857/1 "2021-10-23T10:22:26Z")

</div>

Hi lovely people! :smiley:

Using the [data explorer](https://meta.discourse.org/t/32566?silent=true) is it possible to display in a table of what user(s) have muted and ignored and by whom?

If anyone could lend a hand I’d be really grateful :heart:  
Thanks

---

<div class="post-metadata">

### Author: ![Simsnet](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/simsnet/32/72855_2.png) [@Simsnet](https://meta.discourse.org/u/Simsnet)
#### Post date: [October 24, 2021, 7:54am UTC](https://meta.discourse.org/t/list-who-muted-ignored-users/206857/2 "2021-10-24T07:54:00Z")

</div>

Haven’t seen this as a feature before, and I doubt it will be added or it could jeopardize safe privacy practices.

---

<div class="post-metadata">

### Author: ![merefield](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/merefield/32/176214_2.png) [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [October 24, 2021, 9:18am UTC](https://meta.discourse.org/t/list-who-muted-ignored-users/206857/3 "2021-10-24T09:18:42Z")

</div>

Try:

```sql
SELECT id AS user_id, muted_users, ignored_users
FROM (
  SELECT u.id,
    ARRAY_AGG(m.muted_user_id)
      FILTER (WHERE m.muted_user_id IS NOT NULL) AS muted_users,
    ARRAY_AGG(i.ignored_user_id)
      FILTER (WHERE i.ignored_user_id IS NOT NULL) AS ignored_users
  FROM users u
  LEFT JOIN ignored_users i ON u.id = i.user_id
  LEFT JOIN muted_users m ON u.id = m.user_id
  GROUP BY u.id
) data
WHERE (muted_users IS NOT NULL OR ignored_users IS NOT NULL)

```

OR, if you want a list of usernames instead of ids, try:

```sql
SELECT id AS user_id, muted_users, ignored_users FROM (
  SELECT u.id,
    ARRAY_AGG(muteds.username)
      FILTER (WHERE muteds.username IS NOT NULL) AS muted_users,
    ARRAY_AGG(ignores.username)
      FILTER (WHERE ignores.username IS NOT NULL) AS ignored_users
  FROM users u
  LEFT JOIN (
    SELECT i.user_id AS id, u1.username
    FROM users u1
    INNER JOIN ignored_users i ON u1.id = i.ignored_user_id) ignores
  ON u.id = ignores.id
  LEFT JOIN (
    SELECT m.user_id AS id, u1.username
    FROM users u1
    INNER JOIN muted_users m ON u1.id = m.muted_user_id) muteds
  ON u.id = muteds.id
  GROUP BY u.id
) data
WHERE (muted_users IS NOT NULL OR ignored_users IS NOT NULL)

```

---

<div class="post-metadata">

### Author: ![ondrej](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ondrej/32/198804_2.png) [@ondrej](https://meta.discourse.org/u/ondrej)
#### Post date: [October 24, 2021, 10:12am UTC](https://meta.discourse.org/t/list-who-muted-ignored-users/206857/4 "2021-10-24T10:12:05Z")

</div>

Thanks Robert for creating the query! The username one works better for us.  
Have a great day

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [November 23, 2021, 10:12am UTC](https://meta.discourse.org/t/list-who-muted-ignored-users/206857/5 "2021-11-23T10:12:19Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.