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::Ebonwood]]
 |?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::Ebonwood]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0488",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses material::Ebonwood]]

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=53583)
  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		283		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
Brushed black velvet doublet with ebonwood buttons	Head to Toe	true
Carved ebonwood beetles	Jester's General Store
Carved ebonwood lockpick case inlaid with translucent green jade	Item:Small key , Just Desserts (1)
Carved gargoyle figurine made from ebonwood	Svenblum's Annex
Child's ebonwood angle harp	Heavenly Harmonies (2) , Heavenly Harmonies (1)
Child's ebonwood angle harp painted with strawberries and silver-edged white blossoms	Heavenly Harmonies (2) , Heavenly Harmonies (1)
Coiled ebonwood vipers with glittering garnet eyes	Twilight Treasures
Dainty ebonwood talisman case	Just In Case (2) , Just In Case (1)
Dark ebonwood double-stringed crossbow set with an ivory skull-shaped boltplate	Corik's Secret: Treasures of the Tomb/End loot
Dark ebonwood repair kit set with an ivory skull and crossbones	Bardic Basics
Darkened sledgehammer with a reinforced ebonwood grip	Hollow Eve Festival 417/Raffles
Darkened steel blade with a contoured ebonwood hilt	Corik's Secret: Treasures of the Tomb/End loot
Darkened throwing blade with a finely carved ebonwood hilt	Dunshade: Echo of Tears/End loot
Deep blue canvas umbrella with an ebonwood handle	Gear Shop (5) , Gear Shop (4), Gear Shop (3), Gear Shop (2)
Double-chambered forge bellows	Order of the White Rose/Gifts and prizes	true
Dragon engraved short-handled bearded war axe	Morum Melgorehn/End loot
Ebon-hilted steel baselard trimmed with repousse brasswork bands	Pointed Ramarck's , MegaSafari 413 game prizes, Darkbox 414 prizes, Basket of colored darts
Ebonwood canopy bed	Knob
Ebonwood caravan care kit set with long jade veins etched to resemble blades of grass	Packrat's Piece of Paradise (2) , Packrat's Piece of Paradise (1), Packrat's Paradise (6), Packrat's Paradise (1)
Ebonwood castanets inlaid with a silver spiderweb design	Jyngle's Jangles
Ebonwood chest inlaid with silver constellations labeled "His"	Dunshade: Echo of Tears/End loot
Ebonwood crossbow carved to resemble a lithe panther	Path of the Panther, Path of the Panther
Ebonwood dice	Joirin's Puzzles
Ebonwood fishing box overlaid with gemstone fish	Overstocked and Underpriced
Ebonwood flute amulet on an elegant silver chain	Hollow Eve Festival 414/Raffles
Ebonwood footlocker detailed with intricately carved alkanet leaves	Bunglefoot's Tent (1)	true
Ebonwood hide scraper wrapped in soft lambskin	Overstocked and Underpriced	true
Ebonwood hobbyhorse with a black and white orca head
Ebonwood horns	Finest Box of Gems (2) , Finest Box of Gems (1)
Ebonwood knitting needles	Snacky Happiness (2)	true
Ebonwood leucro figurine	Item:Unadorned cedar toy box , Svenblum's Wagon, Hollow Eve Festival 417/Raffles
Ebonwood lockpick case carved with butcherbirds in flight	Sketchy By Design (7)
Ebonwood lockpick case with a panther stalking a mage carved upon it	Kharsaan's Tent
Ebonwood mirror painted with obsidian eyes	Droughtman's Challenge 444/End loot	true
Ebonwood ocarina carved to resemble a lithe panther	Hollow Eve Festival 436/Raffles , Alimia's Ocarinas
Ebonwood ocarina decorated with a hematite bear	Alimia's Ocarinas
Ebonwood pendant bearing a varna symbol	Hollow Eve Festival 417/Raffles
Ebonwood picnic basket with red satin ties	Order of the Black Fox/Gifts and prizes
Ebonwood plaque engraved with the crest of the rangers' guild (door)
Ebonwood plaque engraved with the crest of the rangers' guild (freestanding)
Ebonwood plaque engraved with the crest of the rangers' guild (tree)
Ebonwood rattle with a string of feathers dangling from the handle	Witchery (2) , Witchery (1)
Ebonwood shell collector's case decorated with enameled shells	Beachcomber Delights (2) , Beachcomber Delights (1)
Ebonwood shortbow with an ornately carved grip	Hollow Eve Festival 406/Raffles
Ebonwood tambourine charm	Chizelli's Charms (4)
Ebonwood walking stick capped with a silver and marble sphere	Walk This Way (2)
Ebonwood weapon rack carved with wolves in bas-relief	Haunted House (4) , Haunted House (3)	true
Ebonwood wristcuff with a sapphire-eyed ebony panther	Festival Pavilion (1)
Ebonwood-framed painting entitled "The Be'ort Tear Rose"	Bunglefoot's Tent (2) , Bunglefoot's Tent (1)	true
Elegant ebonwood chest with flamewood inlay	Dunshade: Echo of Tears/End loot

Semantic search

Query log

Navigation menu

Search