VENTE APPARTEMENTS TERRASSE FRANCE BORD DE MER

Erreur de requête SQL!!! : SELECT Distinct(bien.id) FROM bien INNER JOIN page ON bien.idPage = page.id INNER JOIN biencodeunique ON bien.id = biencodeunique.idbien WHERE bien.Archiver = 0 AND bien.Valider = 1 AND page.Visible = 1 AND bien.EnLigne = 1 AND bien.sandbox=0 AND bien.idAgence IN( SELECT id FROM agence WHERE Archive = 0 AND Level > 0) AND bien.id IN(SELECT Distinct(bien.id) FROM bien INNER JOIN biencodeunique ON bien.id = biencodeunique.idbien WHERE biencodeunique.idCodeUnique IN (0, 12)) AND bien.id IN(SELECT Distinct(bien.id) FROM bien INNER JOIN biencodeunique ON bien.id = biencodeunique.idbien WHERE biencodeunique.idCodeUnique IN (0, 35,40)) AND 1=1 ORDER BY DatePublication DESC Ligne : 92