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::Mistglass]] OR [[Uses material::Mistglass]]
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
1SIMPLEt1ALLPRIMARY220Using 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='Mistglass')
      INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=209821
  • 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
Bluefire velvet storybook rose accented with mistglass leavesTildi's Blooms (3) Tildi's Blooms (2)Tildi's Blooms (1)festival
Brazen blue-white mistglass anklet encrusted with haze sapphiresUwresari's Exotic Wonders (2) Uwresari's Exotic Wonders (1)
Briar-covered cane surmounted with a coy mistglass weaselHuldah Shrine prizes 421 Huldah Shrine prizes 410Huldah Shrine prizes 406
Brilliant gold windboard shaped like a lightning boltDrathrok's Duskruin 442/Drathrok's AssemblageDrathrok's Duskruin 438/Drathrok's AssemblageDrathrok's Duskruin 435/Drathrok's AssemblageDrathrok's Duskruin 430/Drathrok's AssemblageDrathrok's Duskruin 448/End Loot Drathrok's Duskruin 446/Drathrok's Assemblageend loot
Broken orlog charm with a face of deep green anjisisAhreusse's Atelier (4) Ahreusse's Atelier (3)
Cambrinth torque featuring alternating pieces of mistglassHollow Eve Festival 439/Auctionauction
Carved mistglass bell shaped like a spider arced over a cloud ruby clapperHollow Eve Festival 425/Raffles
Celeste-blue spun glitter slippers with crescentic mistglass heelsLimited Treasures (1) Item:Celeste-blue spun glitter cloak with an Elven snowlace overlay and sweeping train
Chipped mist glass vase filled with dead dusk rosesOnce Possessed (2)
Clouded white mistglass sackbut designed to resemble spiderwebbingWhimsical Winds (5)
Clump of cambrinth and green jade endives on a blue mistglass chain
Commemorative coin with rippled edgesHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Competition miniature Merelew soldier wielding a tiny tridentHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesincidental
Crescentic fascinator bearing mistglass rolo chains with midwinter's sickle tipsLimited Treasures (1)
Curving mistglass flagon with a vaulted dome lidOde to Glythtide (1)
Dangling pair of concentrenic hoop earrings cradling riftstone starburstsLimited Treasures (6)festival
Deceptively fragile-looking tail guard of mistglass mailHashal's Haven
Deep blue mistglass phylactery with a braided silk strapOnly The Holy (2) Only The Holy (1)
Deep purple cinquedeaUwresari's Exotic Wonders (1)
Delicate black top hat trimmed in zerarin laceDamsel In This Dress (4) Damsel In This Dress (1)
Delicate bracelet of interlocking striped seaperchHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Delicate mistglass pilonu decorated with petite spectrolite orbsLimited Treasures (3)
Demure heliotrope orchid mantisLimited Treasures (2)
Diamond-shaped window with mistglass panesPane in the Glass
Double-necked cross-strung harp of white mistglass inlaid with scenes from the life of LanivalHollow Eve Festival 432/Auctionauction
Dragonfly-shaped loimic pin with blue mistglass wingsLooty Booty (2)festival
Electroweave cowl studded in white mistglassHollow Eve Festival 443/Raffles Item:Electroweave carryall embroidered with a sinuous leviathan
Elegant mistglass coronet crowned with an empty settingEmpty Settings (2)
Elegant spiritwood keepsake box inlaid with intricate mistglass whorlsLimited Treasures (3)
Elegantly recurved Elothean battle bow of stormtouched smokewoodDroughtman's Challenge 437/Raffleauction
Elven snowlace choker dangling a mistglass-tipped midwinter's sickleLimited Treasures (1)
Enormous mistglass saucer with a ghostly-white sheenHollow Eve Festival 439/Auctionauction
Exquisitely pale mistglass compact patterned with delicate rose petalsSleeping Dragon Corn Maze 447/End loot Sleeping Dragon Corn Maze 443/End lootSleeping Dragon Corn Maze 439/End lootSleeping Dragon Corn Maze 436/End lootSleeping Dragon Corn Maze 432/End lootend loot
Fat blue mistglass mixing stick inlaid with a silvery white moon coralGarden of Plentyfestival
Fine steel knitting needles topped with tiny blue mistglass orbsSnacky Happiness (2)festival
Forked tomiek pickaxe with a mistglass handleSkyward Crafting (8) Skyward Crafting (7)Skyward Crafting (6)festival
Fortune's Star diamond pin caught within an intricate mistglass maze
Fragile blossom with delicate petalsHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizesincidental
Fragile blue-white mistglass anklet constructed from a slew of gearsSmaller Side of Life (3) Smaller Side of Life (2)festival
Frosted glass koto depicting gold limned cranesItem:Instrument case of white mistglass with flame-shaped indurium clasps
Frosted seaglass cowbell inlaid with sea-calves along the rimHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizesfestival
Gallant mistglass eternity band studded with shards of uncut eldringItem:Square spiritwood keepsake box with an intricate mistglass latch Limited Treasures (3)
Ghostly white mistglass phial interlaced with nielloItem:Jacinthe dragonfire brocade makeup reticule suspended on silversteel chains Hollow Eve Festival 425/Auction
Gleaming warrior's shield edged in white mistglassHollow Eve Festival 432/Auctionauction
Gleaming white mistglass scepter scattered with red diamondsHollow Eve Festival 439/Auctionauction
Glimmery mistglass nyad captured by a delicate silver chainTildi's Blooms (4) Tildi's Blooms (3)
Gloomwood cane set with a blue mistglass orbCute as a Button (2)
Gloomwood kaleidoscope inlaid with silverClear Visions (1)
Gloomwood telescope case with mistglass capsClear Visions (1)
Gnarled gloomwood recurve bow with a translucent white mistglass gripHollow Eve Festival 399/Auction