Removing duplicates
Short Description
The query was using SELECT DISTINCT in such a way that MySQL could not optimize away the distinct operation at an early stage. Because of this, MySQL requires an extra stage to remove all duplicated rows before sending the result to the client.
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.