# ALIAS and Complicated Search Query
**URL:** https://discuss.elastic.co/t/alias-and-complicated-search-query/220617
**Category:** Elasticsearch
**Created:** [February 24, 2020, 10:04am UTC](https://discuss.elastic.co/t/alias-and-complicated-search-query/220617 "2020-02-24T10:04:56Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Rishabh\_Baid](https://discuss.elastic.co/u/Rishabh_Baid)
#### Post date: [February 24, 2020, 10:04am UTC](https://discuss.elastic.co/t/alias-and-complicated-search-query/220617/1 "2020-02-24T10:04:57Z")
Hi
I am trying to write this query -
search Elasticsearch docs - in the field - foobar - for anything which has the characters "rix" in it -
Then lets assume we get 500 documents with "rix" in foobar field..
Now I want to check each of the 500 returned docs and see if 5 mins before this doc - was there a doc with characters "abh" in the foobar field. If yes I only want to finally retain and view those "rix" documents.
Example -
I got 500 documents where there is "rix"in foobar field.
Only for around 100 of these documents - there was an "abh" containing document 5 mins before.
I finally want to view only those 100 "rix" containing docs.
I have the following mySQL query -
SELECT t1.\* FROM sumit\_test AS t1 WHERE t1.foobar LIKE "%rix%" AND TIMESTAMPDIFF(MINUTE,(SELECT t2.@TIMESTAMP FROM sumit\_test AS t2 WHERE t2.foobar LIKE "%abh%"),t1.@TIMESTAMP) \< 5
How do I do it in Elasticsearch DSL???
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 23, 2020, 10:05am UTC](https://discuss.elastic.co/t/alias-and-complicated-search-query/220617/2 "2020-03-23T10:05:04Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.