Template:BTD6 hero list by insta: Difference between revisions

mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly><div class="center-col-2 center-col-3">{{#cargo_compound_query:
<includeonly><div class="center-col-2 center-col-3">{{#cargo_compound_query:
table=btd6_heroes
tables=btd6_heroes
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|", name, "]] [[", _pageName, "|", name, "]]") = Hero,  
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|", name, "]] [[", _pageName, "|", name, "]]") = Hero,  
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_1, ",", rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1,
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_1, ",", rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1,
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_2, ",", rl_tower_2_upgrades, "}}"), "—") = Insta Monkey 2
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_2, ",", rl_tower_2_upgrades, "}}"), "—") = Insta Monkey 2
|table=btd6_hero_skins
;where=rl_tower_1="{{{1|}}}" OR rl_tower_2="{{{1|}}}"
 
|tables=btd6_hero_skins
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|", name, "]] [[", _pageName, "|", name, "]]") = Hero,  
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|", name, "]] [[", _pageName, "|", name, "]]") = Hero,  
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_1, ",", rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1,
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_1, ",", rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1,