Semantic search

Jump to navigation Jump to search
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
Debug output SQLStore
ASK Query
[[Uses symbol::Elven snowlace]] OR [[Uses material::Elven snowlace]]
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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt1ALLPRIMARY38Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4drwiki.t1.id1Using 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='Elven snowlace')
      INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=211087
  • 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
ItemSource isRarity is
Gauzy pale grey turbaurs dress densely adorned with floral patterns of silverweaveDamsel In This Dress (2)
Gauzy uaro's'sugi of delicate Elven snowlaceAng'hhsmus
High-collared mistsilk dress with tapered Elven snowlace sleevesFiner Things (4) Finer Things (3)
Item:Bardic blue velvet frock coat ornamented by burnished golden lutes
Item:Gauzy pale grey turbaurs dress densely adorned with floral patterns of silverweave
Item:Gauzy uaro's'sugi of delicate Elven snowlace
Item:Lapis blue silk gown overlaid with pale Elven snowlace
Item:Large bolt of Elven snowlace fabric
Item:Medium bolt of Elven snowlace fabric
Item:Small bolt of Elven snowlace fabric
Item:Smooth cobalt crystal medallion suspended from a length of Elven snowlace
Item:Trim-sized piece of Elven snowlace fabric
Lapis blue silk gown overlaid with pale Elven snowlaceSilken Seams (2)
Large bolt of Elven snowlace fabricFabric Fantasies (2) Fabric Fantasies (1)
Medium bolt of Elven snowlace fabricFabric Fantasies (2) Fabric Fantasies (1)
Pair of large butterfly wings made from smooth Elven snowlaceWhimsies (2)festival
Pair of white Elven snowlace slippers affixed with tapered mistglass heelsNatural Beauty (4)festival
Pale mint satin gown with a ruffled Elven snowlace skirtSilken Seams (3)
Perfumed marquisette handkerchief trimmed with Elven snowlaceHighway Robbery Reduxfestival
Plaited golden velvet headband featuring an Elven snowlace half-veilDamsel In This Dress (5) Damsel In This Dress (3)
Satin-lined Elven snowlace bagFiner Things (4) Finer Things (3)
Slim khaddar dress with a flowing overlay of Elven snowlaceDamsel In This Dress (3)
Small bolt of Elven snowlace fabricFabric Fantasies (2) Fabric Fantasies (1)
Smooth cobalt crystal medallion suspended from a length of Elven snowlaceItem:Hollow Eve 406 gift Item:Hollow Eve 406 gift
Strapless Elamiri sapphire icesilk gown swathed in Elven snowlaceWedding Belles (2)
Strapless Elamiri sapphire icesilk wedding gown swathed in Elven snowlaceWedding Belles (2) Wedding Belles (1)
Trim-sized piece of Elven snowlace fabricFabric Fantasies (2) Fabric Fantasies (1)Drathrok's Duskruin 422/Drathrok's AssemblageDrathrok's Duskruin 421/Drathrok's Assemblage
White diamond icesilk handkerchief edged with Elven snowlaceNever Too Late Once Morefestival