Template:BTD6 mk info: Difference between revisions

Undo revision 33611 by Hemidemisemipresent (talk)
Tag: Undo
experimental 2
Line 23: Line 23:
{|class="info-sub"
{|class="info-sub"
!Prerequisites
!Prerequisites
|colspan=2|{{#cargo_query:tables=btd6_mk,btd6_mk__prerequisites
|colspan=2|{{#cargo_query:tables = btd6_mk=main_mk, btd6_mk__prerequisites, btd6_mk=prerequisites_mk
|join on=btd6_mk._ID = btd6_mk__prerequisites._RowID
|join on = main_mk._ID=btd6_mk__prerequisites._RowID, btd6_mk__prerequisites.value=prerequisites_mk.name
|fields=CONCAT(btd6_mk__prerequisites._value)
|fields=CONCAT("[[", prerequisites_mk._pageName, "|", prerequisites_mk.name, "]]")
|where=btd6_mk.name = "{{{name|x}}}"
|where=btd6_mk.name = "{{{name|x}}}"
|format=ul
|format=ul