select music_name from ( select id,t7.music_name as music_name from (select t6.music_name as music_name from (select music_name from ( select music_id,id,music_name from music join ( select user_id,music_id from music_likes where user_id = 1 ) as t3 on music_id=id ) as t4) as t5 right join (select distinct music_name from ( select id,music_id,music_name from music join ( select ml.user_id,follower_id,music_id from music_likes as ml join ( select user_id,follower_id from follow where user_id = 1 ) as f on f.follower_id = ml.user_id ) as t1 on id = music_id ) as t2) as t6 on t5.music_name = t6.music_name where t5.music_name is null) as t7 join ( select id,music_name from music) as t8 on t7.music_name = t8.music_name order by id) as wobuxiangxiele

京公网安备 11010502036488号