# Last 7 days of topics

**URL:** <https://meta.discourse.org/t/last-7-days-of-topics/85103>\
**Category:** Product Support\
**Created:** [April 11, 2018, 6:52pm UTC](https://meta.discourse.org/t/last-7-days-of-topics/85103 "2018-04-11T18:52:42Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![SidV](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sidv/32/119460_2.png) [@SidV](https://meta.discourse.org/u/SidV)\
**Post date:** [April 12, 2018, 5:42pm UTC](https://meta.discourse.org/t/last-7-days-of-topics/85103/4 "2018-04-12T17:42:09Z")

</div>

Did you create one?

If not, check this query:

```sql
--[params]
--string :interval = 1 week
--int :limit
SELECT id, title, created_at as posted
FROM topics
WHERE age(created_at) < interval :interval
AND archetype != 'private_message'
GROUP BY id
ORDER BY created_at DESC
LIMIT :limit

```

_[List updated](https://github.com/SidVal/discourse-data-explorer/blob/queries/querys.md)_ 🚀

---

_[View the full topic](https://meta.discourse.org/t/last-7-days-of-topics/85103)._