You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ) as rq_sorties ORDER BY pour_le_tri DESC LIMIT 3 # A VIRER' at line 22
SELECT * FROM ( ( SELECT DISTINCT films.no, films.titre, 'film', DATE_FORMAT(date,'%d|%m|%Y'), films.nom_fichier_image, films.date as pour_le_tri FROM films INNER JOIN films_rubriques ON films_rubriques.no_film = films.no WHERE films_rubriques.no_rubrique in (10) AND films.date >= SUBDATE(NOW(), INTERVAL ( SELECT valeur FROM parametres WHERE nom='nb_jours_sortie') DAY ) AND films.date < NOW() AND no_site & 1 = 1 AND films.no in() ) ) as rq_sorties ORDER BY pour_le_tri DESC LIMIT 3 # A VIRER