select T.music_name from (select /f.user_id, f.follower_id,/ distinct m1.music_id, m2.music_name from follow f left join music_likes m1 on f.follower_id=m1.user_id left join music m2 on m1.music_id=m2.id where f.user_id=1 and m1.music_id not in (select music_id from music_likes where user_id =1))T order by T.music_id asc



京公网安备 11010502036488号