Template:Include featured references models cargo: Difference between revisions

From CSDMS
No edit summary
No edit summary
Line 1: Line 1:
{{#ifeq:{{#cargo_query:tables=RefsInt2|where=RefsInt2.FeatureRef='Yes'|default=}}|||{{Publication_table_models1}} {{#arraydefine:refs |{{#cargo_query:tables= RefsInt2|where=RefsInt2.FeatureRef='Yes'| fields=_pageName|format=template|template=Test3a}} }} }}
{{#ifeq:{{#cargo_query:tables=table1=RefsInt2, table2=RefsInt1|join on=table1._pageName=table2._pageName|where = table1.PublicationMultipleModelsCargo  LIKE "{{PAGENAME}}" AND table2.FeatureRef="Yes"|default=}}|||{{Publication_table_models1}} {{#arraydefine:refs |{{#cargo_query:tables= RefsInt2|where = table1.PublicationMultipleModelsCargo LIKE "{{PAGENAME}}"| fields=_pageName|format=template|template=Test3a}} }} }}
 
{{
{{
   #loop: i
   #loop: i

Revision as of 09:57, 20 December 2019

Publication(s)YearTypeCited
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 'table1.PublicationMultipleModelsCargo' in 'where clause'\x0AFunction: CargoSQLQu' at line 1

Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsExt`.`_pageID` AS `cargo_backlink_page_id_RefsExt`,`_ID` AS `_ID`,`Lastname` AS `Lastname`,`Firstname` AS `Firstname` FROM `mw_cargo__RefsExt` WHERE _pageName = '<div class="error">Error 1054: Unknown column 'table1.PublicationMultipleModelsCargo' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsInt2`.`_pageID` AS `cargo_backlink_page_id_RefsInt2`' ORDER BY `_ID` LIMIT 1000

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 'table1.PublicationMultipleModelsCargo' in 'where clause'\x0AFunction: CargoSQLQu' at line 1

Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsExt2`.`_pageID` AS `cargo_backlink_page_id_RefsExt2`,`_pageName` AS `_pageName`,`ItemType` AS `ItemType`,`Title` AS `Title`,`PublicationTitle` AS `PublicationTitle`,`Booktitle` AS `Booktitle`,`JournalAbbreviation` AS `JournalAbbreviation`,`Volume` AS `Volume`,`Issue` AS `Issue`,`Url` AS `Url`,`DOI` AS `DOI`,`Pagenumbers` AS `Pagenumbers`,`Publicationdate` AS `Publicationdate`,`AccessDate` AS `AccessDate`,`AccessDate__precision` AS `AccessDate__precision` FROM `mw_cargo__RefsExt2` WHERE _pageName = '<div class="error">Error 1054: Unknown column 'table1.PublicationMultipleModelsCargo' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsInt2`.`_pageID` AS `cargo_backlink_page_id_RefsInt2`' ORDER BY `mw_cargo__RefsExt2`.`_pageID`,`_pageName`,`ItemType`,`Title`,`PublicationTitle` LIMIT 1000

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 'table1.PublicationMultipleModelsCargo' in 'where clause'\x0AFunction: CargoSQLQu' at line 1

Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsInt2`.`_pageID` AS `cargo_backlink_page_id_RefsInt2`,`PublicationMultipleModelsCargo` AS `PublicationMultipleModelsCargo` FROM `mw_cargo__RefsInt2` WHERE _pageName = '<div class="error">Error 1054: Unknown column 'table1.PublicationMultipleModelsCargo' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsInt2`.`_pageID` AS `cargo_backlink_page_id_RefsInt2`' ORDER BY `mw_cargo__RefsInt2`.`_pageID`,`PublicationMultipleModelsCargo` LIMIT 1000

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 'table1.PublicationMultipleModelsCargo' in 'where clause'\x0AFunction: CargoSQLQu' at line 1

Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsInt1`.`_pageID` AS `cargo_backlink_page_id_RefsInt1`,`PublicationWhatKindOf` AS `PublicationWhatKindOf`,`PublicationClusterID` AS `PublicationClusterID`,`PublicationCitationsNr` AS `PublicationCitationsNr`,`MS_PublicationClusterID` AS `MS PublicationClusterID` FROM `mw_cargo__RefsInt1` WHERE _pageName = '<div class="error">Error 1054: Unknown column 'table1.PublicationMultipleModelsCargo' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsInt2`.`_pageID` AS `cargo_backlink_page_id_RefsInt2`' ORDER BY `mw_cargo__RefsInt1`.`_pageID`,`PublicationWhatKindOf`,`PublicationClusterID`,`PublicationCitationsNr`,`MS_PublicationClusterID` LIMIT 1000

Error: Table AuthorsMan not found.