Test cargo: Difference between revisions
From CSDMS
No edit summary |
No edit summary |
||
| Line 15: | Line 15: | ||
{{#count:{{#arrayprint:test}} | {{#count:{{#arrayprint:test}} | ||
|1}} | |1}} | ||
{{#arrayprint:test}} | |||
<!-- | <!-- | ||
SELECT id, password, COUNT(id) AS count FROM users WHERE email = :email GROUP BY id, password LIMIT 1 | SELECT id, password, COUNT(id) AS count FROM users WHERE email = :email GROUP BY id, password LIMIT 1 | ||
--> | --> | ||
Revision as of 10:22, 24 October 2021
3
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 '*) FROM `mw_cargo__BibEntryCargo` LEFT OUTER JOIN `mw_cargo___pageData` ON ((`m' at line 1 (localhost)
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__BibEntryCargo`.`_pageID` AS `cargo_backlink_page_id_BibEntryCargo`, `mw_cargo__BibEntryCargo`.`_pageName` AS `_pageData._creationDate`, SUM(*) FROM `mw_cargo__BibEntryCargo` LEFT OUTER JOIN `mw_cargo___pageData` ON ((`mw_cargo__BibEntryCargo`.`_pageName`=`mw_cargo___pageData`.`_pageName`)) WHERE `mw_cargo___pageData`.`_creationDate` LIKE '%2021%' GROUP BY `mw_cargo__BibEntryCargo`.`_pageName` ORDER BY `mw_cargo__BibEntryCargo`.`_pageID`, `mw_cargo__BibEntryCargo`.`_pageName`, SUM(*) LIMIT 50000
