Template:Generic cargo query: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| (16 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly><div class="center-col-1 center-col-3 center-col-4 center-col-5 center-col-6"> | <includeonly>{{#if:{{{col align left|}}}|<div class="center-col-1">|<div class="center-col-1 center-col-3 center-col-4 center-col-5 center-col-6 center-col-7 center-col-8 center-col-9 center-col-10">}} | ||
{{#cargo_query: | {{#cargo_query:tables={{{tables|{{{table|}}}}}} | ||
|fields= | |fields= | ||
CONCAT("[[File:", {{{image field|image}}}, "|{{{image size|50x50px}}}|link=", _pageName, "|", name, "]]") = Icon, | CONCAT("[[File:", {{{image field|image}}}, "|{{{image size|50x50px}}}|link=", _pageName, "|", {{{name field|name}}}, "]]") = Icon, | ||
{{#if:{{{no description|}}}|CONCAT("[[", _pageName, "|", name, "]]") = Name|CONCAT("'''[[", _pageName, "|", name, "]]'''<br>", {{{description field|description}}}) = | {{#if:{{{no description|}}}|CONCAT("[[", _pageName, "|", {{{name field|name}}}, "]]") = Name|CONCAT("'''[[", _pageName, "|", {{{name field|name}}}, "]]'''<br>", COALESCE({{{description field|description}}}, "")) = Text}}{{#if:{{{extra col 1|}}}|, {{{extra col 1}}}}}{{#if:{{{extra col 2|}}}|, {{{extra col 2}}}}}{{#if:{{{extra col 3|}}}|, {{{extra col 3}}}}}{{#if:{{{extra col 4|}}}|, {{{extra col 4}}}}}{{#if:{{{extra col 5|}}}|, {{{extra col 5}}}}}{{#if:{{{extra col 6|}}}|, {{{extra col 6}}}}}{{#if:{{{extra col 7|}}}|, {{{extra col 7}}}}}{{#if:{{{extra col 8|}}}|, {{{extra col 8}}}}} | ||
|where ={{{where|}}} | |where ={{{where|}}} | ||
|order by={{{order by|}}} | |order by={{{order by|}}} | ||
|group by={{{group by|}}} | |||
|join on ={{{join on|}}} | |||
|limit ={{{limit|}}} | |limit ={{{limit|}}} | ||
|format=table | |format=table | ||
}}</div></includeonly><noinclude>{{/doc}}</noinclude> | }}</div></includeonly><noinclude>{{/doc}}</noinclude> | ||