« 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