User:Illviljan/test: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
>Illviljan
No edit summary
>Illviljan
mNo edit summary
Line 10: Line 10:
   |format=list
   |format=list
   |?Is area id=
   |?Is area id=
}}
{{subst:#cargo_query:
|tables = areas
|fields = areas.id
|where = areas.id LIKE "%MapWorlds%"
|format = list
|limit = 5000
}}
}}
</pre>
</pre>

Revision as of 08:35, 23 December 2017

Query multiple area id

Lucky DeckLucky Deck910x Stacked DeckWhen the outcome is the same, does it matter if it is fortune or trickery? for example an be found in tier 7 map areas (area level 67+7=74). If you wan't to avoid copying and pasting each id, then use the following query:

{{subst:#ask:
  [[Has area level::74]]
  [[~*MapAtlas*]]
  |mainlabel=-
  |link=none
  |format=list
  |?Is area id=
}}

{{subst:#cargo_query:
|tables = areas
|fields = areas.id
|where = areas.id LIKE "%MapWorlds%"
|format = list
|limit = 5000
}}

yields

{{#ask:

 Has area level::74
 ~*MapAtlas*
 |mainlabel=-
 |link=none
 |format=list
 |?Is area id=

}}

List of areas with area ids

{{#ask:

 Has name::+
 Is area id::+
 |sort=Is area id
 |limit=1000
 |?Is area id
 |?Has name
 |?Has main page

}}