Template:Map tier table: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
>Game widow
No edit summary
>Illviljan
m (cargo queries)
Line 4: Line 4:
|-
|-
| Low tier maps   
| Low tier maps   
|| {{#ask:
||  
[[Has item class::Maps]]
{{#cargo_query: table=items, maps
[[Has tags::low_tier_map]]
|join on items._pageName=maps._pageName
[[Is drop enabled::true]]
|fields = MIN(maps.tier)
|?Has map tier=
|where = items.class="Maps" AND items.tags HOLDS "low_tier_map" AND items.drop_enabled=true
|mainlabel=-
}} - {{#cargo_query: table=items, maps
  |searchlabel=
|join on items._pageName=maps._pageName
|link=none
|fields = MAX(maps.tier)
|format=
|where = items.class="Maps" AND items.tags HOLDS "low_tier_map" AND items.drop_enabled=true
|limit=1
}}
|sort=Has map tier
 
|order=asc
|| {{#cargo_query: table=items, maps
}} - {{#ask:
|join on items._pageName=maps._pageName
[[Has item class::Maps]]
|fields = MIN(maps.area_level)
[[Has tags::low_tier_map]]
|where = items.class="Maps" AND items.tags HOLDS "low_tier_map" AND items.drop_enabled=true
[[Is drop enabled::true]]
}} - {{#cargo_query: table=items, maps
|?Has map tier=
|join on items._pageName=maps._pageName
|mainlabel=-
|fields = MAX(maps.area_level)
  |searchlabel=
|where = items.class="Maps" AND items.tags HOLDS "low_tier_map" AND items.drop_enabled=true
|link=none
|format=
|limit=1
|sort=Has map tier
|order=desc
}}
|| {{#ask:
[[Has item class::Maps]]
[[Has tags::low_tier_map]]
[[Is drop enabled::true]]
|?Has map area level=
|mainlabel=-
  |searchlabel=
|link=none
|format=
|limit=1
|sort=Has map tier
|order=asc
}} - {{#ask:
[[Has item class::Maps]]
[[Has tags::low_tier_map]]
[[Is drop enabled::true]]
|?Has map area level=
|mainlabel=-
  |searchlabel=
|link=none
|format=
|limit=1
|sort=Has map tier
|order=desc
}}
}}


|-
|-
| Mid tier maps   
| Mid tier maps   
|| {{#ask:
||{{#cargo_query: table=items, maps
[[Has item class::Maps]]
|join on items._pageName=maps._pageName
[[Has tags::mid_tier_map]]
|fields = MIN(maps.tier)
[[Is drop enabled::true]]
|where = items.class="Maps" AND items.tags HOLDS "mid_tier_map" AND items.drop_enabled=true
|?Has map tier=
}} - {{#cargo_query: table=items, maps
|mainlabel=-
|join on items._pageName=maps._pageName
  |searchlabel=
|fields = MAX(maps.tier)
|link=none
|where = items.class="Maps" AND items.tags HOLDS "mid_tier_map" AND items.drop_enabled=true
|format=
}}
|limit=1
 
|sort=Has map tier
|| {{#cargo_query: table=items, maps
|order=asc
|join on items._pageName=maps._pageName
}} - {{#ask:
|fields = MIN(maps.area_level)
[[Has item class::Maps]]
|where = items.class="Maps" AND items.tags HOLDS "mid_tier_map" AND items.drop_enabled=true
[[Has tags::mid_tier_map]]
}} - {{#cargo_query: table=items, maps
[[Is drop enabled::true]]
|join on items._pageName=maps._pageName
|?Has map tier=
|fields = MAX(maps.area_level)
|mainlabel=-
|where = items.class="Maps" AND items.tags HOLDS "mid_tier_map" AND items.drop_enabled=true
  |searchlabel=
|link=none
|format=
|limit=1
|sort=Has map tier
|order=desc
}}
|| {{#ask:
[[Has item class::Maps]]
[[Has tags::mid_tier_map]]
[[Is drop enabled::true]]
|?Has map area level=
|mainlabel=-
  |searchlabel=
|link=none
|format=
|limit=1
|sort=Has map area level
|order=asc
}} - {{#ask:
[[Has item class::Maps]]
[[Has tags::mid_tier_map]]
[[Is drop enabled::true]]
|?Has map area level=
|mainlabel=-
  |searchlabel=
|link=none
|format=
|limit=1
|sort=Has map area level
|order=desc
}}
}}


|-
|-
| Top tier maps  
| Top tier maps  
|| {{#ask:
||  
[[Has item class::Maps]]
{{#cargo_query: table=items, maps
[[Has tags::top_tier_map]]
|join on items._pageName=maps._pageName
[[Is drop enabled::true]]
|fields = MIN(maps.tier)
|?Has map tier=
|where = items.class="Maps" AND items.tags HOLDS "top_tier_map" AND items.drop_enabled=true
|mainlabel=-
}}
  |searchlabel=
- {{#cargo_query: table=items, maps
|link=none
|join on items._pageName=maps._pageName
|format=
|fields = MAX(maps.tier)
|limit=1
|where = items.class="Maps" AND items.tags HOLDS "top_tier_map" AND items.drop_enabled=true
|sort=Has map tier
}}
|order=asc
 
}} - {{#ask:
|| {{#cargo_query: table=items, maps
[[Has item class::Maps]]
|join on items._pageName=maps._pageName
[[Has tags::top_tier_map]]
|fields = MIN(maps.area_level)
[[Is drop enabled::true]]
|where = items.class="Maps" AND items.tags HOLDS "top_tier_map" AND items.drop_enabled=true
|?Has map tier=
}} - {{#cargo_query: table=items, maps
|mainlabel=-
|join on items._pageName=maps._pageName
  |searchlabel=
|fields = MAX(maps.area_level)
|link=none
|where = items.class="Maps" AND items.tags HOLDS "top_tier_map" AND items.drop_enabled=true
|format=
|limit=1
|sort=Has map tier
|order=desc
}}
|| {{#ask:
[[Has item class::Maps]]
[[Has tags::top_tier_map]]
[[Is drop enabled::true]]
|?Has map area level=
|mainlabel=-
  |searchlabel=
|link=none
|format=
|limit=1
|sort=Has map area level
|order=asc
}} - {{#ask:
[[Has item class::Maps]]
[[Has tags::top_tier_map]]
[[Is drop enabled::true]]
|?Has map area level=
|mainlabel=-
  |searchlabel=
|link=none
|format=
|limit=1
|sort=Has map area level
|order=desc
}}
}}
|}<noinclude>[[Category:SMW ask pages]]</noinclude>
|}

Revision as of 18:27, 11 January 2018

Map tier Tier range Map level range
Low tier maps
- 
-
Mid tier maps - -
Top tier maps

-

-