# Data Explorer query for number of users using mailing list mode?

**URL:** https://meta.discourse.org/t/data-explorer-query-for-number-of-users-using-mailing-list-mode/183146
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [March 13, 2021, 8:13pm UTC](https://meta.discourse.org/t/data-explorer-query-for-number-of-users-using-mailing-list-mode/183146 "2021-03-13T20:13:09Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Jonathan5](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jonathan5/32/197134_2.png) [@Jonathan5](https://meta.discourse.org/u/Jonathan5)
#### Post date: [March 13, 2021, 8:13pm UTC](https://meta.discourse.org/t/data-explorer-query-for-number-of-users-using-mailing-list-mode/183146/1 "2021-03-13T20:13:09Z")

</div>

After the recent upgrade, I’ve re-enabled mailing list mode, but wonder how many people are using it. How could I find this out? Thanks in anticipation.

---

<div class="post-metadata">

### Author: ![Mark\_Schmucker](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mark_schmucker/32/124810_2.png) [@Mark\_Schmucker](https://meta.discourse.org/u/Mark_Schmucker)
#### Post date: [March 14, 2021, 4:14am UTC](https://meta.discourse.org/t/data-explorer-query-for-number-of-users-using-mailing-list-mode/183146/2 "2021-03-14T04:14:58Z")

</div>

```
select
count(*) from user_options
where mailing_list_mode = TRUE

```

---

<div class="post-metadata">

### Author: ![Jonathan5](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jonathan5/32/197134_2.png) [@Jonathan5](https://meta.discourse.org/u/Jonathan5)
#### Post date: [March 14, 2021, 1:19pm UTC](https://meta.discourse.org/t/data-explorer-query-for-number-of-users-using-mailing-list-mode/183146/3 "2021-03-14T13:19:16Z")

</div>

Thank you very much. That worked perfectly.

---

<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: [April 13, 2021, 1:19pm UTC](https://meta.discourse.org/t/data-explorer-query-for-number-of-users-using-mailing-list-mode/183146/4 "2021-04-13T13:19:39Z")

</div>

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