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 dvds.no, dvds.titre, 'dvd', DATE_FORMAT(date,'%d|%m|%Y'), dvds.nom_fichier_image, dvds.date as pour_le_tri FROM dvds INNER JOIN dvds_rubriques ON dvds_rubriques.no_dvd = dvds.no WHERE dvds_rubriques.no_rubrique in (0) AND dvds.date >= SUBDATE(NOW(), INTERVAL ( SELECT valeur FROM parametres WHERE nom='nb_jours_sortie') DAY ) AND dvds.date < NOW() AND no_site & 1 = 1 AND dvds.no in() ) ) as rq_sorties ORDER BY pour_le_tri DESC LIMIT 3 # A VIRER