When a subquery is in IN or EXISTS, DISTINCT has no effect and can be removed. The same is true of all set operations, with exception of Concat.