# Пользователи с первым сообщением в указанный период

**URL:** https://meta.discourse.org/t/users-with-first-post-within-period/275155
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [16.Август.2019 19:53:48 UTC](https://meta.discourse.org/t/users-with-first-post-within-period/275155 "2019-08-16T19:53:48Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![tshenry](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tshenry/32/119495_2.png) [@tshenry](https://meta.discourse.org/u/tshenry)
#### Post date: [18.Сентябрь.2019 20:22:46 UTC](https://meta.discourse.org/t/users-with-first-post-within-period/275155/4 "2019-09-18T20:22:46Z")

</div>

Подойдет ли что-то вроде этого?

```sql
-- [params]
-- date :start_date
-- date :end_date

SELECT u.id AS user_id, p.id AS post_id, p.created_at
FROM users u
JOIN user_stats us
ON u.id = us.user_id
JOIN posts p
ON u.id = p.user_id
WHERE p.created_at = us.first_post_created_at
AND us.first_post_created_at BETWEEN :start_date::date AND :end_date::date

```

---

_[View the full topic](https://meta.discourse.org/t/users-with-first-post-within-period/275155)._