Probleme lors de l'execution de la requete !
SELECT C.`IndexTable` as C_ID, C.`Titre`, C.`Texte`, C.`DateEmission`, C.`ContactCommuniques`, C.`Document`, C.`Langue`, C.`Taille`, C.`DateUpdate`, C.`AfficheSite`, C.`Url`, C.KeySecure
, V.`IndexTable` as V_ID, V.`RaisonSociale` AS Raison, V.`NomSociete`, V.`LogoSociete`, V.`SecteurFootsie`, V.`CodeBourse`, V.`Mnemo`, V.`CodeSicovam`, T.Nom AS `TypeDeMarche` , V.`SecteurActivite`, V.`secteur_id` , V.`Contact`, V.`AdresseWeb`, V.`EmailContact1`, V.`DateUpdate` as DateUpdateProfil, (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` > 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-23 18:02:06") 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 `Communiques` C , `Valeurs` V LEFT JOIN TypeDeMarche T ON (V.IDTypeDeMarche = T.IndexTable)
WHERE NOT(C.`State` = "DELETE") AND (C.`AfficheSite` = "OUI") AND (C.`DateEmission` <= "2020-02-23 18:02:06") AND ((C.`Etat` = "Normal")OR(C.`Etat` = "Valid")) AND (C.`DateEmission` like "2019-12-02%") AND (C.`Url` = "invibes-advertising-european-expansion-continues-with-a-new-office-opening-in-italy") AND (C.`CodeSicovam` = V.`CodeSicovam`)
AND NOT(V.`State` = 'DELETE') AND NOT (V.`Affichage` = 'NON')
AND V.`RaisonSociale` = "INVIBES-ADVERTISING"
GROUP BY V.`NomSociete`, V.`CodeBourse`
ORDER BY V.`NomSociete`
LIMIT 0, 1
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'actusnewswire.C.IndexTable' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

LIGNE_APPEL_REQ:/home/sites_web/client/actusnews_main/act_www/models/pages/communique.php---L:166