SELECT `tbl_release`.`id_release`, `tbl_release`.`date`, `tbl_release`.`film_id`, `tbl_release`.`titre`, `tbl_release`.`group`, `tbl_release`.`fichier`, `tbl_release`.`nfo_image`, `tbl_release`.`url`, `tbl_release`.`afficher`, `tbl_film`.`date` as `annee`, `tbl_film`.`titre` as `titre_film`, `tbl_film`.`url` as `url_film`, `tbl_film`.`url` as `url_film` FROM `tbl_release` LEFT JOIN `tbl_film` ON `tbl_release`.`film_id` = `tbl_film`.`titre` WHERE `tbl_film`.`url` = '100-days-to-live' AND `tbl_film`.`date` = 2019 AND `tbl_release`.`afficher` = 1 ORDER BY `tbl_release`.`group` ASC
L'avis des membres