SELECT DISTINCT A.PARENT_ID
FROM T AS A
JOIN T AS B USING (PARENT_ID)
WHERE A.PARAM = 200 AND B.PARAM = 300;
SELECT movie.*
FROM movie
JOIN movie_genre A ON movie.id = A.movie_id
JOIN movie_genre B ON movie.id = B.movie_id
WHERE A.genre_name = 'horror' AND B.genre_name = 'comedy';