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: [[Uses material::Nightsilk]]
 |?Source is
 |?Rare item
 |format=table
 |limit=50
 |offset=10
 |sort=
 |order=asc
 |mainlabel=Item
 |default=None yet
 |sep=,&nbsp;
}}

Results 11 – 60 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Uses material::Nightsilk]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0507",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses material::Nightsilk]]

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 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246 AND t1.o_id=71112)
  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
10

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	index_merge	s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3	o_id,o_id_3	5,9		332		Using intersect(o_id,o_id_3); Using where; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	drwiki.t1.s_id	1		Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:2
Query-Depth:1

Errors and Warnings

None

Item	Source is	Rare item
Black leather belt with vivid violet nightsilk accents	Sindah's Silk Sensations (3) , Sindah's Silk Sensations (2)
Black leather sheath with nightsilk ties	Peaceful Intentions (2) , Peaceful Intentions (1)
Black nightsilk cloak clasped with an intricately carved ivory lion's paw	Outcast Military Surplus
Black nightsilk cloak clasped with an smooth fire opal	Premium raffles
Black nightsilk duffel bag clasped with a small silver skull	Skull Bowling (2)
Black nightsilk gown decorated at the collar with star sapphires	Turialo's Haven (9)
Black nightsilk long gloves	Phior's Fashions
Black nightsilk mask accented with a spray of white swan feathers	Item:Transparent case made of icy blue tinted glass with a crystal-filled handle
Black nightsilk robe adorned with a myriad of gemstones in cascading patterns	Hide and Seek
Black satin telescope case embroidered with the image of three full moons	Item:Ebonwood chest inlaid with silver constellations labeled "His" , Item:Ebonwood chest inlaid with silver constellations labeled "His", Dunshade: Echo of Tears/End loot
Braided nightsilk harness with a black onyx clasp	Drathrok's Duskruin 442/Incidental loot, Drathrok's Duskruin 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot	true
Braided nightsilk rope affixed with a glaes grappling hook	House of the Revenant Fang 423/Shadowy Safehouse
Breaking and Entering/Rooms and Loot/Material options
Ceremonial nightsilk robes	Item:Dark leather haversack clasped with a trio of trailing heron feathers , 6th-Year Estate Holder Token Auction	true
Circlet of beaten bronze wrapped with dark amber and ebony nightsilk	Fair Daisy
Cloth-lined celestial charts detailed with ink	Breaking and Entering/Sanctum loot	false
Cloudy white nightsilk rain cloak fastened with a hexagonal abyssal quartz	Weather Beaters (3)
Crimson hood trimmed in black (1)	Moon Mage Pavilion , Essential Sects Shop (1)
Crimson hood trimmed in black (2)	Essential Sects Shop (2), Essential Sects Shop (2)
Crimson robe with a golden stylized upside-down Q adorning the shoulder (1)	Moon Mage Pavilion , Essential Sects Shop (1)
Crimson robe with a golden stylized upside-down Q adorning the shoulder (2)	Essential Sects Shop (2), Essential Sects Shop (2)
Curved silvery scimitar with a nightsilk-wrapped hilt	Visions of Holiness (2) , Visions of Holiness (1)
Dainty slippers of cerulean nightsilk	Occasional Treasures
Dainty slippers of midnight blue nightsilk	Occasional Treasures
Daring gown of nightsilk laced down the back with braided leather	Black Orchid
Dark leather ceremonial belt braided with blue nightsilk ribbons	Fit for a Baron
Dark nightsilk moneybelt set with a single uncut diamond
Dark nightsilk pouch hung with a tiny everdusk damite pendant-orlog charm	Aesthene's Close 449/End Loot	true
Dark nightsilk thigh bag embroidered with white cresent moons and a golden boar
Dark nightsilk umbrella with a luminous moonsilver handle	Return to the Keep 431/Supply Wagon
Deep black nightsilk cloak embroidered with a silver dagger	Guildly Pleasures
Deep black nightsilk gown wrapped with fine silver chains from neckline to hip	Dark Dalliance (1)
Deep black nightsilk handkerchief with white applique in each corner	Aesthene's Close 449/End Loot	true
Deep blue nightsilk pants with thin silver pinstripes	Smokes 'n' Spirits
Deep blue nightsilk shirt with a silver-trimmed chest pocket	Smokes 'n' Spirits
Deep bronze nightsilk pants with thin silver pinstripes	Smokes 'n' Spirits
Deep bronze nightsilk shirt with a silver-trimmed chest pocket	Smokes 'n' Spirits
Deep crimson nightsilk pants with thin silver pinstripes	Smokes 'n' Spirits
Deep crimson nightsilk shirt with a silver-trimmed chest pocket	Smokes 'n' Spirits
Deep green nightsilk pants with thin silver pinstripes	Smokes 'n' Spirits
Deep green nightsilk shirt with a silver-trimmed chest pocket	Smokes 'n' Spirits
Deep grey nightsilk rug embroidered with a shadow master's silhouette	Haunted House (3), Haunted House (4) , Haunted House (3)	true
Deep indigo nightsilk pants with thin silver pinstripes	Smokes 'n' Spirits
Deep indigo nightsilk shirt with a silver-trimmed chest pocket	Smokes 'n' Spirits
Deeply hooded longcoat of rich plum nightsilk	Twilight Treasures
Deeply-hooded black snakeskin longcoat	Twilight Treasures
Deluxe black smoking jacket belted with deep blue nightsilk	Smokes 'n' Spirits
Deluxe black smoking jacket belted with deep bronze nightsilk	Smokes 'n' Spirits
Deluxe black smoking jacket belted with deep crimson nightsilk	Smokes 'n' Spirits
Deluxe black smoking jacket belted with deep green nightsilk	Smokes 'n' Spirits

Semantic search

Query log

Navigation menu

Search