Probleme lors de l'execution de la requete !<br />
<div style="padding:4px; border-left:1px solid red;margin-left:40px;width:auto;"><em>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-23 23:31:24") 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 23:31:24") 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`  = "JML-Finance-Luxembourg-Sarl" OR V.`CodeSicovam`  = "JML-Finance-Luxembourg-Sarl" ) GROUP BY V.`NomSociete`, V.`CodeBourse`, `TypeDeMarche` ORDER BY V.`NomSociete`  LIMIT 0, 1</em></div><span class="important">Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'actusnewswire.V.IndexTable' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by<br><br>LIGNE_APPEL_REQ:/home/sites_web/client/actusnews_main/act_www/models/pages/societe.php---L:122</span>