Template:Generic cargo query: Difference between revisions

mNo edit summary
mNo edit summary
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
<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}}}">}}
<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:tables={{{tables|{{{table|}}}}}}
{{#cargo_query:tables={{{tables|{{{table|}}}}}}
|fields=
|fields=
CONCAT("[[File:", {{{image field|image}}}, "|{{{image size|50x50px}}}|link=", _pageName, "|", {{{name field|name}}}, "]]") = Icon,
CONCAT("[[File:", {{{image field|image}}}, "|{{{image size|50x50px}}}|link=", _pageName, "|", {{{name field|name}}}, "]]") = Icon,
{{#if:{{{no description|}}}|CONCAT("[[", _pageName, "|", {{{name field|name}}}, "]]") = Name|CONCAT("'''[[", _pageName, "|", {{{name field|name}}}, "]]'''<br>", {{{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:{{{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|}}}