Template:Implode characters with location: Difference between revisions

@@ Line 1: / Line 1: @@
-<includeonly><table class="nowraplinks navbox-subgroup" style="border-spacing:0">
+<includeonly>{{#ifexpr: {{#cargo_query:
-{{Implode characters with location/render||#userparam={{{1|}}},{{{2|}}},{{{3|}}}}}
+tables=characters
-{{#ask: [[Category:Locations]]
+|fields=COUNT(*)
- |format=template
+|where=characters.alignment = "{{{1}}}" and characters.status = "{{{3}}}" and characters.affiliation HOLDS "{{{2}}}" and characters.location = "{{{4}}}"
- |template=Implode characters with location/render
+|format=list
- |userparam={{{1|}}},{{{2|}}},{{{3|}}}
+}} | <table class="nowraplinks navbox-subgroup" style="border-spacing:0">{{#cargo_query:
- |link=none
+tables=characters
-}}
+|fields=characters._pageName
-</table></includeonly>
+|where=characters.alignment = "{{{1}}}" and characters.status = "{{{3}}}" and characters.affiliation HOLDS "{{{2}}}" and characters.location = "{{{4}}}"
+|order by=characters.leader DESC, characters.name ASC
+|format=ul
+}}</table> | }}</includeonly>

Latest revision as of 18:08, 27 July 2024