Template:In faction: Difference between revisions

m
no edit summary
mNo edit summary
mNo edit summary
Line 1: Line 1:
==Creatures in the {{{1|{{#titleparts:{{PAGENAME}}}}}}} Faction==
==Creatures in the {{{1|{{#titleparts:{{PAGENAME}}}}}}} Faction==
{{#cargo_query:tables=CreatureFactions=CF,GeneralData=GD,Characters=C
{{#cargo_query:tables=CreatureFactions=CF,GeneralData=GD,Characters=C
|join on = CF.JoinKey=GD.JoinKey, C.JoinKey=CF.JoinKey
|join on = CF.ObjectID=GD.ObjectID, C.ObjectID=CF.ObjectID
|fields=CONCAT("{{((}}favilink id{{!}}" , GD.ObjectID, "{{))}}"), Level
|fields=CONCAT("{{((}}favilink id{{!}}" , GD.ObjectID, "{{))}}"), Level
|where=Faction="{{{1|{{#titleparts:{{PAGENAME}}}}}}}" AND CF._pageNamespace='0' AND GD.DisplayChar <> ''
|where=Faction="{{{1|{{#titleparts:{{PAGENAME}}}}}}}" AND CF._pageNamespace='0' AND GD.DisplayChar <> ''