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

Debug output SQLStore

ASK Query

[[Uses material::Firesilk]]

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=114597)
  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		172		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
Blob formed from shimmering firesilk petals	Tildi's Blooms (4) , Tildi's Blooms (3), Tildi's Blooms (2)
Blue silk cloak embroidered with a flame-shrouded lute	Item:Dull green silk cloak embroidered with a trio of spherical orbs , Item:Dull green silk cloak embroidered with a trio of spherical orbs, Curse of the Ghost Ship/Incidental Loot
Braided firesilk sling embroidered with firebreathing dragons	Order of the Dragon Shield gifts and prizes
Bright golden firesilk dress flecked with smoky grey	Sindah's Silk Sensations (2)
Bright green firesilk dragon costume adorned with scaly leather wings	Estate Holder gifts
Brilliant firesilk tabard emblazoned with winged dragon coiled around an undulant dagger	Mahchoe's Men's Shop (4) , Mahchoe's Men's Shop (3)
Brilliant incarnadine uaro's'sugi of lightweight firesilk	Ang'hhsmus
Brushed suede fedora trimmed with a band of copper firesilk	treasure map	true
Burnished smokewood picnic basket trimmed with miniature glaes spatulas	Glaes Spatula Tour	true
Burnt orange firesilk belt decorated with topaz beads	Fire and Ice (2) , Fire and Ice (1)
Carved burlwood sheath draped with shimmering firesilk ties	Peaceful Intentions (2)
Clinging halter-neck golden firesilk gown cut to reveal the wearer's shoulder blades	Fallen Angels Clothing (4) , Fallen Angels Clothing (3), Fallen Angels Clothing (1)	true
Comfy tiny kitchen of stuffed silverweave complete with a firesilk hearth	Limited Treasures (1)
Daring low-cut silver firesilk gown with a graceful train	Fallen Angels Clothing (4) , Fallen Angels Clothing (3), Fallen Angels Clothing (1)	true
Dark agonite great helm patterned with stylized flames	Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 441/Incidental loot, Droughtman's Challenge 437/Incidental loot, Droughtman's Challenge 433/Incidental loot, Droughtman's Challenge 430/Incidental loot
Dark green butterfly vine blooming with orchid-shaped firesilk flowers	Tildi's Flowers (6) , Tildi's Flowers (4)
Dark red firesilk cloak embroidered with a clenched fist	Guildly Pleasures
Darkened smokewhorl gloves with angled firesilk cuffs	House of the Revenant Fang 437/Shadowy Safehouse , Aesthene's Close 445/Vault, Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot	true
Deep yellow firesilk cloak embroidered on the back with a shining sun	Fire and Ice (2) , Fire and Ice (1)
Double-mantled formal cloak of crimson firesilk and trilliant-cut smoke rubies	Puffs of Glitter (3)
Drab firesilk bundle bedecked with alshabi stone arrows		true
Dragonwood display case with a firesilk lining	Trader Guild , Ratha Shop/Archive
Elegant drop-waisted firesilk gown with a delicate lace overskirt	Hollow Eve Festival 428/Raffles
Elegant firesilk gem pouch embellished with tiny seed pearls	Simply Essential (2)
Elegant firesilk gown with intricate gold embroidery around the hems	Everyday and Someday
Emerald green robe woven from strands of firesilk clasped with an onyx rose	Finer Things (2) , Finer Things (1)
Empire-waisted gown of pale golden firesilk	Finer Things (4) , Finer Things (3)
Enormous pair of vivid crimson firesilk dragon wings flecked with tiny glowing sunstone shards	Feast of Eluned 1 auction	true
Exceptionally soft black fur blanket lined with golden firesilk	Tavern Troupe Performing Order/Gifts and prizes
Fiery red back scabbard with loosely hanging firesilk ties	Peaceful Intentions (2) , Peaceful Intentions (1)
Firesilk baldric clad in agonite plates	Drathrok's Duskruin 438/Incidental loot, Drathrok's Duskruin 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot	true
Firesilk bodice embroidered with jagged flames	Mighty Mage	true
Firesilk cloak clasped by a flame-shaped ruby charm	treasure map	true
Firesilk cloth with whipstitched edges	Fit to be Tied (2)	true
Firesilk crafting satchel with a flame-carved ruby clasp	Which Craft (1)
Firesilk shawl dyed with the silhouette of a dragon	Dragon Dreams (2)
Firesilk tapestry emblazoned with a dog leaping through flames	ScallyWags
Firesilk trousers	Amylia's Attic (3)	true
Fitted firesilk vest with tiny anvil buttons	treasure map	true
Flamboyant firesilk mage's robes clasped with a lava sphalerite	treasure map	true
Flamewood picnic basket boasting a profusion of golden firesilk ribbons	Tavern Troupe Performing Order/Gifts and prizes
Floor-length golden cloak of shimmering firesilk with brown undertones	Turialo's Haven (8) , Turialo's Haven (4), Turialo's Haven (2)
Forgeheart iron hammers trailing shimmering firesilk streamers	Aesthene's Close 449/End Loot	true
Formal storm-grey firesilk breeches	Storms of Silk
Gaudy gypsy caravan with walls of firesilk and spun glitter	Limited Treasures (1)
Ghostly white gown of sheer gossamer with ribbons laced down the back	Dark Dalliance (1)
Gilded chain gloves laced with firesilk ribbon	Storms of Silk
Glistening blood-red bitterweave aventail trimmed in smoky black firesilk	Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage	true
Glistening blood-red bitterweave cap trimmed in smoky black firesilk	Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage	true
Glistening blood-red bitterweave gloves trimmed in smoky black firesilk	Drathrok's Duskruin 446/Drathrok's Assemblage , Drathrok's Duskruin 442/Drathrok's Assemblage	true

Semantic search

Query log

Navigation menu

Search