A Database Error Occurred

Error Number: 1064

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 'ORDER BY `clubbing`.`date_debut` DESC' at line 5

SELECT `clubbing`.`diaporamas` FROM (`adresses`) JOIN `clubbing` ON `clubbing`.`adresse`=`adresses`.`id` AND clubbing.statut=1 AND clubbing.diaporamas IS NOT NULL WHERE `adresses`.`id` = ORDER BY `clubbing`.`date_debut` DESC