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

Debug output SQLStore

ASK Query

[[Uses symbol::Watersilk]] OR [[Uses material::Watersilk]]

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				237		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='Watersilk')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=68955
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
Bisque watersilk tunic	Margareth's Home (2) , Margareth's Home (1)
Bisque watersilk vest	Margareth's Home (2) , Margareth's Home (1)
Black hooded cloak bearing blue camocas flames	treasure map, Item:Worn and tattered map	treasure map
Black watersilk bota with a sculpted silver kraken stopper
Blue watersilk Pr'ysin clasped with a teal svelae	Albrhae's Adornments (2) , Albrhae's Adornments (1)
Blue watersilk cloak embroidered with a swirl of silvery bubbles	treasure map	treasure map
Blue watersilk pouch embroidered with the image of an orlog	Voi's Fine Heirlooms (2) , Droughtman's Maze
Blue-green watersilk belt with an oceanic orichalcum medallion	Hollow Eve Festival 443/Raffles , Item:Electroweave carryall embroidered with a sinuous leviathan
Blue-green watersilk tunic with white embroidery along the hemline	Urn Back Time (2) , Urn Back Time (1)	festival
Blue-grey watersilk parasol capped with a stormfire topaz ferrule	Hollow Eve Festival 447/Auction	auction
Blue-violet watersilk kimono with a rich bluefire velvet under-robe	Sumptuous Silks (3) , Sumptuous Silks (2)
Blue-violet watersilk kimono with a rich starfire velvet under-robe
Bouquet of white silk roses bound by pink watersilk ribbons	Item:Elaborately carved ayabere hope chest
Bright crimson watersilk robe with an embroidered cat on the chest	Haute Dogs and Fat Cats
Brilliantly hued skirt of alternating camlet and watersilk panels	Natural Beauty (3) , Natural Beauty (2)
Calf-length flared watersilk skirt dyed a deep azure blue	Fighting is on the Wall
Cerulean watersilk kirtle with silver cord laces	Knight at the Club (2) , Knight at the Club (1)	festival
Cerulean watersilk pouch fastened with a long-tailed comet		festival
Cerulean watersilk sash	Stabbaticals (2) , Stabbaticals (1)	festival
Cerulean watersilk scroll case secured with a silver clasp	Blood and Gourd (5)
Charming ivory watersilk sundress belted with coralite	Hot Tropics	festival
Coral-pink watersilk scarf fringed with dozens of iridescent Taisidonian pearls	Tildi's Flowers (7)
Dark blue watersilk dress decorated at the hems with tiny onyx beads	Hide and Seek
Dark green watersilk doublet with slashed sleeves	All the King's Men (3)	festival
Dark watersilk bag bearing a detailed cambrinth medallion	Premium token raffles , Estate Holder gifts
Deep blue cloak clasped by a platinum dolphin	treasure map	treasure map
Deep blue cloak clasped with a platinum dolphin	treasure map	treasure map
Deep blue watersilk belt case fastened with a carved wood clasp	Loot N Flee (2) , Loot N Flee (1)
Deep blue watersilk dress decorated at the hems with small seed pearls	Hide and Seek
Deep blue watersilk grooming pouch cinched with satin cords	Fancybeards (3) , Fancybeards (2), Fancybeards (1)	festival
Deep blue watersilk ribbon	Damsel In This Dress (5) , Damsel In This Dress (3)
Deep blue watersilk robes cut on the bias to mold to the wearer's figure	Arcayne Attyre (3) , Arcayne Attyre (2), Arcayne Attyre (1)
Deep teal watersilk houppelande with flaring sleeves lined in silver	Damsel In This Dress (2)
Dramatic cloak fastened with a clasp	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes	incidental
Ebony watersilk cloth trimmed with lace	Rite of Cravat (2) , Rite of Cravat (1)
Elaborate watersilk ribbon threaded with multiple silver pins	Turialo's Haven (9)
Elegant straw hat with a band of black watersilk	Tricky Treats (3)
Enormous watersilk narwhal with a shimmery mermaid's chalcedony	Droughtman's Challenge 433/Incidental loot , Droughtman's Challenge 430/Incidental loot
Enormous watersilk narwhal with a shimmery mermaid's chalcedony horn	Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 441/Incidental loot, Droughtman's Challenge 437/Incidental loot	incidental
Flowing green watersilk robes pinned at the waist with an iceblink peridot	Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot , Aesthene's Close 445/Vault	end loot
Flowing robe of seafoam watersilk	Divinely Dressed
Flowing robes flecked with tiny droplets	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes	incidental
Flowing yellow watersilk bodysuit with a loose hood	Damsel In This Dress (5) , Damsel In This Dress (3)
Fluttery skirt with a glittery gauze overlay	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Folding chair with a cushioned seat	Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Form-fitting Reshalian-blue gown showcasing a frothy mermaid skirt	Wedding Belles (2)
Form-fitting Reshalian-blue wedding gown showcasing a frothy mermaid skirt	Wedding Belles (2) , Wedding Belles (1)
Form-fitting silvery blue watersilk bodice with strings of idopun pearls dangling from the ties	Item:Twilight blue watersilk shoulder bag with pearl-beaded silver ties , Item:Twilight blue watersilk shoulder bag with pearl-beaded silver ties, Curse of the Ghost Ship/End Loot
Fringed dark blue watersilk carpet	Argwesh's Alcove
Fringed silvery blue watersilk scarf	Item:Twilight blue watersilk shoulder bag with pearl-beaded silver ties , Item:Twilight blue watersilk shoulder bag with pearl-beaded silver ties, Curse of the Ghost Ship/End Loot

Semantic search

Query log

Navigation menu

Search