# Run report of digest Unsubscribes

**URL:** https://meta.discourse.org/t/run-report-of-digest-unsubscribes/64678
**Category:** Data & reporting
**Tags:** sql-query, activity-summary
**Created:** [Junho 17, 2017, 5:59pm UTC](https://meta.discourse.org/t/run-report-of-digest-unsubscribes/64678 "2017-06-17T17:59:24Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![hutchinsfairy](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/hutchinsfairy/32/103475_2.png) [@hutchinsfairy](https://meta.discourse.org/u/hutchinsfairy)
#### Post date: [Junho 19, 2017, 1:46pm UTC](https://meta.discourse.org/t/run-report-of-digest-unsubscribes/64678/3 "2017-06-19T13:46:16Z")

</div>

If you’re doing this often then you could install the [Data Explorer plugin](https://meta.discourse.org/t/data-explorer-plugin/32566) and use query:

```
SELECT u.ID "User ID" 
       ,u.USERNAME "Username" 
       ,u.NAME "Name" 
       ,CASE uo.EXTERNAL_LINKS_IN_NEW_TAB 
          WHEN 't' THEN 'True' 
          WHEN 'f' THEN 'False' 
          ELSE 'Not set' 
        END "External links?"
        ,CASE uo.mailing_list_mode 
          WHEN 't' THEN 'True' 
          WHEN 'f' THEN 'False' 
          ELSE 'Not set' 
        END "Mailing List Mode?"
        ,CASE uo.email_digests 
          WHEN 't' THEN 'True' 
          WHEN 'f' THEN 'False' 
          ELSE 'Not set' 
        END "Email Digests?"
        ,digest_after_minutes/60 || ' Hours' "Digest Every"
FROM USERS u 
       LEFT OUTER JOIN USER_OPTIONS uo 
                    ON u.ID = uo.USER_ID 
WHERE uo.email_digests = 'f' 
   AND u.ID <> -1

```

---

_[View the full topic](https://meta.discourse.org/t/run-report-of-digest-unsubscribes/64678)._