# Активность чата в данных раздела «Здоровье сообщества / Отчёты»

**URL:** <https://meta.discourse.org/t/chat-activity-in-community-health-reports-data/259301>\
**Category:** Feature\
**Tags:** chat, dashboard-reports\
**Created:** [24.Март.2023 16:06:49 UTC](https://meta.discourse.org/t/chat-activity-in-community-health-reports-data/259301 "2023-03-24T16:06:49Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![janbolmeson](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/janbolmeson/32/192162_2.png) [@janbolmeson](https://meta.discourse.org/u/janbolmeson)\
**Post date:** [31.Июль.2023 22:56:02 UTC](https://meta.discourse.org/t/chat-activity-in-community-health-reports-data/259301/10 "2023-07-31T22:56:02Z")

</div>

Мы используем этот запрос в нашем сообществе, чтобы увидеть самых активных пользователей за последние 30 дней.

```plaintext
SELECT 
u.username,
COUNT(c.*) AS cnt
FROM 
chat_messages AS c
LEFT JOIN users AS u ON c.user_id = u.id
WHERE c.created_at >= CURRENT_TIMESTAMP - INTERVAL '30 days'
GROUP BY u.username
ORDER BY cnt DESC

```

---

_[View the full topic](https://meta.discourse.org/t/chat-activity-in-community-health-reports-data/259301)._