Les 1 release du groupe DETAiLS50
SELECT `tbl_film`.`id_film`, `tbl_film`.`date` as `annee`, `tbl_film`.`titre` as `film`, `tbl_film`.`pays`, `tbl_film`.`fichier`, `tbl_film`.`url` as `url_film`, `tbl_film`.`francais`, `tbl_release`.`id_release`, `tbl_release`.`date`, `tbl_release`.`titre` as `release`, `tbl_release`.`nuked`, `tbl_release`.`group`, `tbl_release`.`url`, `tbl_release`.`url` , `tbl_release`.`nfo_image` FROM `tbl_release` LEFT JOIN `tbl_film` ON `tbl_film`.`id_film` = `tbl_release`.`film_id` WHERE `tbl_release`.`afficher` = 1 AND `tbl_release`.`group` LiKE 'details50'