User:Illviljan/test: Difference between revisions
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 Deck
Lucky Deck
910x Module Error: No results found for item using search term "item_name = Stacked Deck"When 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
}}