Crime
2019
2018
Aventure
2021
Drame
2015
2017
Comédie
2022
Action
2016
2008
2023
Documentaire
2014
Animation
1970
Mystère
2000
2013
Fantastique
SELECT `m_movies`.*, `m_movies_v`.`title`, `m_movies_v`.`release_date`, (select p.id from m_posters p where p.movie_id = m_movies.id and p.type = 'posters' and p.language in ('fr', 'en') order by (p.language = 'fr') desc limit 1) as poster_id, (select GROUP_CONCAT(DISTINCT mgv.name SEPARATOR ';') from m_movies_genres mmg left join m_genres mg on mg.id = mmg.genre_id left join m_genres_v mgv on mgv.genre_id = mg.id and mgv.language = 'fr' where mmg.movie_id = m_movies.id) as genresFROM `m_movies`LEFT JOIN `m_movies_v` ON `m_movies_v`.`movie_id` = `id`WHERE `m_movies_v`.`language` = 'fr'ORDER BY RAND() LIMIT 30
Array ( )