# Convert MySQL query to Elasticsearch query
**URL:** https://discuss.elastic.co/t/convert-mysql-query-to-elasticsearch-query/133509
**Category:** Elasticsearch
**Created:** [May 28, 2018, 9:39am UTC](https://discuss.elastic.co/t/convert-mysql-query-to-elasticsearch-query/133509 "2018-05-28T09:39:20Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@newnewb](https://discuss.elastic.co/u/newnewb)
#### Post date: [May 28, 2018, 9:39am UTC](https://discuss.elastic.co/t/convert-mysql-query-to-elasticsearch-query/133509/1 "2018-05-28T09:39:20Z")
Heello,
We're considering moving to ELK, so I just started learning ES and I need to convert our MySQL query into Elasticsearch so we can benchmark the performance of both, but everything's still a bit confusing..
Can anyone help me convert this simple query into an ES query?
```
SELECT count(*)
FROM (
SELECT DISTINCT word_id
FROM words_list
WHERE domain_id = 58 AND type_id IN (5, 3)
)as our_data
JOIN (
SELECT word_id
FROM words_list
WHERE type_id = 5
) as other_data
ON our_data.word_id=other_data.word_id
;
```
---
### Author:  [@thiago](https://discuss.elastic.co/u/thiago)
#### Post date: [May 28, 2018, 5:52pm UTC](https://discuss.elastic.co/t/convert-mysql-query-to-elasticsearch-query/133509/2 "2018-05-28T17:52:25Z")
Elasticsearch does not performs subselects nor joins like that. At best, you can do join-like queries using nested or parent/child mappings, but that also has a few caveats.
The recommended is to denormalize data in Elasticsearch.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 25, 2018, 5:52pm UTC](https://discuss.elastic.co/t/convert-mysql-query-to-elasticsearch-query/133509/3 "2018-06-25T17:52:28Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.