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:table=CreatureFactions,GeneralData,Characters|join on=CreatureFactions._pageName=GeneralData._pageName, Characters._pageName =CreatureFactions._pageName|fields=CONCAT(GeneralData.PlainName),Level|where=Faction="{{{1|{{#titleparts:{{PAGENAME}}}}}}}" AND CreatureFactions._pageNamespace ='0'|order by=Level, PlainName|group by=PlainName|format=template|template=favilink ul query with levels}}<noinclude>[[Category:Query Templates]]</noinclude>
{{#cargo_query:table=CreatureFactions,GeneralData,Characters|join on=CreatureFactions._pageName=GeneralData._pageName, Characters._pageName =CreatureFactions._pageName|fields=CONCAT(GeneralData.PlainName),Level|where=Faction="{{{1|{{#titleparts:{{PAGENAME}}}}}}}" AND CreatureFactions._pageNamespace ='0' AND GeneralData.DisplayChar <> ''|order by=Level, PlainName|group by=PlainName|format=template|template=favilink ul query with levels}}<noinclude>[[Category:Query Templates]]</noinclude>