Template:BATTD upgrade info: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 46: | Line 46: | ||
|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_mk, 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_mk._ID=battd_upgrades__previous._RowID, battd_upgrades__previous._value=prerequisites_mk.id | ||
|fields= | |fields=CONCAT("[[", prerequisites_mk._pageName, "|", prerequisites_mk.name, "]]") = text | ||
|where=main_mk.id = "{{{id|x}}}" | |where=main_mk.id = "{{{id|x}}}" | ||
|format=ul | |format=ul | ||
| Line 54: | Line 54: | ||
!Prerequisite of | !Prerequisite of | ||
|colspan="2"|{{#cargo_query:table=battd_upgrades | |colspan="2"|{{#cargo_query:table=battd_upgrades | ||
|fields=CONCAT("[[", _pageName, "|", name, "]]") | |fields=CONCAT("[[", _pageName, "|", name, "]]") = text | ||
|where=previous HOLDS "{{{id|x}}}" | |where=previous HOLDS "{{{id|x}}}" | ||
|format=ul | |format=ul | ||