Template:In faction: Difference between revisions

No change in size ,  22:26, 19 July 2020
m
no edit summary
(changed columns back to 1)
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 page{{!}}" , GD._pageName, "{{))}}"), 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