SELECT movietogenres.genre_id,
       movietogenres.movie_id,
       genres.genre_string
FROM   movietogenres
       INNER JOIN genres
               ON movietogenres.genre_id = genres.genre_id
WHERE  ( movietogenres.movie_id IN (SELECT DISTINCT movies.movie_id AS movieid
                                    FROM   movies
                                           INNER JOIN movietogenres AS
                                                      MovieToGenres_1
                                                   ON movies.movie_id =
                                                      MovieToGenres_1.movie_id
                                           INNER JOIN genres AS Genres_1
                                                   ON MovieToGenres_1.genre_id =
                                                      Genres_1.genre_id
                                    WHERE  ( Genres_1.genre_string LIKE {0} +
                                             '%' )) )