SELECT count(*) as nbAnnonces FROM codesPostaux  INNER JOIN annonceurs ON codesPostaux.codePostal = annonceurs.codePostal  INNER JOIN annonces ON annonces.noClient = annonceurs.noClient  INNER JOIN journaux_region_geo ON annonces.idPublication = journaux_region_geo.idJournal  INNER JOIN codesIndustrie_en ci ON annonces.idIndustrie = ci.idIndustrie  WHERE  1 = 1  AND annonces.enLigne = 1 AND annonces.imageEnLigne = 1  GROUP BY annonces.noBillet ORDER BY annonces.idIndustrie ASC  <hr />0