Template:BATTD upgrade info: Difference between revisions

mNo edit summary
mNo edit summary
Line 23: Line 23:
|-
|-
!Prerequisites
!Prerequisites
|colspan="2"|{{#if:{{{previous|}}}|{{#cargo_query:tables = battd_upgrades=main_mk, battd_upgrades__previous, battd_upgrades=prerequisites_mk
|colspan="2"|{{#if:{{{previous|}}}|{{#cargo_query:tables = battd_upgrades=main_table, battd_upgrades__previous, battd_upgrades=prerequisites_mk
|join on = main_mk._ID=battd_upgrades__previous._RowID, battd_upgrades__previous._value=prerequisites_mk.id
|join on = main_table._ID=battd_upgrades__previous._RowID, battd_upgrades__previous._value=prerequisites_mk.id
|fields=CONCAT("[[", prerequisites_mk._pageName, "|", prerequisites_mk.name, "]]") = text
|fields=CONCAT("[[", prerequisites_mk._pageName, "|", prerequisites_mk.name, "]]") = text
|where=main_mk.id = "{{{id|x}}}" AND NOT unused
|where=main_table.id = "{{{id|x}}}" AND NOT main_table.unused
|format=ul
|format=ul
|default=―
|default=―