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::Snow opal]] OR [[Uses material::Snow opal]]
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
1SIMPLEt1ALLPRIMARY68Using 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='Snow opal')
      INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=90069
  • 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
Competition miniature squad of sea turtles wielding conch shellsHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesincidental
Dainty bogbirch cosmetic basket adorned with colorful ribbonsEverlasting Beauty (3)festival
Diaphanous silk dance veil adorned with blossomsHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Dramatic cloak fastened with a claspHollow Eve Festival 447/Game prizes Hollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizesincidental
Elaborately dressed puppet with eyesHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Etched briquet marked with a simple blossomBreaking and Entering/Armory loot
Exquisite haircomb twined in blossomsBreaking and Entering/Bedroom loot
Feathery seaweed fronds dappled with swirlsHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizes
Filigree earrings threaded with beadsBreaking and Entering/Bedroom loot
Flowing robes flecked with tiny dropletsHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesincidental
Full plate bearing a crestBreaking and Entering/Armory loot
Fuzzy dolphin slippers with large eyesHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Glittery parry stick with faceted endsHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
HE2020Gemstones
Heart-shaped filigree locket inlaid with chipsBreaking and Entering/Bedroom loot
Heavily embroidered sash with gemstone fractalsHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizesincidental
Heavy ice-veined leather cloak lined with thick meshor fox furtreasure maptreasure map
Hollow Eve Festival 436/Game prizes
Hollow Eve Festival 436/Game prizes/Material options
Interlocking miniature tridentsHollow Eve Festival 443/Game prizes Hollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Iridescent filaments strung with starsHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 436/Game prizes
Item:Midnight blue silk dress with slashed flowing sleeves
Item:Whimsical black and white marblesilk gown with raw silk texturing
Item:White silk robe shot through with ice blue threads
Jaunty fedora accented with a small sharkHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
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 crystal prism suspended from a fine chainBreaking and Entering/Sanctum 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
Midnight blue silk dress with slashed flowing sleevesNoble Winter Night
Miniature polar bear with round eyesHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizes
Ornate cambrinth chain interspersed with beadsHollow Eve Festival 447/Game prizes Hollow Eve Festival 436/Game prizes
Pair of platinum hair combs with dangling snow opalsNoble Winter Night
Petite lap harp inlaid with bloomsBreaking and Entering/Library lootcommon
Polished imbuement rod flecked with sliversBreaking and Entering/Work Room lootcommon
Polished medal encircled by tiny sea turtlesHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Polished wand topped with a starfishHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizesincidental
Polished yardstick set with markingsBreaking and Entering/Work Room lootcommon
Round green bota in the shape of a turtle with eyesHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizes
Silvery blue mail set with a burnished gold chestpiece edged in snow opalsElahkti's Metal Arts (2) Elahkti's Metal Arts (1)
Simple burin with spiralsBreaking and Entering/Work Room lootcommon
Slender choker strung with beadsBreaking and Entering/Bedroom loot
Slender eyebrow ring dangling a sigilHollow Eve Festival 447/Game prizes Hollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizesincidental
Slender steel skinning knife with a gemstone pommelHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Small jewelry box inlaid with shardsBreaking and Entering/Bedroom loot
Small keepsake box inlaid with shardsBreaking and Entering/Bedroom loot
Small treasure chest set with embellishmentsHollow Eve Festival 443/Game prizes Hollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Small trident graced with tipped prongsHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizesincidental
Strands of snow opalsAll Tressed Up (2) All Tressed Up (1)festival