Probleme lors de l'execution de la requete !
SELECT count(*) as max_row , V.`IndexTable` as V_ID, V.`RaisonSociale` AS Raison, V.`NomSociete`, V.`LogoSociete`, V.`CodeSicovam`, V.IDTypeDeMarche, V.`SecteurFootsie`, V.`CodeBourse`, V.`Mnemo`, T.Nom AS TypeDeMarche , V.`SecteurActivite`, V.`secteur_id` , (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 03:12:41") 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 03:12:41") 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
INNER JOIN `Valeurs` V ON ( C.`CodeSicovam` = V.`CodeSicovam` )
RIGHT JOIN `RefCommuniques` R ON (C.`ThemeID` = R.`ThemeID`) AND (R.`Type` = "CP")
LEFT JOIN TypeDeMarche T ON (V.IDTypeDeMarche = T.IndexTable)

WHERE NOT(V.`State` = 'DELETE') AND NOT(V.`Affichage` = 'NON')
AND (C.`State` = "NEW" OR C.`State` = "UPDATE")
AND (C.`Etat` = "Valid" OR C.`Etat` = "Normal")
AND (V.`Affichage` = "OUI")
AND (C.`AfficheSite` = "OUI")
AND (C.`DateEmission` > DATE_SUB(CURRENT_TIMESTAMP , INTERVAL "1830" DAY))
AND (C.`DateEmission` <= "2020-02-24 03:12:41")
AND V.`RaisonSociale` = "BOIRON"
In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'actusnewswire.V.IndexTable'; this is incompatible with sql_mode=only_full_group_by

LIGNE_APPEL_REQ:/home/sites_web/client/actusnews_main/act_www/models/pages/communiques.php---L:326