SELECT V.`IndexTable` as V_ID, V.`RaisonSociale` AS Raison, V.`NomSociete`, V.`LogoSociete`, V.`SecteurFootsie`, V.`CodeBourse`, V.`Lei`, V.`Mnemo`, V.`CodeSicovam`, T.`Nom` AS TypeDeMarche , V.`SecteurActivite`, V.`secteur_id` , V.`Descriptif`, V.`AdresseWeb` , V.`BourseDirect`, V.`WebInvestisseur`, V.`EmailContact1`, V.`Contact` , V.`Capitalisation`, V.`NombreTitres`, V.`Reuters`, V.`Bloomberg`, V.`Adresse` , V.`Interlocuteurs`, V.`CompteResultats`, V.`Agence`, V.`Ratios`, V.`ClassificationReuters`, V.`ClassificationBloomberg` , V.`TextDivers1`, V.`TextDivers2`, V.`TextDivers3`, V.`TextDivers4`, V.`TextDivers5`, V.`MemoDivers1`, V.`MemoDivers2` , V.`IndexRef`, V.`DateCreate`, V.`DateUpdate` , (SELECT count(*) FROM `Communiques` C WHERE (C.`State` = "NEW" OR C.`State` = "UPDATE") AND (C.`Etat` = "Valid" OR C.`Etat` = "Normal") AND (C.`CodeSicovam` = V.`CodeSicovam`) AND (C.`AfficheSite` = "OUI") AND (C.`DateEmission` <= "2020-02-24 00:49:23") AND (C.`DateEmission` > DATE_SUB(CURRENT_TIMESTAMP , INTERVAL "1830" DAY)) ) AS nb_COM , (SELECT count(*) FROM `Documents` D WHERE (D.`State` = "NEW" OR D.`State` = "UPDATE") AND (D.`CodeSicovam` = V.`CodeSicovam`) AND (D.`DateEmission` <= "2020-02-24 00:49:23") AND (D.`DateEmission` > DATE_SUB(CURRENT_TIMESTAMP , INTERVAL "1825" DAY)) ) AS nb_DOC , (SELECT count(*) FROM `Agendas` A WHERE (A.`State` = "NEW" OR A.`State` = "UPDATE") AND (A.`CodeSicovam` = V.`CodeSicovam`) AND NOT(A.`LibelleDate` = "-") AND (A.`DateEmission` > DATE_SUB(CURRENT_TIMESTAMP , INTERVAL "30" DAY)) ) AS nb_AGD FROM `Valeurs` V LEFT JOIN TypeDeMarche T ON (V.IDTypeDeMarche = T.IndexTable) WHERE NOT(V.`State` = 'DELETE') AND NOT (V.`Affichage` = 'NON') AND ( V.`RaisonSociale` = "ESPERITE" OR V.`CodeSicovam` = "ESPERITE" ) GROUP BY V.`NomSociete`, V.`CodeBourse`, `TypeDeMarche` ORDER BY V.`NomSociete` LIMIT 0, 1