Template:In faction: Difference between revisions

Template:In faction (view source)

36 bytes added , 00:02, 19 August 2019

added group by clause to avoid doubles

8,756

edits

Revision as of 01:40, 18 August 2019 (view source) Teamtoto (talk \| contribs) mNo edit summary ← Older edit		Revision as of 00:02, 19 August 2019 (view source) Teamtoto (talk \| contribs) (added group by clause to avoid doubles) Newer edit →
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>