with t as(select distinct music_id from music_likes mk 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)) select m.music_name from t join music m on t.music_id = m.id order by m.id

京公网安备 11010502036488号