Template:BATTD upgrade info: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 26: | Line 26: | ||
|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=CONCAT("[[", prerequisites_mk._pageName, "|", prerequisites_mk.name, "]]") = text | |fields=CONCAT("[[", prerequisites_mk._pageName, "|", prerequisites_mk.name, "]]") = text | ||
|where=main_mk.id = "{{{id|x}}}" | |where=main_mk.id = "{{{id|x}}}" AND NOT unused | ||
|format=ul | |format=ul | ||
|default=― | |default=― | ||
| Line 34: | Line 34: | ||
|colspan="2"|{{#cargo_query:table=battd_upgrades | |colspan="2"|{{#cargo_query:table=battd_upgrades | ||
|fields=CONCAT("[[", _pageName, "|", name, "]]") = text | |fields=CONCAT("[[", _pageName, "|", name, "]]") = text | ||
|where=previous HOLDS "{{{id|x}}}" | |where=previous HOLDS "{{{id|x}}}" AND NOT unused | ||
|format=ul | |format=ul | ||
|default=― | |default=― | ||