Template:Include featured references models cargo2: Difference between revisions
No edit summary Tag: Reverted |
No edit summary Tag: Reverted |
||
Line 28: | Line 28: | ||
|where = _pageName = '{{#arrayindex: val | 0}}' AND requires_class__full IS NULL | |where = _pageName = '{{#arrayindex: val | 0}}' AND requires_class__full IS NULL | ||
|default= | |default= | ||
|fields=_pageName, | |fields=_pageName, 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 | ||
|format=template|template=Test6b}} | |format=template|template=Test6b}} | ||
|{{#cargo_query:tables=RefsExt | |{{#cargo_query:tables=RefsExt |
Revision as of 11:30, 25 October 2021
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__BibEntryCargo`.`_pageID` AS `cargo_backlink_page_id_BibEntryCargo`,`_pageName` AS `_pageName`,`BibType` AS `BibType`,`Title__full` AS `Title full`,`Editors__full` AS `Editors full`,DATE_FORMAT(Year__full,"%Y") AS `var1`,`Journal__full` AS `Journal full`,`Booktitle__full` AS `Booktitle full`,`Volume__full` AS `Volume full`,`Pages__full` AS `Pages full`,`URL__full` AS `URL full`,`DOI__full` AS `DOI full`,`ISBN__full` AS `ISBN full`,`Note__full` AS `Note full`,`Firstname__full` AS `Firstname full` FROM `mw_cargo__BibEntryCargo` WHERE _pageName = AND requires_class__full IS NULL ORDER BY `mw_cargo__BibEntryCargo`.`_pageID`,`_pageName`,`BibType`,`Title__full`,`Editors__full` LIMIT 1000