select music_name from ( select distinct id ,music_name from music_likes m1 join follow m2 on m1.user_id = m2.follower_id join music m3 on m1.music_id = m3.id where m2.user_id = '1' and m1.music_id not in ( select music_id from music_likes where user_id = '1' ) order by id )a

京公网安备 11010502036488号