select music_name from ( select distinct music_id from music_likes where user_id in (select follower_id from follow where user_id = 1) and music_id not in (select music_id from music_likes where user_id = 1) ) a join music m on a.music_id = m.id order by id
distinct 不能和 order by连用



京公网安备 11010502036488号