Test-abc: Difference between revisions
From CSDMS
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
|fields=RefsExt._pageName=Page | |fields=RefsExt._pageName=Page | ||
|where=RefsExt.Lastname HOLDS NOT '' | |where=RefsExt.Lastname HOLDS NOT '' | ||
|format= | |format=dynamic table | ||
|template=Test2 | |template=Test2 | ||
}} | }} | ||
Revision as of 15:10, 3 May 2017
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 'HOLDS NOT ORDER BY `RefsExt2`.`_pageID`,`RefsExt`.`_pageID`,`RefsExt`.`_page' at line 1
Function: CargoSQLQuery::run Query: SELECT `RefsExt2`.`_pageID` AS `cargo_backlink_page_id_RefsExt2`,`RefsExt`.`_pageID` AS `cargo_backlink_page_id_RefsExt`,`RefsExt`.`_pageName` AS `Page` FROM `mw_cargo__RefsExt` `RefsExt` LEFT OUTER JOIN `mw_cargo__RefsExt2` `RefsExt2` ON ((`RefsExt`.`_pageName`=`RefsExt2`.`_pageName`)) WHERE `RefsExt`.`Lastname` HOLDS NOT ORDER BY `RefsExt2`.`_pageID`,`RefsExt`.`_pageID`,`RefsExt`.`_pageName` LIMIT 1000
