# I have a list of one thousand stores and need to extract the list of people who have been nearby (within 100m of) these stores

**URL:** https://discuss.elastic.co/t/i-have-a-list-of-one-thousand-stores-and-need-to-extract-the-list-of-people-who-have-been-nearby-within-100m-of-these-stores/156444
**Category:** Elasticsearch
**Created:** [November 13, 2018, 10:26am UTC](https://discuss.elastic.co/t/i-have-a-list-of-one-thousand-stores-and-need-to-extract-the-list-of-people-who-have-been-nearby-within-100m-of-these-stores/156444 "2018-11-13T10:26:55Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Michal\_Soutys](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/michal_soutys/32/37576_2.png) [@Michal\_Soutys](https://discuss.elastic.co/u/Michal_Soutys)
#### Post date: [November 13, 2018, 10:26am UTC](https://discuss.elastic.co/t/i-have-a-list-of-one-thousand-stores-and-need-to-extract-the-list-of-people-who-have-been-nearby-within-100m-of-these-stores/156444/1 "2018-11-13T10:26:55Z")

</div>

I have a list of one thousand stores and need to extract the list of people who have been nearby (within 100m of) these stores.  
Which query or aggregation should I use in order not to make one thousand queries/aggregations?

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [November 14, 2018, 5:45am UTC](https://discuss.elastic.co/t/i-have-a-list-of-one-thousand-stores-and-need-to-extract-the-list-of-people-who-have-been-nearby-within-100m-of-these-stores/156444/2 "2018-11-14T05:45:57Z")

</div>

There's no single query that can help here unfortunately. But you can issue multiple queries with `_msearch` [https://www.elastic.co/guide/en/elasticsearch/reference/6.4/search-multi-search.html](https://www.elastic.co/guide/en/elasticsearch/reference/6.4/search-multi-search.html)

---

<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: [December 12, 2018, 6:00am UTC](https://discuss.elastic.co/t/i-have-a-list-of-one-thousand-stores-and-need-to-extract-the-list-of-people-who-have-been-nearby-within-100m-of-these-stores/156444/3 "2018-12-12T06:00:50Z")

</div>

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