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::Haon]] OR [[Uses material::Haon]]
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
1SIMPLEt1ALLPRIMARY110Using 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='Haon')
      INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=79969
  • 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
Cracked haon mirror painted with a cadaverous figureDrathrok's Duskruin 442/Drathrok's AssemblageDrathrok's Duskruin 438/Drathrok's AssemblageDrathrok's Duskruin 435/Drathrok's AssemblageDrathrok's Duskruin 448/End Loot Drathrok's Duskruin 446/Drathrok's Assemblageend loot
Cracked haon wandHarawep Shrine 405
Curlade (1)Struan's Weapons and Armor, Struan's Weapons and Armor
Dainty comb carved with blossomsBreaking and Entering/Bedroom loot
Dainty cowbell fit with a polished handleBreaking and Entering/Library loot
Etched briquet marked with a simple blossomBreaking and Entering/Armory loot
Feathery seaweed fronds dappled with swirlsHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizes
Finely polished haon lockbowtreasure maptreasure map
Flail (2)Struan's Weapons and Armor
Folding chair with a cushioned seatHollow Eve Festival 443/Game prizes Hollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Fragile cubeBreaking and Entering/Bedroom loot
Fragile sea globe with a polished baseHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Fringed haon-hilted whipFangs For the Memory (1)
Glazed haon keg painted with a blazing red sunLeth Deriel Faire 416 raffles
Greased haon stick affixed with an elegantly written labelBoundless Beautyfestival
HE2020Woods
HammerStruan's Weapons and Armor, Struan's Weapons and Armor
Haon arbalest with a series of small notches cut into the stockDrathrok's Duskruin 442/Incidental lootDrathrok's Duskruin 438/Incidental lootDrathrok's Duskruin 435/Incidental lootDrathrok's Duskruin 448/Incidental loot Drathrok's Duskruin 446/Incidental loot
Haon hairbrush carved with lotus blossomsBacon Man's Birthday Bash 419/Pig Maze
Haon hairbrush carved with lotus blossoms on the handleBacon Man's Birthday Bash 419/Pig Maze
Haon staff sling with woolen whipcordsOutrageous Fortune
Haon-hafted hunting spear adorned with parrot feathersWise Weapons (2) Wise Weapons (1)
Heart-shaped ruby framed mirror with an oval haon handleDrathrok's Duskruin 442/Incidental lootDrathrok's Duskruin 438/Incidental lootDrathrok's Duskruin 435/Incidental lootDrathrok's Duskruin 448/Incidental loot Drathrok's Duskruin 446/Incidental loot
Heavy steel-headed tzece with an engraved haon handleCorik's Secret: Treasures of the Tomb/Incidental loot
Hexagonal haon mirror reflecting a person's buildTaisidon Mystery 446/A'baya Esplanade Taisidon Mystery 443/A'baya EsplanadeTaisidon Mystery 439/A'baya EsplanadeTaisidon Mystery 435/A'baya EsplanadeReturn to the Keep 431/Supply Wagonend loot
Hollow Eve 399 gift
Hollow Eve Festival 436/Game prizes
Hollow Eve Festival 436/Game prizes/Material options
Item:Cracked haon wand
Item:Hollow Eve 399 gift
Item:Terrifying North Wind banshee hand-puppet
Jewelry pestMishli Hollow Eve Festival 447gift
Lacquered abacus strung with polished beadsHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Lacquered band set with a tiny clownfishHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Large portrait framed in woodBreaking and Entering/Library loot
Latticed picnic basket tied with sea ottersHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizesincidental
Long mixing stick topped with a trio of bloomsBreaking and Entering/Kitchen lootcommon
Loose-fitting pajama top with polished buttonsBreaking and Entering/Bedroom loot
Maul (1)Wood Troll (2) Struan's Weapons and Armor
Mesh sieve with a polished handleBreaking and Entering/Kitchen lootcommon
Metal scissors with wood handlesBreaking and Entering/Work Room lootcommon
Miniature toy crossbow composed of woodBreaking and Entering/Armory loot
Miniature turtlesHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Narrow recipe box with hingesBreaking and Entering/Kitchen loot
Narrow steel-bladed kitchen knife with an engraved handleBreaking and Entering/Kitchen loot
Pair of blue-tinged haon eyebrow rings incised with star-like browallia bloomsTildi's Blooms (2)
Pair of dice with shell-shaped pipsHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Pair of goose turd-hued jaalmin boots with oval haon heelsGive 'Em the Boot (4) Give 'Em the Boot (3)
Pair of polished haon bongos inset with thin skeins of lapis lazuliEstate Holder gifts
Pair of unevenly-hued red rosecloth boots aloft hollow spherical heelsGive 'Em the Boot (8)