For IN/ALL/ANY/SOME/EXISTS subqueries, the following clauses are 
meaningless:

* ORDER BY (since we don't support LIMIT in these subqueries)
* DISTINCT
* GROUP BY if there is no HAVING clause and no aggregate 
           functions

This WL detects and optimizes away these useless parts of the
query during JOIN::prepare()