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==
-{{#cargo_query:tables=CreatureFactions=CF,GeneralData=GD,Characters=C
+{{#invoke:cargoQuery|main
-|join on = CF.JoinKey=GD.JoinKey, C.JoinKey=CF.JoinKey
+|tables=CreatureFactions=CF,GeneralData=GD,Characters=C
-|fields=CONCAT('{{((}}favilink page{{!}}' , GD._pageName, '{{))}}'), Level
+|join on = CF.ObjectID=GD.ObjectID, C.ObjectID=CF.ObjectID
-|where=Faction="{{{1|{{#titleparts:{{PAGENAME}}}}}}}" AND CF._pageNamespace='0' AND GD.DisplayChar <> ''
+|fields={{favilink format args}}, Level
+|where=Faction="{{{1|{{#titleparts:{{PAGENAME}}}}}}}" AND GD._pageNamespace='0' AND GD.DisplayChar <> '' AND GD.Categories <> 'Pets'
 |order by=Level, PlainName
-|group by = C._pageName
+|group by = GD.ObjectID
-|format = ul
+|columns = 1
-|columns = 2}}
+| intro = <ul>
-<noinclude>[[Category:Query Templates]]</noinclude>
+| outro = </ul>
+| template = favilink ul query with levels
+}}<noinclude>
+See also [[Template:In faction by pagename]].
+[[Category:Query Templates]]</noinclude>