select 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'
)
group by id
order by id

京公网安备 11010502036488号