# Users (In Specific Group) Last Seen Since N Days Ago

**URL:** https://meta.discourse.org/t/users-in-specific-group-last-seen-since-n-days-ago/275158
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [14 במאי,‏ 2019,‏ 2:50pm UTC](https://meta.discourse.org/t/users-in-specific-group-last-seen-since-n-days-ago/275158 "2019-05-14T14:50:00Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![SvenC56](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/svenc56/32/132235_2.png) [@SvenC56](https://meta.discourse.org/u/SvenC56)
#### Post date: [14 במאי,‏ 2019,‏ 2:50pm UTC](https://meta.discourse.org/t/users-in-specific-group-last-seen-since-n-days-ago/275158/1 "2019-05-14T14:50:00Z")

</div>

## Users (In Specific Group) Last Seen Since N Days Ago

```sql
-- [params] 
-- int :member_group 
-- int :days_since_last_activity 
SELECT u.id AS user_id, 
       Age(u.last_seen_at) AS last_seen, 
       g.id AS GROUP_ID 
FROM users u 
       join group_users gu 
         ON gu.user_id = u.id 
       join GROUPS g 
         ON g.id = gu.group_id 
WHERE Age(u.last_seen_at) >= ( :days_since_last_activity * '1 day' :: interval ) 
       AND g.id = :member_group 
ORDER BY u.last_seen_at

```