# 'Reply by email' badge

**URL:** https://meta.discourse.org/t/reply-by-email-badge/276733
**Category:** Data & reporting
**Tags:** sql-triggered-badge
**Created:** [2016年五月12日 15:13 UTC](https://meta.discourse.org/t/reply-by-email-badge/276733 "2016-05-12T15:13:42Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![lrossouw](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/lrossouw/32/121275_2.png) [@lrossouw](https://meta.discourse.org/u/lrossouw)
#### Post date: [2016年五月16日 11:15 UTC](https://meta.discourse.org/t/reply-by-email-badge/276733/3 "2016-05-16T11:15:05Z")

</div>

Here is a **Reply by Email** Badge:

```psql
select
    p.user_id
    ,min(p.created_at) granted_at
    ,min(p.id) post_id
from badge_posts p
where
    (:backfill or p.id IN (:post_ids) ) 
    and p.post_number >1
    and p.via_email=True
group by 
    p.user_id

```

 ![](https://global.discourse-cdn.com/meta/original/3X/9/d/9da5e4da37b8f8e1e8ad380ae19a265e97e7a826.png)

---

_[View the full topic](https://meta.discourse.org/t/reply-by-email-badge/276733)._