Template:In faction: Difference between revisions

3 bytes removed ,  22:29, 19 July 2020
m
no edit summary
mNo edit summary
mNo edit summary
Line 2: Line 2:
{{#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.JoinKey=GD.JoinKey, C.JoinKey=CF.JoinKey
|fields=CONCAT("{{((}}favilink page{{!}}" , GD._pageName, "{{))}}"), 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 <> ''
|order by=Level, PlainName
|order by=Level, PlainName