Stupid mistake
One more question. How to get genres + actors where genre name like... ?
PHP Code:
SELECT m.id, m.title, m.year, GROUP_CONCAT(g.genre) AS genres, GROUP_CONCAT(a.actor) AS actors
FROM movies m
INNER JOIN moviegenres mg ON (mg.movie_id = m.id)
INNER JOIN genres g ON (g.id = mg.genre_id)
INNER JOIN movieactors ma ON (ma.movie_id = m.id)
INNER JOIN actors g ON (a.id = ma.actor_id)
WHERE `genre` LIKE '%%%s%%'
GROUP BY m.title
LIMIT %d, %d;";