Template:B2 level list by object: Difference between revisions

No edit summary
mNo edit summary
Line 2: Line 2:
<div class="center-col-2">
<div class="center-col-2">
{{#cargo_query:table=b2_levels
{{#cargo_query:table=b2_levels
|fields=CONCAT(level_F, ". [[", _pageName, "|", name_F, "]]") = Level,
|fields=level_F,
CONCAT("[[", _pageName, "|", name_F, "]]") = Level,
{{{1|bloon}}}_F = Count
{{{1|bloon}}}_F = Count
|where={{{1|bloon}}}_F > 0 AND level_F IS NOT NULL
|where={{{1|bloon}}}_F > 0 AND level_F IS NOT NULL
Line 11: Line 12:
<div class="center-col-2">
<div class="center-col-2">
{{#cargo_query:table=b2_levels
{{#cargo_query:table=b2_levels
|fields=CONCAT(level_CE, ". [[", _pageName, "|", name_F, "]]") = Level,
|fields=level_CE,
CONCAT("[[", _pageName, "|", name_F, "]]") = Level,
{{{1|bloon}}}_F = Count
{{{1|bloon}}}_F = Count
|where={{{1|bloon}}}_F > 0 AND level_CE IS NOT NULL
|where={{{1|bloon}}}_F > 0 AND level_CE IS NOT NULL
Line 20: Line 22:
<div class="center-col-2">
<div class="center-col-2">
{{#cargo_query:table=b2_levels
{{#cargo_query:table=b2_levels
|fields=CONCAT(level_SF, ". [[", _pageName, "|", name_F, "]]") = Level,
|fields=level_SF,
CONCAT("[[", _pageName, "|", name_F, "]]") = Level,
{{{1|bloon}}}_F = Count
{{{1|bloon}}}_F = Count
|where={{{1|bloon}}}_F > 0 AND level_SF IS NOT NULL
|where={{{1|bloon}}}_F > 0 AND level_SF IS NOT NULL
Line 29: Line 32:
<div class="center-col-2">
<div class="center-col-2">
{{#cargo_query:table=b2_levels
{{#cargo_query:table=b2_levels
|fields=CONCAT(level_M, ". [[", _pageName, "|", name_M, "]]") = Level,
|fields=level_M,
CONCAT("[[", _pageName, "|", name_M, "]]") = Level,
{{{1|bloon}}}_M = Count
{{{1|bloon}}}_M = Count
|where={{{1|bloon}}}_M > 0 AND level_M IS NOT NULL
|where={{{1|bloon}}}_M > 0 AND level_M IS NOT NULL