# Some queries that don't finish

**URL:** <https://meta.discourse.org/t/some-queries-that-dont-finish/113560>\
**Category:** Product Support\
**Created:** [April 5, 2019, 3:19pm UTC](https://meta.discourse.org/t/some-queries-that-dont-finish/113560 "2019-04-05T15:19:00Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![bartv](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/bartv/32/130052_2.png) [@bartv](https://meta.discourse.org/u/bartv)\
**Post date:** [April 5, 2019, 6:08pm UTC](https://meta.discourse.org/t/some-queries-that-dont-finish/113560/5 "2019-04-05T18:08:18Z")

</div>

I ran the previous version of this query, which only took about 1 second on my system too:

```plaintext
SELECT p2.id
FROM posts p2
LEFT JOIN post_search_data pd ON pd.locale = 'en' 
AND pd.version = 2 
AND p2.id = pd.post_id
WHERE pd.post_id IS NULL

```

This returned 3139 rows.

---

_[View the full topic](https://meta.discourse.org/t/some-queries-that-dont-finish/113560)._