SELECT COUNT(*) as nb FROM annonces left join villes on annonces.ville=villes.variante inner join agencesSite on annonces.agenceID=agencesSite.agenceID WHERE agencesSite.siteID=98 AND annonces.siteID=98 and typeBien='AL' AND typeBien NOT LIKE 'B%' AND typeBien NOT LIKE 'I%' AND typeBien NOT LIKE 'C%' AND (REPLACE(annonces.ville,'-',' ')='Saint maur des fossa�s' or REPLACE(villes.ville,'-',' ')='Saint maur des fossa�s')