VENTE MAISONS RECENTES FRANCE

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, 11,55735,55734)) AND bien.id IN(SELECT Distinct(bien.id) FROM bien WHERE lcase(Titre) Like '% recente %' OR Lcase(Descriptif) Like '%recente%') AND 1=1 ORDER BY DatePublication DESC Ligne : 92