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

Results 21 – 70 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Uses material::Platinum]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0614",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses material::Platinum]]

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=19612)
  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
20

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		2114		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
Articulated platinum cobra pin set with jeweled eyes	Alyden Aundu 363
Articulated platinum handfasting cord adorned with sparkling diamond and onyx beads	Sputkin's Wagon , Sputkin's Splendors (5), Sputkin's Splendors (4), Sputkin's (3), Sputkin's (2)
Articulated platinum ring	Immokokkon and Sons (2) , Immokokkon and Sons (1)
Ashen kau leather wallet with a platinum dragon crest	Squat Bungalow (2)
Athlomi	Shoiya's Gems
Aurulent sanowret crystal set in a platinum wildling spider	Accents for the Arachnophile (7) , Accents for the Arachnophile (6), Accents for the Arachnophile (5)
Austere silk robe belted with tiny woven strands of platinum chain	Hollow Eve Festival 414/Raffles	true
Austere stormsilk pouch clasped with a starsteel lightning bolt	Hollow Eve Festival 436/Auction	true
Azure arzumodine cloak with a plain platinum clasp	Jhanine Dering Cloaks (6)	true
Azure doublet of silk brocade with slashed sleeves	treasure map	true
Azure leather gerri with a silver buckle emblazoned with a platinum-inlaid ship with billowed sails	Elven Accoutrements (2) , Elven Accoutrements (1)
Azure-trimmed ocean grey robe stitched with the striking image of a crouching black panther	War and Craft (2) , War and Craft (1), Item:Crimson-trimmed ebon robe embroidered with an elegant swirl of platinum snowflakes, Item:Crimson-trimmed ebon robe embroidered with an elegant swirl of platinum snowflakes
BEMetals
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
Beautifully polished platinum flute set with tiny star-shaped diamonds in each key	Incomparable Instruments
Beige linen pouch adorned with diamonds and sapphires forming a wren in flight	Item:Taupe spidersilk haversack studded with platinum beads and platinum musical notes embedded along the edges , Item:Taupe spidersilk haversack studded with platinum beads and platinum musical notes embedded along the edges, Droughtman's Maze
Bejeweled caravan charm
Bejeweled mambeli with an ornate platinum handguard and pommel	Corik's Secret: Treasures of the Tomb/Incidental loot	true
Bejeweled mambeli with an ornate pommel and a platinum-plated handguard (1)	Squat Bungalow (1)	false
Bejeweled mambeli with an ornate pommel and a platinum-plated handguard (2)	Squat Bungalow (2)
Bejeweled platinum chalice	Curse of the Ghost Ship/Incidental Loot
Bejeweled platinum knife with elaborate gold-filled etchings along the blade	Knife's Edge (3)
Bejeweled platinum tailband	World Dragon Priest
Belzune stone wrist amulet	Sleeping Dragon Corn Maze 425/Incidental loot
Black cavalier hat with a wide firesilk band holding multiple plumes	Dragon Dreams (2)
Black gauntlets trimmed in platinum	Acaph's Acquisitions
Black ironwood spellbook case with the crest of the Warrior Mage Guild inlaid in platinum	Item:Aged leather satchel embellished with the faded crest of the Warrior Mage Guild , Curse of the Ghost Ship/End Loot, Item:Aged leather satchel embellished with the faded crest of the Warrior Mage Guild
Black leather balac studded down each leg with a row of platinum buttons shaped like horses	Elven Accoutrements (2) , Elven Accoutrements (1)
Black leather gerri with a silver buckle emblazoned with a platinum-inlaid horse in mid-stride	Elven Accoutrements (2) , Elven Accoutrements (1)
Black leather jousting boots featuring silver spurs	Order of the Black Fox/Gifts and prizes
Black linen coinec with platinum cufflinks shaped like horses	Elven Accoutrements (2) , Elven Accoutrements (1)
Black linen ilalish studded with platinum buttons shaped like horses	Elven Accoutrements (2) , Elven Accoutrements (1)
Black mahogany smoking case secured with a fox-shaped platinum knob	Order of the Black Fox/Gifts and prizes
Black onyx cufflinks inset with red diamonds	Terald's Tent	true
Black onyx pin inlaid with gold and platinum blossoms	Tavern Troupe Performing Order/Gifts and prizes
Black onyx ring wrapped with platinum leaves	Dragon's Horde
Black opal ear-stud with a dangling platinum raven	Item:Supple black leather satchel embossed in silver with a raven clutching a wheat sheaf
Black spidersilk lootsack clasped with a platinum dragon	Estate Holder gifts
Black spidersilk weapons harness clasped with a platinum seven-pointed star	Order of the White Rose/Gifts and prizes
Black starlight velvet gown with a platinum filigreed pin	Silken Seams (2) , Silken Seams (1)
Black tourmaline brooch edged with slender platinum wire	River Dreamer , North Wind's Skimmer
Black velvet boots trimmed with soft rabbit fur	Seasoned Dressings
Black velvet choker set with a cabochon malachite stone	Turialo's Haven (8) , Turialo's Haven (4), Turialo's Haven (2), Turialo's Haven (1)
Black velvet gem case fastened with a platinum filigree lock	Estate Holder gifts
Black velvet thigh boots buckled with platinum lilies	Curse of the Ghost Ship/Incidental Loot
Blackberry thornweave longcoat fettered by diamonds	Natural Beauty (1)
Blackened cambrinth armband with contrasting claws of onyx and platinum	Moon Mage Conclaves
Blackened inkhorne bone armband hung with a constellation of tiny stars	Guildfest 412/Auction

Semantic search

Query log

Navigation menu

Search