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