Template:BTD6 mk info: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 25: | Line 25: | ||
|colspan=2|{{#if:{{{prerequisites|}}}|{{#cargo_query:tables = btd6_mk=main_mk, btd6_mk__prerequisites, btd6_mk=prerequisites_mk | |colspan=2|{{#if:{{{prerequisites|}}}|{{#cargo_query:tables = btd6_mk=main_mk, btd6_mk__prerequisites, btd6_mk=prerequisites_mk | ||
|join on = main_mk._ID=btd6_mk__prerequisites._RowID, btd6_mk__prerequisites._value=prerequisites_mk.name | |join on = main_mk._ID=btd6_mk__prerequisites._RowID, btd6_mk__prerequisites._value=prerequisites_mk.name | ||
|fields=CONCAT("[[", prerequisites_mk._pageName, "|", prerequisites_mk.name, "]]") | |fields=CONCAT("[[", prerequisites_mk._pageName, "|", prerequisites_mk.name, "]]") = text | ||
|where=main_mk.name = "{{{name|x}}}" | |where=main_mk.name = "{{{name|x}}}" | ||
|format=ul | |format=ul | ||
| Line 32: | Line 32: | ||
!Prerequisite of | !Prerequisite of | ||
|colspan=2|{{#cargo_query:table=btd6_mk | |colspan=2|{{#cargo_query:table=btd6_mk | ||
|fields=CONCAT("[[", _pageName, "|", name, "]]") | |fields=CONCAT("[[", _pageName, "|", name, "]]") = text | ||
|where=prerequisites HOLDS "{{{name|x}}}" | |where=prerequisites HOLDS "{{{name|x}}}" | ||
|format=ul | |format=ul | ||