# Impossible Query

**URL:** <https://discuss.elastic.co/t/impossible-query/77906>\
**Category:** Elasticsearch\
**Created:** [March 8, 2017, 10:15pm UTC](https://discuss.elastic.co/t/impossible-query/77906 "2017-03-08T22:15:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alejandro\_Celis](https://avatars.discourse-cdn.com/v4/letter/a/b782af/32.png) [@Alejandro\_Celis](https://discuss.elastic.co/u/Alejandro_Celis)\
**Post date:** [March 8, 2017, 10:15pm UTC](https://discuss.elastic.co/t/impossible-query/77906/1 "2017-03-08T22:15:55Z")

</div>

I have 36 million customers in (elastic-co-domain/webiste/customers) that are set a parents of 300 million page views (elastic-co-domain/website/page\_views), and each page\_view has a property "URL".

Each customer can have several pageviews.

How can I get the customers that HAVE NEVER seen a page that contains "shoes" in the property URL...

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 5, 2017, 10:16pm UTC](https://discuss.elastic.co/t/impossible-query/77906/2 "2017-04-05T22:16:14Z")

</div>

Closed on April 5, 2017, 10:16pm UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.