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: <q> <q>[[Uses symbol::Mahogany]]</q>  OR  <q>[[Uses material::Mahogany]]</q> </q>
 |?Source is
 |?Rarity is
 |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": "<q> <q>[[Uses symbol::Mahogany]]<\/q>  OR  <q>[[Uses material::Mahogany]]<\/q> <\/q>",
    "query_source": "SMWSQLStore",
    "query_time": "0.0409",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses symbol::Mahogany]] OR [[Uses material::Mahogany]]

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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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	ALL	PRIMARY				285		Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	drwiki.t1.id	1		Using where

Auxilliary Tables

Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 INNER JOIN `t3` AS t3 ON t2.p_id=t3.id WHERE (t2.o_hash='Mahogany')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=34290
Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1

Query Metrics

Query-Size:4
Query-Depth:1

Errors and Warnings

None

Item	Source is	Rarity is
Burnished mahogany-bound spellbook engraved with a queasy-looking gerbil	Mystical Machinations (2) , Mystical Machinations (1)
Burnished wheel painted with colorful sea creatures	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Butcher's knife fit with a short hilt	Breaking and Entering/Kitchen loot
Cartographer's geometry compass trimmed in silver leaf	Jakuv's All-Trades Outlet (3) , Jakuv's All-Trades Outlet (2), Jakuv's All-Trades Outlet (1)
Carved mahogany short bow	Functional Fashions (1)
Carved mahogany stonebow with a dark brown leather sling	Slings and Things (2)
Carved mahogany stonebow with a dark brown leather sling (2)	Slings and Things (3)
Claw-footed mahogany bed	Knob
Compact writing slate with a border	Breaking and Entering/Library loot	common
Competition miniature flock of seagulls with beady yellow eyes	Hollow Eve Festival 447/Game prizes	incidental
Contract case with a mahogany frame that holds cut-glass insets on front and back	Sebastien's Fine Print (2) , Sebastien's Fine Print (1)
Curved mahogany rack with highly polished bronze trim	Hide and Silk (3) , Hide and Silk (2)
Curved mahogany stand with highly polished bronze trim	Hide and Silk (3) , Hide and Silk (2)
Curved mahogany trunk with highly polished bronze fittings	Hide and Silk (3) , Hide and Silk (2)
Curved-leg mahogany escritoire	Weaving Minstrel , Golden Apple, Bloody Barnacle
Dainty comb carved with blossoms	Breaking and Entering/Bedroom loot
Dainty cowbell fit with a polished handle	Breaking and Entering/Library loot
Dark mahogany bow	S'hhtrkith's Instruments
Dark mahogany lap harp edged with silver feather inlay	Heavenly Harmonies (2) , Heavenly Harmonies (1)
Dark mahogany shield reinforced with crude strips of iron	Faithful Defender (2) , Faithful Defender (1)
Dark mahogany stationary kit with burnished gold hinges	The Book Wyrm (2)	festival
Deep mahogany mortar with an herb garden carved around the base	Emmiline's Cottage	common
Deep mahogany spear carved with a flame-shrouded centaur	Dark Defenders (1)
Deep red mahogany collector's case	Order of the Dragon Shield gifts and prizes
Deep red mahogany standard topped with a heavy silver hound and bearing an embroidered crimson banner	Iprilu's Emporium, Iprilu's Emporium (obsolete)
Detailed mahogany ice bucket with a hinged glass lid	Raven's Court VIP Suite
Detailed mahogany treble viol inlaid with fine silverwillow along the fingerboard	Incomparable Instruments
Elegant mahogany bow with a silverwillow-inlaid frog	Incomparable Instruments
Elegant mahogany grooming kit with sturdy black leather straps	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	incidental
Elegant mechanical bank adorned with a slender cloaked figure	Flynia's Fanciful Forest of Fineries
Engraved silver teapot attached to a short mahogany handle by a length of chain	Goods for Life (4) , Goods for Life (3)
Etched briquet marked with a simple blossom	Breaking and Entering/Armory loot
Etched mahogany sundial	Sutler's Wagon
Feathery seaweed fronds dappled with swirls	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes
Flamewood telescope with platinum bands	Item:Supple leather telescope case , Ruins of Ulf'Hara/Supply Wagon
Flintknapped coral carving knife with a smooth mahogany grip	Jhiskar's Provisions (4) , Jhiskar's Provisions (3)
Folding chair with a cushioned seat	Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Fragile cube	Breaking and Entering/Bedroom loot
Fragile sea globe with a polished base	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Gaudy rainbow silk spellbook case clasped with a carved mahogany shrew	Mystical Machinations (2) , Mystical Machinations (1)
Glazed mahogany shortbow
Gleaming mahogany ocarina inset with ivory and grey pearl dolphins	Alimia's Ocarinas
Glossy mahogany cigar box	Raven's Court VIP Suite
Gnarled mahogany walking stick	Item:Rough leather rucksack , 6th-Year Estate Holder Token Auction	auction
Gouged short sword with a mahogany grip	Corroded Corner (2)
HE2020Woods
Heavy mahogany desk	Knob
Heavy steel bracelet inset with mahogany heartwood	Turialo's Haven (7)
Highly polished dark mahogany tapani	Latanaara's Musical Wonders
Hollow Eve 399 gift

Semantic search

Query log

Navigation menu

Search