-127 The DISTINCT qualifier is specified more than once in a subselect.

Explanation

The DISTINCT qualifier can only be used once in a SELECT statement or subselect.