« 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=_pageName,etymologie | |fields=count(_pageName),_pageName,etymologie | ||
|where=etymologie IS NOT NULL | |where=etymologie IS NOT NULL | ||
|limit=5000 | |limit=5000 |
Version du 6 mars 2024 à 11:39
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'acadpharm_prod.A_cargo__SousEntrees._pageID'; this is incompatible with sql_mode=only_full_group_by
Function: CargoSQLQuery::run Query: SELECT `A_cargo__SousEntrees`.`_pageID` AS `cargo_backlink_page_id_SousEntrees`,count(_pageName) AS `count( pageName)`,`_pageName` AS `_pageName`,`etymologie` AS `etymologie` FROM `A_cargo__SousEntrees` WHERE etymologie IS NOT NULL ORDER BY `A_cargo__SousEntrees`.`_pageID`,count(_pageName),`_pageName`,`etymologie` LIMIT 100