# Как можно вывести список пользователей, которых система скоро удалит?

**URL:** <https://meta.discourse.org/t/how-might-i-list-users-that-the-system-will-soon-delete/266031>\
**Category:** Product Support\
**Created:** [24.Май.2023 09:48:38 UTC](https://meta.discourse.org/t/how-might-i-list-users-that-the-system-will-soon-delete/266031 "2023-05-24T09:48:38Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Canapin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/canapin/32/119591_2.png) [@Canapin](https://meta.discourse.org/u/Canapin)\
**Post date:** [24.Май.2023 10:08:07 UTC](https://meta.discourse.org/t/how-might-i-list-users-that-the-system-will-soon-delete/266031/2 "2023-05-24T10:08:07Z")

</div>

Привет, Amicable!

В [Data Explorer](https://meta.discourse.org/t/32566?silent=true) запрос будет выглядеть так:

```sql
WITH posts_by_user AS (
    SELECT COUNT(*) AS posts, user_id
    FROM posts
    GROUP BY user_id
)
SELECT 
    u.id,
    u.username_lower AS "username",
    u.created_at,
    u.last_seen_at
FROM users u
LEFT JOIN posts_by_user pbu ON pbu.user_id = u.id
WHERE u.active = true AND u.trust_level = 0
AND posts IS NULL
ORDER BY u.id

```

---

_[View the full topic](https://meta.discourse.org/t/how-might-i-list-users-that-the-system-will-soon-delete/266031)._