« 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,disciplines
|fields=_pageName,disciplines
|where=disciplines != ''
|where=disciplines HOLDS NOT ''
|order by=disciplines
|order by=disciplines
|group by=_pageName,disciplines
|group by=_pageName,disciplines

Version du 15 janvier 2024 à 18:23

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT ) GROUP BY _pageName,disciplines ORDER BY `A_cargo__SousEntrees`.`discip' at line 1

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `_pageName`,`disciplines__full` AS `disciplines` FROM `A_cargo__SousEntrees` WHERE `A_cargo__SousEntrees`.`_ID` IN (SELECT `_rowID` FROM `A_cargo__SousEntrees__disciplines` WHERE `_value`= NOT ) GROUP BY _pageName,disciplines ORDER BY `A_cargo__SousEntrees`.`disciplines__full` LIMIT 100