User:Nighty/sandbox5: Difference between revisions

Latest revision as of 08:00, 18 January 2023

Map query test #2

name	_pageName	tier	area level	guild character
Scriptorium Map	Map:Scriptorium Map (Atlas of Worlds)	13	80	y
	Map:Scriptorium Map (Betrayal)	9	76	‡
	Map:Scriptorium Map (Blight)	9	76
	Map:Scriptorium Map (Crucible)	1	68
	Map:Scriptorium Map (Delirium)	5	72
	Map:Scriptorium Map (Expedition)	10	77
	Map:Scriptorium Map (Harvest)	5	72
	Map:Scriptorium Map (Heist)	6	73
	Map:Scriptorium Map (Legion)	8	75
	Map:Scriptorium Map (Metamorph)	5	72
	Map:Scriptorium Map (Ritual)	10	77
	Map:Scriptorium Map (Synthesis)	10	77
	Map:Scriptorium Map (War for the Atlas)	9	76

@@ Line 3: / Line 3: @@
 <section end="chapter1" />
-'''Total maps''':
 {{#cargo_query:
-| table = items
+ tables=maps, items
-| fields = COUNT(DISTINCT items.name)
+|fields=items.name,maps._pageName, maps.tier, maps.area_level, maps.guild_character, maps.guild_character
-| where = items.class_id = "Map"
+|where=maps._pageName like "%iptor%"
+|join on=maps._pageName = items._pageName
-}}
+|order by=maps._pageName ASC
-<p>
+|limit=20
+|offset=0
-{{#invoke: Item table
+|format=table
-|item_table
+|merge similar cells=yes
-|q_where = items.class_id = "Map"
-|group by = items.name
-|map_level = 1
-|map_tier = 1
-|boss_name = 1
-|map_guild_character = 1
-|responsive = 1
 }}