SELECT movie_list . * , movie_genre.genre_id
FROM movie_list, movie_genre
WHERE movie_genre.movie_id = movie_list.movie_id
AND movie_genre.genre_id
IN ( 12, 35, 878 )

SELECT tbl1.movie_id FROM
(SELECT movie_list . * , movie_genre.genre_id
FROM movie_list, movie_genre
WHERE movie_genre.movie_id = movie_list.movie_id
AND movie_genre.genre_id
IN ( 12, 35, 878 ))as tbl1

SELECT l.*, g.genre_id
  FROM movie_list AS l
  JOIN movie_genre AS g ON l.movie_id = g.movie_id
 WHERE g.genre_id IN (12, 35, 878)

SELECT t.movie_id
  FROM (SELECT l.*, g.genre_id
          FROM movie_list AS l
          JOIN movie_genre AS g ON l.movie_id = g.movie_id
         WHERE g.genre_id IN (12, 35, 878)
       ) AS t