# Category Remains Muted after Category is available to Everyone

**URL:** https://meta.discourse.org/t/category-remains-muted-after-category-is-available-to-everyone/139963
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [January 28, 2020, 5:03pm UTC](https://meta.discourse.org/t/category-remains-muted-after-category-is-available-to-everyone/139963 "2020-01-28T17:03:58Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Craig\_Oates](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/craig_oates/32/166411_2.png) [@Craig\_Oates](https://meta.discourse.org/u/Craig_Oates)
#### Post date: [January 28, 2020, 5:03pm UTC](https://meta.discourse.org/t/category-remains-muted-after-category-is-available-to-everyone/139963/1 "2020-01-28T17:03:58Z")

</div>

Hi Support

We have a category that is for “sneak-peaks” so select customers are invited only. Those customers had their own Group and could see this category.

The “sneak-peak” has since matured, so we have removed the Group requirement and changed the permissions to see the category as Everone See/ Reply and only Admins to create.

However, users seem to have the same category as “muted” in preferences.

How can I view all users that currently have this category as muted, and how do I remove this for them?

Thanks in advance.

---

<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: [January 28, 2020, 7:00pm UTC](https://meta.discourse.org/t/category-remains-muted-after-category-is-available-to-everyone/139963/2 "2020-01-28T19:00:29Z")

</div>

> [@Craig\_Oates](#):
>
> How can I view all users that currently have this category as muted, and how do I remove this for them?

To unmute a category for all users, go to your site settings page and enter `default categories` into the search box. This will take you to all your default category notification settings. If the `sneak-peaks` category is listed in your `default categories muted` setting, remove it from that setting. When you save the setting, you will be asked if you “would you like to apply this change historically?” Selecting “Yes” will unmute the category for all users on your site.

If the `sneak-peaks` is not listed in your `default categories muted` setting, you can still unmute it for all users. First, add `sneak-peaks` to the `default categories muted` setting. Save the setting, but do not select the option to apply changes historically. Now, remove `sneak-peaks` from your `default categories muted` setting. Save the setting again, but this time _do_ select the option to apply changes historically. This will unmute the category for all users.

If you have the [Data Explorer plugin](https://meta.discourse.org/t/data-explorer-plugin/32566) installed on your site, you can view the category notification levels for all users in a category with the following query:

```sql
--[params]
-- string :category_name
-- string :notification_level

SELECT 
cu.user_id
FROM category_users cu
JOIN categories c
ON c.id = cu.category_id
WHERE c.name = :category_name
AND cu.notification_level = :notification_level

```

To run the query, you need to supply a category name and a notification level. The notification level is set with a number. To find all users who have muted a category, enter `0` into the notification level input. The available notification levels are `0` (muted), `2` (tracking), `3` (watching), `4` (watching first post.)

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [January 30, 2020, 4:55am UTC](https://meta.discourse.org/t/category-remains-muted-after-category-is-available-to-everyone/139963/3 "2020-01-30T04:55:28Z")

</div>

> [@Craig\_Oates](#):
>
> category that is for “sneak-peaks”

I hate to be _that guy_ but it should be “peeks” not “peaks” 😉
