# עזרה עם SQL - סגירה אוטומטית/תוצאות חוזרות/סינון שבועי

**URL:** <https://meta.discourse.org/t/help-with-sql-autoclose-repeat-results-week-filter/231038>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [24 ביוני,‏ 2022,‏ 5:25pm UTC](https://meta.discourse.org/t/help-with-sql-autoclose-repeat-results-week-filter/231038 "2022-06-24T17:25:17Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\
**Post date:** [24 ביוני,‏ 2022,‏ 6:50pm UTC](https://meta.discourse.org/t/help-with-sql-autoclose-repeat-results-week-filter/231038/2 "2022-06-24T18:50:29Z")

</div>

Try adding this after the `WHERE` line.

```
 AND t.id = dvc.topic_id

```

I didn’t test it, but I think that’s your big problem (fixes the “same topic” problem)

---

_[View the full topic](https://meta.discourse.org/t/help-with-sql-autoclose-repeat-results-week-filter/231038)._
