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::Emeralds]]</q>  OR  <q>[[Uses material::Emeralds]]</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::Emeralds]]<\/q>  OR  <q>[[Uses material::Emeralds]]<\/q> <\/q>",
    "query_source": "SMWSQLStore",
    "query_time": "0.0425",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses symbol::Emeralds]] OR [[Uses material::Emeralds]]

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				864		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='Emeralds')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=131375
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
Anklet	Grisgonda's Gems and Jewels (obsolete) , Grisgonda's Gems and Jewels
Anklet strung from intertwining gold fishhooks and obsidian lures	Fenwyrthie's Curio Shop
Antiquated kiralan signet ring bezel-set with an Ocean's Deep emerald	Estate Holder Charity Auction 434	auction
Arched white marble fireplace inlaid with matching jasper and emerald willows	Flowering Furniture (3) , Flowering Furniture (2), Flowering Furniture (1)	festival
Armbands	Grisgonda's Gems and Jewels (obsolete) , Grisgonda's Gems and Jewels
Armor:Articulated plate gauntlets accented with crocodile-skin along the cuffs
Armor:Chain balaclava crowned with a solitaire marquis-cut emerald
Armor:Dappled brown leathers emblazoned with a silver and ruby crest of the Barbarian Guild
Armor:Dazzling pure white plate engraved over the heart with a regal emerald-eyed lioness in a circle of olive branches
Armor:Deep brown leather mask dotted with leaf-shaped emeralds
Armor:Ebon leather cowl shadow-embroidered with emerald-eyed panthers
Armor:Fine silver chain greaves edged with gold and emerald interlacing
Armor:Forest-green leathers emblazoned with a silver and jade crest of the Barbarian's guild
Armor:Silver chain shirt worked with gold and emeralds
Articulated plate gauntlets accented with crocodile-skin along the cuffs	Hollow Eve Festival 410/Raffles
Articulated silver ring set with thousands of tiny emerald chips	Immokokkon and Sons (2)
Atapwi	Wooden Shack
Athlomi	Shoiya's Gems
Badger claw carved from bearclaw emerald	Beyond the Barrier: The Devastation of Lyras/Incidental Loot
Band (1)	Grisgonda's Gems and Jewels (obsolete) , Grisgonda's Gems and Jewels
Band (2)	Shoiya's Gems
Barrette	Grisgonda's Gems and Jewels (obsolete) , Grisgonda's Gems and Jewels
Beacon-of-Hope orchid fashioned from deep magenta-hued dergatine	Tildi's Flowers (7) , Tildi's Flowers (5)
Bearclaw emerald
Bearclaw emerald leaf
Bearded Kworlin doll wearing a pouch-laden jeweled belt	Puffindor's Professional Pieces (3)
Bejeweled garden oasis sculpted from lush viridian estrildite	Su Helmas 440: Entrapped/Raffle , Item:Canvas pouch pinned with a purple gold garden	auction
Bejeweled satin corset back-laced with spidersilk cords	Perfect Rose (2) , Hollow Eve Festival 414/Raffles
Belt of carved ivory linked with cabochon emeralds	Iprilu's Emporium (obsolete)
Bird-carved rowan wood bed	Knob
Black beaded ankle boots clasped with onyx ravens	Perfect Rose (2) , Perfect Rose (1)
Black doeskin corset jeweled with petite ruby roses on rambling emerald vines	Wavecrester , Mermaid's Fall, Cat's Ninth Life, Blood Bane
Black iron spider inset with a multitude of glittering gemstones	All Wound Up (2)
Black jade tailband elegantly carved with serpent scales	Turialo's Haven (6) , Turialo's Haven (5), Turialo's Haven (3)
Black leather moneybelt clasped by an emerald snake	treasure map, Item:Worn and tattered map	treasure map
Black satin leggings embroidered with golden roses	Turialo's Haven (8) , Turialo's Haven (4), Turialo's Haven (2)
Black snakeskin boots with stylized silver toecaps	Give 'Em the Boot (1)
Black willow carving case with a faceted emerald viper clasp	Altared Visions
Blackened robe dagger with an obsidian panther-shaped hilt	Mother Nyuku's Divine Creations (3) , Mother Nyuku's Divine Creations (1)
Blackened silver ring forged in the shape of a dragon	Estate Holder Council Open House 373
Blackened steel target shield inlaid with an angry wolf	Terrific Turnip (3) , Terrific Turnip (2)
Blackwood wardrobe carved with sinuous dragons in flight	Prison Riot: The Aftermath/End loot
Blade-bone claws fastened with korograth-hide leather straps	Guildfest 445/Auction	auction
Bloodwood half-handled riste bristling with asini thorns	Risty Business	festival
Bloodwood riste bristling with asini thorns	Risty Business	festival
Blown-glass hand bell with a Taisidon emerald clapper	Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade	end loot
Boko	Wooden Shack, Wooden Shack
Bracelet	Sister Imadrail's Emporium , Mirglyn Sisters , Goldsmiths, Grisgonda's Gems and Jewels (obsolete), Grisgonda's Gems and Jewels
Braided cambrinth ring set with a miniature golden pony	Mage's Tack Corner
Braided leather weapon harness fitted with cambrinth-inlaid steel rivets	War and Craft (2) , War and Craft (1)

Semantic search

Query log

Navigation menu

Search