# Consulta SQL para los últimos usuarios creados en los últimos 30 días

**URL:** <https://meta.discourse.org/t/sql-query-for-last-created-users-of-the-past-30-days/236209>\
**Category:** Product Support\
**Created:** [15 Agosto, 2022 14:52 UTC](https://meta.discourse.org/t/sql-query-for-last-created-users-of-the-past-30-days/236209 "2022-08-15T14:52:20Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![AquaL1te](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/aqual1te/32/201966_2.png) [@AquaL1te](https://meta.discourse.org/u/AquaL1te)\
**Post date:** [15 Agosto, 2022 15:19 UTC](https://meta.discourse.org/t/sql-query-for-last-created-users-of-the-past-30-days/236209/3 "2022-08-15T15:19:54Z")

</div>

Entendido.

```sql
SELECT username FROM users WHERE created_at >= CURRENT_TIMESTAMP - INTERVAL '30 days' AND staged = false

```

---

_[View the full topic](https://meta.discourse.org/t/sql-query-for-last-created-users-of-the-past-30-days/236209)._