Semantic search

This page or action requires JavaScript to work. Please enable JavaScript in your browser or use a browser where it is supported, so that functionality can be provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

Condition

Printout selection

Options

Parameters [+]

limit:

The maximum number of results to return

offset:

The offset of the first result

link:

Show values as links

headers:

Display the headers/property names

mainlabel:

The label to give to the main page name

intro:

The text to display before the query results, if there are any

outro:

The text to display after the query results, if there are any

searchlabel:

Text for continuing the search

default:

The text to display if there are no query results

class:

An additional CSS class to set for the table

transpose:

Display table headers vertically and results horizontally

sep:

The separator between results

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[item type is::gem pouch]]
 |?Worn in slot
 |format=table
 |limit=50
 |offset=15
 |sort=
 |order=asc
}}

Results 16 – 65 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[item type is::gem pouch]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0387",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Item type is::Gem pouch]]

SQL Query

SELECT DISTINCT
t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_di_wikipage` AS t1
INNER JOIN
`t2` AS t2 ON t1.p_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=53045)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
15

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t2	ALL	PRIMARY				2	Using temporary; Using filesort
1	SIMPLE	t1	ref	s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3	o_id_3	9	const, drwiki.t2.id	1
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	drwiki.t1.s_id	1	Using where

Auxilliary Tables

Temporary table t2
Recursively computed hierarchy for element(s) (2021226).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021226 LIMIT 1

Query Metrics

Query-Size:2
Query-Depth:1

Errors and Warnings

None

	Worn in slot
Colorfully beaded gem pouch with feather-tipped ties
Creamy velvet gem pouch trimmed with delicate Albarian lace
Crimson gem pouch embroidered with silver and gold thread	belt
Crimson velvet gem pouch with gold silk drawstrings	belt
Dark spidersilk gem pouch embroidered with the barely visible image of a crouching panther	belt
Dark velvet gem pouch suspended from a blackwater jet belt toggle	belt
Electroweave gem pouch with an electrum clasp	belt
Elegant firesilk gem pouch embellished with tiny seed pearls	belt
Elegant gem pouch clasped with lifesculpted quartz	belt
Elven silk gem pouch with cascading satin ties	belt
Exotic green gem pouch of interwoven rafflesia vines	belt
Feathered gem pouch shaped like a chubby owl	belt
Fiery-red gem pouch embroidered with the crest of the Warrior Mage Guild	belt
Forest-green gem pouch embroidered with the crest of the Rangers' Guild	belt
Forest-green linen gem pouch clasped with a polished deobar wren	belt
Fragile faesilk gem pouch dangling sungold key charms	belt
Fuzzy gem pouch embroidered with an orange-striped tabby cat	belt
Gem pouch	belt
Gingham poke clasped with a smiling gold pig's head	belt
Grey damask gem pouch embroidered with four crossed greatswords	belt
Horned owl pocket with fluffy feathers	belt
Item:Alabaster brocade gem pouch embroidered with a jet-black wolf	belt
Item:Alabaster silk gem pouch embellished with a ghostly white swath of Albarian lace	belt
Item:Alabaster-white gem pouch with a nickel cow charm	belt
Item:Amber silk gem pouch secured with an enameled flaming anvil	belt
Item:Black leather gem pouch tooled with a complex triquetra knot
Item:Black satin gem pouch clasped with a silver ruby-eyed scorpion	belt
Item:Black satin gem pouch with a blued-steel raven clasp	belt
Item:Black velvet gem pouch embroidered with an endless knotwork design	belt
Item:Burgundy brocade gem pouch with a golden lightning bolt clasp
Item:Colorfully beaded gem pouch with feather-tipped ties
Item:Creamy velvet gem pouch trimmed with delicate Albarian lace
Item:Crimson velvet gem pouch with gold silk drawstrings	belt
Item:Dark spidersilk gem pouch embroidered with the barely visible image of a crouching panther	belt
Item:Elegant firesilk gem pouch embellished with tiny seed pearls	belt
Item:Elven silk gem pouch with cascading satin ties
Item:Feathered gem pouch shaped like a chubby owl	belt
Item:Forest-green linen gem pouch clasped with a polished deobar wren	belt
Item:Fuzzy gem pouch embroidered with an orange-striped tabby cat	belt
Item:Gem pouch	belt
Item:Grey damask gem pouch embroidered with four crossed greatswords
Item:Lavish gem pouch bedecked with garnet and diamond beading
Item:Midnight black nightsilk gem pouch with a tarnished silver raven clasp	belt
Item:Pale silk gem pouch embroidered with a ghostly grey raven	belt
Item:Silverweave gem pouch secured with a panther claw clasp	belt
Item:Soft satin gem pouch emblazoned with a rearing stallion
Item:Stained burlap gem pouch	belt
Item:Tartan gem pouch with rabbit-foot ties
Item:Tawny doeskin gem pouch embroidered with a majestic stag
Item:Vibrant Musparan silk gem pouch with dangling tiny brass medallions

Semantic search

Query log

Navigation menu

Search