Template:BATTD upgrade info: Difference between revisions

@@ Line 43: / Line 43: @@
 }}}}</ul>
 |-
-!Previous upgrade(s)
+!Prerequisites
-|colspan="2"|{{#cargo_query:table=battd_upgrades
+|colspan="2"|{{#cargo_query:tables = battd_upgrades=main_mk, battd_upgrades__previous, battd_upgrades=prerequisites_mk
-|fields=CONCAT("[[", _pageName, "|", name, "]]")
+|join on = main_mk._ID=battd_upgrades__previous._RowID, battd_upgrades__previous._value=prerequisites_mk.id
-|where=previous HOLDS "{{{id|x}}}"
+|fields=COALESCE(CONCAT("[[", prerequisites_mk._pageName, "|", prerequisites_mk.name, "]]"), "None")
+|where=main_mk.id = "{{{id|x}}}"
 |format=ul
 |default=―
 }}
 |-
-!Next upgrade(s)
+!Prerequisite of
-|colspan="2"|{{#cargo_query:tables = battd_upgrades=main_mk, battd_upgrades__previous, battd_upgrades=prerequisites_mk
+|colspan="2"|{{#cargo_query:table=battd_upgrades
-|join on = main_mk._ID=battd_upgrades__previous._RowID, battd_upgrades__previous._value=prerequisites_mk.id
+|fields=CONCAT("[[", _pageName, "|", name, "]]")
-|fields=COALESCE(CONCAT("[[", prerequisites_mk._pageName, "|", prerequisites_mk.name, "]]"), "None")
+|where=previous HOLDS "{{{id|x}}}"
-|where=main_mk.id = "{{{id|x}}}"
 |format=ul
 |default=―