Template:Include references models cargo1: Difference between revisions
From CSDMS
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
<div class="col-sm-9"></div></div> | <div class="col-sm-9"></div></div> | ||
<div class="row"> | <div class="row"> | ||
<div class="col-sm-9">{{#ifeq:{{#cargo_query:tables=RefsInt2|where = PublicationMultipleModelsCargo LIKE "{{#replace:{{PAGENAME}}|-Publications}}"|limit= | <div class="col-sm-9">{{#ifeq:{{#cargo_query:tables=RefsInt2|where = PublicationMultipleModelsCargo LIKE "{{#replace:{{PAGENAME}}|-Publications}}"|limit=2500|default=}}|||{{Publication_table_models1}} {{#arraydefine:refs |{{#cargo_query:tables= RefsInt2|where = PublicationMultipleModelsCargo LIKE "{{#replace:{{PAGENAME}}|-Publications}}"| fields=_pageName|format=template|limit=2500|template=Test3a}} }} }} | ||
{{ | {{ | ||
#loop: i | #loop: i | ||
| Line 10: | Line 10: | ||
| <tr valign="top"><td> {{ | | <tr valign="top"><td> {{ | ||
#arraydefine: val | {{#arrayindex:refs | {{#var:i}} }} | ; | #arraydefine: val | {{#arrayindex:refs | {{#var:i}} }} | ; | ||
}}{{#ifeq:{{#cargo_query:tables=RefsExt2|where = _pageName = '{{#arrayindex: val | 0}}'|limit=1500|default=|fields=ItemType}}| |{{#cargo_query:tables=BibEntryCargo|where = _pageName = '{{#arrayindex: val | 0}}'|limit=1500|default=|fields=_pageName, BibType,Title, Editors, DATE_FORMAT(Year,"%Y")=var1, Journal, Booktitle, Volume,Pages, URL, DOI, ISBN, Note, Firstname|format=template|template=Test6a}}|{{#cargo_query:tables=RefsExt|where = _pageName = '{{#arrayindex: val | 0}}'|limit=1500|default=|fields=_ID, Lastname, Firstname|order by=_ID ASC |format=template|template=Test4a}}{{#cargo_query:tables=RefsExt2|where = _pageName = '{{#arrayindex: val | 0}}'|limit=1500|default=|fields=_pageName, ItemType, Title , PublicationTitle, Booktitle, JournalAbbreviation, Volume, Issue, Url, DOI, Pagenumbers, Publicationdate, AccessDate |format=template|template=Test5a}} }}</td><!--<td>{{#cargo_query:tables=RefsInt2|where = _pageName = '{{#arrayindex: val | 0}}'|limit=1500|default=|fields= PublicationMultipleModelsCargo|format=template|template=Test7a}}</td>--><td>{{#cargo_query:tables=RefsInt1|where = _pageName = '{{#arrayindex: val | 0}}'|limit= | }}{{#ifeq:{{#cargo_query:tables=RefsExt2|where = _pageName = '{{#arrayindex: val | 0}}'|limit=1500|default=|fields=ItemType}}| |{{#cargo_query:tables=BibEntryCargo|where = _pageName = '{{#arrayindex: val | 0}}'|limit=1500|default=|fields=_pageName, BibType,Title, Editors, DATE_FORMAT(Year,"%Y")=var1, Journal, Booktitle, Volume,Pages, URL, DOI, ISBN, Note, Firstname|format=template|template=Test6a}}|{{#cargo_query:tables=RefsExt|where = _pageName = '{{#arrayindex: val | 0}}'|limit=1500|default=|fields=_ID, Lastname, Firstname|order by=_ID ASC |format=template|template=Test4a}}{{#cargo_query:tables=RefsExt2|where = _pageName = '{{#arrayindex: val | 0}}'|limit=1500|default=|fields=_pageName, ItemType, Title , PublicationTitle, Booktitle, JournalAbbreviation, Volume, Issue, Url, DOI, Pagenumbers, Publicationdate, AccessDate |format=template|template=Test5a}} }}</td><!--<td>{{#cargo_query:tables=RefsInt2|where = _pageName = '{{#arrayindex: val | 0}}'|limit=1500|default=|fields= PublicationMultipleModelsCargo|format=template|template=Test7a}}</td>--><td>{{#cargo_query:tables=RefsInt1|where = _pageName = '{{#arrayindex: val | 0}}'|limit=2500|default=|fields= PublicationWhatKindOf, PublicationClusterID, PublicationCitationsNr, MS_PublicationClusterID|format=template|template=Test8a}}</td> | ||
}}</table></div></div> | }}</table></div></div> | ||
</div> | </div> | ||
