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

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Uses material::Midnight onyx||Grazhir's onyx]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0228",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses material::Midnight onyx||Grazhir's onyx]]

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
`t3` AS t3 ON t1.o_id=t3.id) ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246)
  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	Extra
1	SIMPLE	t3	system	PRIMARY				1	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, const	46
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 t3
INSERT IGNORE INTO `t3` (id) VALUES (414444)
INSERT IGNORE INTO `t3` (id) VALUES (414444)

Query Metrics

Query-Size:3
Query-Depth:1

Errors and Warnings

None

Item	Source is	Rare item
Glittery parry stick with faceted ends	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
HE2020Gemstones
Heavily embroidered sash with gemstone fractals	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes	true
Hollow Eve Festival 436/Game prizes
Hollow Eve Festival 436/Game prizes/Material options
Interlocking miniature tridents	Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Iridescent filaments strung with stars	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 436/Game prizes
Item:Midnight onyx
Item:Pair of earrings crafted from midnight onyx spheres and looping silver strands
Jaunty fedora accented with a small shark	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Lacquered abacus strung with polished beads	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Lacquered band set with a tiny clownfish	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Latticed picnic basket tied with sea otters	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes	true
Luminescent moonsilver zuceira etched to show a full turning of the lunar cycle	Limited Treasures (5) , Item:Dark leather longcoat fastened with softly glowing blackened moonsilver buckles
Midnight onyx	Item:Aqua silk pouch
Miniature Dwarven bludgeoneer figurine wrought from blackened moonsilver	Item:Sturdy blued moonsilver repair case with a broad-buckled shoulder strap , Stolen from the Moons (3)
Miniature polar bear with round eyes	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes
Ornate cambrinth chain interspersed with beads	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 436/Game prizes
Pair of earrings crafted from midnight onyx spheres and looping silver strands	Natural Beauty (1)
Polished medal encircled by tiny sea turtles	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Polished wand topped with a starfish	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes	true
Round black gold compact embossed with a predatory murder crow	Sleeping Dragon Corn Maze 432/Incidental loot
Round green bota in the shape of a turtle with eyes	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes
Shadowy ka'hurst carving knife with a midnight onyx hilt	Drathrok's Duskruin 442/Incidental loot, Drathrok's Duskruin 438/Incidental loot, Drathrok's Duskruin 435/Incidental loot, Drathrok's Duskruin 430/Incidental loot, Drathrok's Duskruin 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot	true
Slender eyebrow ring dangling a sigil	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes	true
Slender steel skinning knife with a gemstone pommel	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Small treasure chest set with embellishments	Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Small trident graced with tipped prongs	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes	true
Smoi leather coin purse resembling a rat with dragon's scale sapphire eyes	Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 438/Drathrok's Assemblage, Drathrok's Duskruin 435/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage	true
Stylized wave	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Thin wraith-bone nose ring flaunting a faceted midnight onyx bead	Item:Raven-black scalene hex bag with an inky blue wildlace overlay
Twisted cambrinth ring set with a small gem	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Twisted torque terminated with spheres	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 436/Game prizes	true
Wild assortment of multicolored moonsilver keys	Stolen from the Moons (3)
Wirework coil of gleaming razaksel studded with midnight onyx spheres	All Tressed Up (2)	true
Wispy whisperlayne uaro's'sugi trimmed with midnight onyx	Limited Treasures (6)	true

Semantic search

Query log

Navigation menu

Search