Test-abc: Difference between revisions
From CSDMS
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
tables=RefsExt,RefsExt2 | tables=RefsExt,RefsExt2 | ||
|join on=RefsExt._pageName=RefsExt2._pageName | |join on=RefsExt._pageName=RefsExt2._pageName | ||
|fields=RefsExt._pageName=Page,RefsExt.Firstname=firstname,RefsExt.Lastname=lastname | |fields=RefsExt._pageName=Page,RefsExt.Firstname=firstname,RefsExt.Lastname=lastname,RefsExt2.Title=title | ||
|where=RefsExt.Lastname HOLDS NOT '' | |where=RefsExt.Lastname HOLDS NOT '' | ||
|format=dynamic table | |format=dynamic table | ||
|template=Test2 | |template=Test2 | ||
}} | }} | ||
Revision as of 16:13, 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 `mw_cargo__RefsExt2`.`_pageID`,`mw_cargo__RefsExt`.`_page' at line 1 (localhost)
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsExt2`.`_pageID` AS `cargo_backlink_page_id_RefsExt2`,`mw_cargo__RefsExt`.`_pageID` AS `cargo_backlink_page_id_RefsExt`,`mw_cargo__RefsExt`.`_pageName` AS `Page`,`mw_cargo__RefsExt`.`Firstname` AS `firstname`,`mw_cargo__RefsExt`.`Lastname` AS `lastname`,`mw_cargo__RefsExt2`.`Title` AS `title` FROM `mw_cargo__RefsExt` LEFT OUTER JOIN `mw_cargo__RefsExt2` ON ((`mw_cargo__RefsExt`.`_pageName`=`mw_cargo__RefsExt2`.`_pageName`)) WHERE `mw_cargo__RefsExt`.`Lastname` HOLDS NOT ORDER BY `mw_cargo__RefsExt2`.`_pageID`,`mw_cargo__RefsExt`.`_pageID`,`mw_cargo__RefsExt`.`_pageName`,`mw_cargo__RefsExt`.`Firstname`,`mw_cargo__RefsExt`.`Lastname` LIMIT 50000
