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::Starlight velvet]] OR [[Uses material::Starlight velvet]]
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
1SIMPLEt1ALLPRIMARY84Using 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='Starlight velvet')
      INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=210958
  • 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
Deep crimson starlight velvet greatcloak that shimmers with constellations of the night skytreasure maptreasure map
Deep indigo starlight velvet mantle trimmed with tiny crystalsJhanine Dering Cloaks (6) Jhanine Dering Cloaks (5)festival
Elven snowlace gown with a starlight velvet underskirtNatural Beauty (4)festival
Enshrouding starlight velvet cloak secured with a nightstone set in asharsh'daiSu Helmas 438: The Forbidden Temple/Raffleauction
Enveloping starlight velvet greatcloak fastened with a loimic chain claspLimited Treasures (5)
Ethereal sparkling white starlight velvet slippers embellished with alavern beadsNigeyi's (4) Nigeyi's (3)Nigeyi's (2)
Extravagant starlight velvet cape lined with deep purple silkHollow Eve Festival 417/Raffles
Fragile oceanic orichalcum circlet twined with black Mer'Kresh lightning rosesItem:Halter-neck gown with chaotically layered skirts of windstorm gossamerfestival
Gleaming steel falchion with a double-wrapped grip (2)Dark Defenders (2)
Glimmering starlight velvet robe with long bell-shaped sleevesTurialo's Haven (8)
Golden moon coral Phelim emblem suspended from a strip of starlight velvetSputkin's Splendors (5)festival
Gown of layered gold lace with a sapphire starlight velvet overskirtSilken Seams (3)
Hip-hugging black starlight velvet leggingsPuffs of Glitter (3)
Hollow Eve 439 giftSleeping Dragon Corn Maze 447/End loot Sleeping Dragon Corn Maze 443/End lootIcheaHollow Eve Festival 439end loot
Inky starlight velvet evening gown scattered with blue diamond constellationsLimited Treasures (3)
Item:Black starlight velvet gown with a platinum filigreed pin
Item:Large bolt of starlight velvet fabric
Item:Large case constructed from a series of metal cogs
Item:Layered starlight velvet robe with an intricately knotted sash
Item:Medium bolt of starlight velvet fabric
Item:Off-the-shoulder moonsilk gown with a navy starlight velvet bodice
Item:Regal starlight velvet handbag cinched in at the sides with gold cording
Item:Slim compendium bound with plush starlight velvet
Item:Small bolt of starlight velvet fabric
Item:Starlight velvet cloak with a missing clasp
Item:Starlight velvet prayer mat embroidered with a cloven great helm
Item:Starlight velvet prayer mat embroidered with a ship
Item:Starlight velvet ribbons
Item:Trim-sized piece of starlight velvet fabric
Large bolt of starlight velvet fabricFabric Fantasies (5) Fabric Fantasies (2)Fabric Fantasies (1)
Large case constructed from a series of metal cogsPuffindor's Professional Pieces (3) Puffindor's Professional Pieces (2)Puffindor's Professional Pieces (1)
Layered starlight velvet robe with an intricately knotted sashTurialo's Haven (8) Turialo's Haven (4)
Medium bolt of starlight velvet fabricFabric Fantasies (5) Fabric Fantasies (2)Fabric Fantasies (1)
Midnight black cire kimono sashed with starlight velvetHollow Eve Festival 421/Raffles
Midnight-blue blanket with stunning starlight velvet trim
Midnight-hued Phelim's Bliss rose made of glittering starlight velvetTildi's Blooms (3) Tildi's Blooms (2)Tildi's Blooms (1)
Off-the-shoulder moonsilk gown with a navy starlight velvet bodiceDamsel In This Dress (2)
Pair of leather-soled sandals fastened with thin starlight velvet ribbonsTildi's Blooms (3)
Pale blue moonsilk astronomy case secured with nightfire opal starsPuffs of Glitter (3)
Pale starlight velvet gathering purse clasped with a mauve fairy slipper orchidTildi's Blooms (3)
Polished e'erdream telescope case with merlot ruby-inlaid capsClear Visions (2)
Polished gloomwood telescope case with rivertear-inlaid capsClear Visions (2)
Prayer mat of blue starlight velvetHuldah Shrine prizes 406
Purple sea urchin with plush spinesMagical Minions (3)
Regal starlight velvet handbag cinched in at the sides with gold cordingExcess Baggage (1)
Ruched starlight velvet pack fastened with shimmering nightfire opalsPuffs of Glitter (3)
Silver dragonar vest edged with banded starlight velvetNatural Beauty (4)festival
Slim compendium bound with plush starlight velvetGersvinda's Natural Studies (2), Gersvinda's Natural Studies (2)
Small bolt of starlight velvet fabricFabric Fantasies (5) Fabric Fantasies (2)Fabric Fantasies (1)
Sophisticated starlight velvet cloak clasped with a Xibar-blue orbGlam and Grittyfestival