« Utilisateur:L.strappazzon » : différence entre les versions
De Le dictionnaire
Aucun résumé des modifications |
Aucun résumé des modifications |
||
| Ligne 1 : | Ligne 1 : | ||
{{#cargo_query:tables=SousEntrees | {{#cargo_query:tables=SousEntrees | ||
|fields=count(*),_pageName,etymologie | |fields=count(*),_pageName,etymologie | ||
|group by=etymologie | |||
|where=etymologie IS NOT NULL | |where=etymologie IS NOT NULL | ||
|limit=5000 | |limit=5000 | ||
Version du 6 mars 2024 à 12:41
Error 1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'acadpharm_prod.A_cargo__SousEntrees._pageName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Function: CargoSQLQuery::run Query: SELECT count(*),`_pageName` AS `_pageName`,`etymologie` AS `etymologie` FROM `A_cargo__SousEntrees` WHERE etymologie IS NOT NULL GROUP BY `etymologie` ORDER BY count(*),`_pageName`,`etymologie` LIMIT 5000
