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

Debug output SQLStore

ASK Query

[[Uses symbol::Elothean lace]] OR [[Uses material::Elothean lace]]

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				88		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='Elothean lace')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=86447
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
Elegant napkin embroidered with a crest	Breaking and Entering/Kitchen loot
Elegant wrap of wispy Elothean lace sprinkled with iridescent crystal beading	Silk Lotus (2) , Silk Lotus (1)
Ethereal night-black Elothean lace shawl edged with pale grey damaryn pearls	Silk Lotus (2) , Silk Lotus (1)
Floor-length Elothean lace veil with a dramatic diamond and Ilithi emerald tiara	Trevellyn's of Leth Deri'el , Bridal Blush
Floppy nightcap trimmed with fur	Breaking and Entering/Bedroom loot
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
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
Fragile white Elothean lace shawl edged with snowy geshi pearls	Silk Lotus (2) , Silk Lotus (1)
Full-length chiffon gown dyed in hues of violet and red	Turialo's Haven (8) , Turialo's Haven (4), Turialo's Haven (2)
Gleaming steel scimitar with cloth wrapped around the hilt	Breaking and Entering/Armory loot
Graceful fan painted with swirling blossoms	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Graceful white foraging apron trimmed with Elothean lace	Foraging Emporium (3) , Foraging Emporium (2), Foraging Emporium (1)	festival
Graceful white foraging apron trimmed with elothean lace
HE2020Fabrics
Heavily embroidered sash with gemstone fractals	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes	incidental
Hollow Eve Festival 436/Game prizes
Hollow Eve Festival 436/Game prizes/Material options
Intricate misty grey Elothean lace thighband threaded with twilight sapphires	Damsel In This Dress (5) , Damsel In This Dress (3)
Intricately ruched garter	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Item:Cassock of diaphanous celadon silk and Elothean lace
Item:Cream spidersilk bodice over a snowy white chemise
Item:Crimson velvet bodice delicately embroidered with black rosebuds and tightly laced with ebony cords over a dainty lace chemise
Item:Elegant wrap of wispy Elothean lace sprinkled with iridescent crystal beading
Item:Ethereal night-black Elothean lace shawl edged with pale grey damaryn pearls
Item:Floor-length Elothean lace veil with a dramatic diamond and Ilithi emerald tiara
Item:Fragile white Elothean lace shawl edged with snowy geshi pearls
Item:Lace-trimmed green velvet skirt
Item:Long black flared skirt trimmed with imported Elothean lace
Item:Loose black silk blouse trimmed with imported Elothean lace
Item:Powder blue spidersilk bodice over a snowy white chemise
Item:Silver-shot Elothean lace garter threaded with pale blue ribbons
Item:Silvery web-like Elothean lace wrap with a black raw silk border
Item:Softly draped wedding gown of lustrous white silk with an ethereal Elothean lace overlay
Item:Strapless teal silk corset with Elothean lace insertions
Item:Twilight-hued spidersilk skirt trimmed with fragile black lace
Ivory Elothean lace wedding dress	Shard's South Bridge Street Faire 415 raffle center
Lace-edged spidersilk tunic dyed in a mosaic of varying green hues	Turialo's Haven (8) , Turialo's Haven (4), Turialo's Haven (2)
Lace-trimmed green velvet skirt	Wavecrester , Tropic Night, Mermaid's Fall, Harper's Song, Cat's Ninth Life, Blood Bane, Backfence Gossip
Leather gloves edged in braided cloth	Breaking and Entering/Armory loot
Length of fabric (1)
Length of fabric (2)	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes	incidental
Long black flared skirt trimmed with imported Elothean lace	Trevellyn's of Leth Deri'el
Loose black silk blouse trimmed with imported Elothean lace	Trevellyn's of Leth Deri'el, Trevellyn's of Leth Deri'el
Loose-fitting pajama top with polished buttons	Breaking and Entering/Bedroom loot
Lovely green bourde headband edged with Elothean lace	Damsel In This Dress (5) , Damsel In This Dress (3)
Pair of white satin gloves decorated at the wrists with fine Elothean lace	Turialo's Haven (8)
Pale blue silk garter edged with diaphanous white Elothean lace	Trevellyn's of Leth Deri'el , Bridal Blush
Plump pillow embroidered with posies	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes
Porcelain toy clothed in vestments	Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes	festival

Semantic search

Query log

Navigation menu

Search