SQL parse error when where condition contains 'join' keyword

[warmbreeze]

when query elasticsearch use SQL, we use SQL statement as follow:
select /*! IGNORE_UNAVAILABLE */ * from index-1,index-2,index-3/mytype where _id = 'test_join_test' limit 10 offset 0
Then return this error message:
{"message":"currently supports only 2 tables join","ok":false}