SELECT a.*, b.`nom` AS `genre`, c.`nom` AS `type`, d.`nom` AS `format`, e.`nom` AS `pays`, f.`commission` AS `commission`, f.`type` AS `commission_type` FROM `film` a LEFT JOIN `film_genres` b ON (a.`no_film_genre` = b.`no`) LEFT JOIN `film_types` c ON (a.`no_film_type` = c.`no`) LEFT JOIN `film_formats` d ON (a.`no_film_format` = d.`no`) LEFT JOIN `pays` e ON (a.`no_pays` = e.`id`) LEFT JOIN `commission` f ON (a.`commission_id` = f.`id`) WHERE a.`slug` = 'magic-abbass'