select     music_name from music where id in (select             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)) group by 1,id order by id
1

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务