Template:B1 level list by object: Difference between revisions

first set of templates to test functionality
rest of the levels
Line 27: Line 27:
|where={{{1|bloon}}}_F > 0 AND level_EMB IS NOT NULL
|where={{{1|bloon}}}_F > 0 AND level_EMB IS NOT NULL
|order by=level_EMB
|order by=level_EMB
}}
</div>
<h{{{header level|3}}}>''[[Bloons Player Pack 1|Player Pack 1]]''</h{{{header level|3}}}>
<div class="center-col-1 center-col-3">
{{#cargo_query:table=b1_levels
|fields=level_PP1 = №,
CONCAT("[[", _pageName, "|", name_F, "]]") = Level,
{{{1|bloon}}}_F = Count
|where={{{1|bloon}}}_F > 0 AND level_PP1 IS NOT NULL
|order by=level_PP1
}}
</div>
<h{{{header level|3}}}>''[[Bloons Player Pack 2|Player Pack 2]]''</h{{{header level|3}}}>
<div class="center-col-1 center-col-3">
{{#cargo_query:table=b1_levels
|fields=level_PP2 = №,
CONCAT("[[", _pageName, "|", name_F, "]]") = Level,
{{{1|bloon}}}_F = Count
|where={{{1|bloon}}}_F > 0 AND level_PP2 IS NOT NULL
|order by=level_PP2
}}
</div>
<h{{{header level|3}}}>''[[Bloons Player Pack 3|Player Pack 3]]''</h{{{header level|3}}}>
<div class="center-col-1 center-col-3">
{{#cargo_query:table=b1_levels
|fields=level_PP3 = №,
CONCAT("[[", _pageName, "|", name_F, "]]") = Level,
{{{1|bloon}}}_F = Count
|where={{{1|bloon}}}_F > 0 AND level_PP3 IS NOT NULL
|order by=level_PP3
}}
</div>
<h{{{header level|3}}}>''[[Bloons Player Pack 4|Player Pack 4]]''</h{{{header level|3}}}>
<div class="center-col-1 center-col-3">
{{#cargo_query:table=b1_levels
|fields=level_PP4 = №,
CONCAT("[[", _pageName, "|", name_F, "]]") = Level,
{{{1|bloon}}}_F = Count
|where={{{1|bloon}}}_F > 0 AND level_PP4 IS NOT NULL
|order by=level_PP4
}}
</div>
<h{{{header level|3}}}>''[[Bloons Player Pack 5|Player Pack 5]]''</h{{{header level|3}}}>
<div class="center-col-1 center-col-3">
{{#cargo_query:table=b1_levels
|fields=level_PP5 = №,
CONCAT("[[", _pageName, "|", name_F, "]]") = Level,
{{{1|bloon}}}_F = Count
|where={{{1|bloon}}}_F > 0 AND level_PP5 IS NOT NULL
|order by=level_PP5
}}
</div>
<h{{{header level|3}}}>''[[Bloons Insanity Pack|Insanity Pack]]''</h{{{header level|3}}}>
<div class="center-col-1 center-col-3">
{{#cargo_query:table=b1_levels
|fields=level_BIP = №,
CONCAT("[[", _pageName, "|", name_F, "]]") = Level,
{{{1|bloon}}}_F = Count
|where={{{1|bloon}}}_F > 0 AND level_BIP IS NOT NULL
|order by=level_BIP
}}
</div>
<h{{{header level|3}}}>''[[Bloons Junior|Junior]]''</h{{{header level|3}}}>
<div class="center-col-1 center-col-3">
{{#cargo_query:table=b1_levels
|fields=level_J = №,
CONCAT("[[", _pageName, "|", name_F, "]]") = Level,
{{{1|bloon}}}_F = Count
|where={{{1|bloon}}}_F > 0 AND level_J IS NOT NULL
|order by=level_J
}}
</div>
<h{{{header level|3}}}>[[Bloons (iOS)|iOS version]]</h{{{header level|3}}}>
<div class="center-col-1 center-col-3">
{{#cargo_query:table=b1_levels
|fields=level_M = №,
CONCAT("[[", _pageName, "|", name_M, "]]") = Level,
{{{1|bloon}}}_M = Count
|where={{{1|bloon}}}_M > 0 AND level_M IS NOT NULL
|order by=level_M
}}
</div>
<h{{{header level|3}}}>''[[Bloons Festive Fun|Festive Fun]]''</h{{{header level|3}}}>
<div class="center-col-1 center-col-3">
{{#cargo_query:table=b1_levels
|fields=level_FF = №,
CONCAT("[[", _pageName, "|", name_M, "]]") = Level,
{{{1|bloon}}}_M = Count
|where={{{1|bloon}}}_M > 0 AND level_FF IS NOT NULL
|order by=level_FF
}}
}}
</div></includeonly><noinclude>{{/doc}}</noinclude>
</div></includeonly><noinclude>{{/doc}}</noinclude>