Template:Include featured references models cargo2: Difference between revisions

Revision as of 11:39, 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 '*__full IS NULL ORDER BY `mw_cargo__BibEntryCargo`.`_pageID`,`_pageName`,`BibTy' at line 1

Function: CargoSQLQuery::run Query: SELECT `mw_cargo__BibEntryCargo`.`_pageID` AS `cargo_backlink_page_id_BibEntryCargo`,`_pageName` AS `_pageName`,`BibType` AS `BibType`,`Title` AS `Title`,`Editors` AS `Editors`,DATE_FORMAT(Year,"%Y") AS `var1`,`Journal` AS `Journal`,`Booktitle` AS `Booktitle`,`Volume` AS `Volume`,`Pages` AS `Pages`,`URL` AS `URL`,`DOI` AS `DOI`,`ISBN` AS `ISBN`,`Note` AS `Note`,`Firstname` AS `Firstname` FROM `mw_cargo__BibEntryCargo` WHERE _pageName = AND *__full IS NULL ORDER BY `mw_cargo__BibEntryCargo`.`_pageID`,`_pageName`,`BibType`,`Title`,`Editors` LIMIT 1000

@@ Line 26: / Line 26: @@
 | |
 {{#cargo_query:tables=BibEntryCargo
-|where = _pageName = '{{#arrayindex: val | 0}}' AND requires_class__full IS NULL
+|where = _pageName = '{{#arrayindex: val | 0}}' AND *__full IS NULL
 |default=
-|fields=_pageName_value, BibType,Title__full, Editors__full, DATE_FORMAT(Year__full,"%Y")=var1, Journal__full, Booktitle__full, Volume__full,Pages__full, URL__full, DOI__full, ISBN__full, Note__full, Firstname__full
+|fields=_pageName, BibType,Title, Editors, DATE_FORMAT(Year,"%Y")=var1, Journal, Booktitle, Volume,Pages, URL, DOI, ISBN, Note, Firstname
 |format=template|template=Test6b}}
 |{{#cargo_query:tables=RefsExt