# Data Explorer query for topics N+ days old, that are unsolved

**URL:** <https://meta.discourse.org/t/data-explorer-query-for-topics-n-days-old-that-are-unsolved/272020>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [July 18, 2023, 8:29pm UTC](https://meta.discourse.org/t/data-explorer-query-for-topics-n-days-old-that-are-unsolved/272020 "2023-07-18T20:29:27Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![jordan-violet](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jordan-violet/32/281428_2.png) [@jordan-violet](https://meta.discourse.org/u/jordan-violet)\
**Post date:** [July 18, 2023, 8:29pm UTC](https://meta.discourse.org/t/data-explorer-query-for-topics-n-days-old-that-are-unsolved/272020/1 "2023-07-18T20:29:27Z")

</div>

I am trying to create a [data explorer](https://meta.discourse.org/t/32566?silent=true) query that returns a list of topics, where:

- The topic is unsolved
- The topic is 7+ days old from the current date ran

---

_[View the full topic](https://meta.discourse.org/t/data-explorer-query-for-topics-n-days-old-that-are-unsolved/272020)._