Template:Include featured references models cargo2: Difference between revisions
From CSDMS
No edit summary |
No edit summary |
||
Line 2: | Line 2: | ||
|join on=RefsInt1._pageName=RefsInt2._pageName | |join on=RefsInt1._pageName=RefsInt2._pageName | ||
|fields=FeatureRef,PublicationMultipleModelsCargo | |fields=FeatureRef,PublicationMultipleModelsCargo | ||
|where = PublicationMultipleModelsCargo LIKE "{{PAGENAME}}" | |where = RefsInt1.FeatureRef="YES", AND PublicationMultipleModelsCargo LIKE "{{PAGENAME}}" | ||
}} | }} | ||
Revision as of 08:52, 25 October 2021
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 ', AND PublicationMultipleModelsCargo LIKE "Include featured references models ca' at line 1
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsInt2`.`_pageID` AS `cargo_backlink_page_id_RefsInt2`,`mw_cargo__RefsInt1`.`_pageID` AS `cargo_backlink_page_id_RefsInt1`,`FeatureRef` AS `FeatureRef`,`PublicationMultipleModelsCargo` AS `PublicationMultipleModelsCargo` FROM `mw_cargo__RefsInt1` LEFT OUTER JOIN `mw_cargo__RefsInt2` ON ((`mw_cargo__RefsInt1`.`_pageName`=`mw_cargo__RefsInt2`.`_pageName`)) WHERE `mw_cargo__RefsInt1`.`FeatureRef`="YES", AND PublicationMultipleModelsCargo LIKE "Include featured references models cargo2" ORDER BY `mw_cargo__RefsInt2`.`_pageID`,`mw_cargo__RefsInt1`.`_pageID`,`FeatureRef`,`PublicationMultipleModelsCargo` LIMIT 1000