去重复 - 一个mysql多表，多条件查询去重的问题

Answer 1

Try select distinct *?

Answer 2

Duplication removal must be based on a certain condition. For example, uid
does not consider efficiency. You can use distinct(uid) or group by uid
to remove duplicates in Bao subquery