User:Nighty/sandbox3: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
(Created page with " Total maps: {{#cargo_query: | table = items | fields = COUNT(DISTINCT items.name) | where = items.class = "Maps" AND items.name NOT LIKE "%Shaped%" AND items.drop_enabled=true }} {{#cargo_query: |table = items, maps |join on = items._pageName=maps._pageName |fields = items.name, maps.area_level, maps.tier, items.rarity, items._pageName, items.tags, items.drop_enabled, maps.area_id, maps.series |where = items.class = "Maps" AND items.name NOT LIKE "%Shaped%" AND items...")
 
(Replaced content with " {{#cargo_query: |table = areas |fields = |limit = 1 |format = table }}")
Tag: Replaced
Line 1: Line 1:
Total maps:
{{#cargo_query:
| table = items
| fields = COUNT(DISTINCT items.name)
| where = items.class = "Maps" AND items.name NOT LIKE "%Shaped%" AND items.drop_enabled=true
}}


{{#cargo_query:
{{#cargo_query:
|table = items, maps
|table = areas
|join on =  items._pageName=maps._pageName
|fields =  
|fields = items.name, maps.area_level, maps.tier, items.rarity, items._pageName, items.tags, items.drop_enabled, maps.area_id, maps.series
|limit = 1
|where = items.class = "Maps" AND items.name NOT LIKE "%Shaped%" AND items.drop_enabled = true
|format = table
|limit = 5000
}}
 
{{#invoke: Item table
|item_table
|q_where = items.class = "Maps" AND maps.tier >0 AND items.drop_enabled=true
|map_level = 1
|map_tier = 1
|boss_name = 0  <!-- not pretty -->
|sextant = 0  <!-- caution! seems to be a large query -->
|q_limit = 100
}}
}}

Revision as of 10:48, 9 December 2022

_pageName
Area:1~1~1

More...

Retrieved from "https://www.poewiki.net/index.php?title=User:Nighty/sandbox3&oldid=1320300"