Template:In faction: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
(added group by clause to avoid doubles) |
||
Line 1: | Line 1: | ||
==Creatures in the {{{1|{{PAGENAME}}}}} Faction== | ==Creatures in the {{{1|{{PAGENAME}}}}} Faction== | ||
{{#cargo_query:table=CreatureFactions,GeneralData,Characters|join on=CreatureFactions._pageName=GeneralData._pageName, Characters._pageName =CreatureFactions._pageName|fields=CONCAT('[[File:',GeneralData.Image,'|16px]] [[',CreatureFactions._pageName,']] (level ',Level,')')|format=ul|where=Faction="{{{1|{{#titleparts:{{PAGENAME}}}}}}}" AND CreatureFactions._pageNamespace ='0'|order by=Level, CreatureFactions._pageName}}<noinclude>[[Category:Query Templates]]</noinclude> | {{#cargo_query:table=CreatureFactions,GeneralData,Characters|join on=CreatureFactions._pageName=GeneralData._pageName, Characters._pageName =CreatureFactions._pageName|fields=CONCAT('[[File:',GeneralData.Image,'|16px]] [[',CreatureFactions._pageName,']] (level ',Level,')')|format=ul|where=Faction="{{{1|{{#titleparts:{{PAGENAME}}}}}}}" AND CreatureFactions._pageNamespace ='0'|order by=Level, CreatureFactions._pageName|group by=CreatureFactions._pageName}}<noinclude>[[Category:Query Templates]]</noinclude> |
Revision as of 00:02, 19 August 2019
Creatures in the In faction Faction
No results