Template:In faction: Difference between revisions

Latest revision as of 20:00, 6 April 2022

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