Erreur SQL !<br>SELECT count(DISTINCT `annonce`.`idannonce`) FROM `cpt`,`lst_marque`,`lst_pays`,`lst_categorie`,`lst_energie`,`annonce` WHERE `annonce`.`idcpt` = `cpt`.`idcpt`  AND `lst_marque`.`idmarque`=`annonce`.`marque` AND `cpt`.`pays` = `lst_pays`.`idpays` AND `annonce`.`categorie`=`lst_categorie`.`idcategorie` AND `annonce`.`energie`=`lst_energie`.`idenergie` AND `annonce`.`etat`='1' AND `cpt`.`etat`='1' AND `typeannonce`='v'  AND (`commune`='Chaumont' OR `commune2`='Chaumont' OR `commune3`='Chaumont')<br>