Template:In faction: Difference between revisions

Template:In faction (view source)

111 bytes removed , 00:59, 27 January 2020

update query to fix bug if two creatures have the same plainname

8,756

edits

@@ Line 1: / Line 1: @@
 ==Creatures in the {{{1|{{#titleparts:{{PAGENAME}}}}}}} Faction==
-<ul><li>{{#invoke:CargoQuery|main
+{{#cargo_query:tables=CreatureFactions=CF,GeneralData=GD,Characters=C
-|q?tables=CreatureFactions,GeneralData,Characters
+|join on = CF.JoinKey=GD.JoinKey, C.JoinKey=CF.JoinKey
-|q?join=CreatureFactions._pageName=GeneralData._pageName, Characters._pageName =CreatureFactions._pageName
+|fields=CONCAT('{{((}}favilink page{{!}}' , GD._pageName, '{{))}}'), Level
-|q?fields=CONCAT(GeneralData.PlainName)=Page,Level
+|where=Faction="{{{1|{{#titleparts:{{PAGENAME}}}}}}}" AND CF._pageNamespace='0' AND GD.DisplayChar <> ''
-|q?where=Faction="{{{1|{{#titleparts:{{PAGENAME}}}}}}}" AND CreatureFactions._pageNamespace ='0' AND GeneralData.DisplayChar <> ''
+|order by=Level, PlainName
-|q?orderBy=Level, PlainName
+|group by = C._pageName
-|q?groupBy=Characters._pageName
+|format = ul
-|template=favilink ul query with levels
+|columns = 2}}
-|delimiter=<li>}}</ul><noinclude>[[Category:Query Templates]]</noinclude>
+<noinclude>[[Category:Query Templates]]</noinclude>