SELECT
m.music_name
FROM
follow f
JOIN
music_likes ml
ON
f.follower_id = ml.user_id
JOIN
music m
ON
ml.music_id = m.id
WHERE
ml.music_id not in (
SELECT
ml.music_id
FROM
follow f
JOIN
music_likes ml
ON
f.user_id = ml.user_id
WHERE
f.user_id = 1
)
AND
f.user_id = 1
GROUP BY
m.id
ORDER BY
m.id

京公网安备 11010502036488号