# Badge for enabling mailing list mode

**URL:** https://meta.discourse.org/t/badge-for-enabling-mailing-list-mode/276729
**Category:** Data & reporting
**Tags:** mailing-list, sql-triggered-badge
**Created:** [August 24, 2015, 2:02pm UTC](https://meta.discourse.org/t/badge-for-enabling-mailing-list-mode/276729 "2015-08-24T14:02:56Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![fefrei](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/fefrei/32/119538_2.png) [@fefrei](https://meta.discourse.org/u/fefrei)
#### Post date: [August 24, 2015, 2:02pm UTC](https://meta.discourse.org/t/badge-for-enabling-mailing-list-mode/276729/1 "2015-08-24T14:02:56Z")

</div>

This badge detects whether a user has enabled mailing list mode:

```sql
SELECT u.id user_id, current_timestamp granted_at
FROM users u
WHERE mailing_list_mode = true
AND (:backfill OR u.id IN (:user_ids))

```

It should trigger when a user is created or edited.

---

<div class="post-metadata">

### Author: ![nathank](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/nathank/32/290039_2.png) [@nathank](https://meta.discourse.org/u/nathank)
#### Post date: [May 8, 2021, 2:53am UTC](https://meta.discourse.org/t/badge-for-enabling-mailing-list-mode/276729/2 "2021-05-08T02:53:57Z")

</div>

> [@fefrei](#):
>
> This badge detects whether a user has enabled mailing list mode:

That query is broken; here is an updated version for getting those on Mailing List Mode:

```plaintext
SELECT user_id, current_timestamp granted_at
FROM user_options
WHERE mailing_list_mode = true
AND (:backfill OR user_id IN (:user_ids))

```