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 material::Cocobolo]]
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
  `smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
  (t1.p_id=2021246 AND t1.o_id=89159)
  AND 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
  20
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt1refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3o_id5const124Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4drwiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
ItemSource isRare item
Item:Folding chair with a cushioned seatHollow Eve Festival 443/Game prizes Hollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Item:Fragile cubeBreaking and Entering/Bedroom loot
Item: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
Weapon:Gargantuan Kerenhappuch war icon set atop a chiseled haft of cocoboloMisenseor Goods (5) Misenseor Goods (3)
Item:GemshornTeshi's Instruments
Item:Glossy cocobolo clarinet with brass keysMusiceum (3) Musiceum (2)Musiceum (1)
Item:Glossy honey-hued tea hamper woven out of cocoboloTea For Tamsine (3) Tea For Tamsine (2)
Template:HE2020Woods
Weapon:Heavy cocobolo crossbow painted with a macabre smiling skullDying to Shop (1)
Item:HichirikiTeshi's Instruments
Item:Hollow Eve 399 gift
Talk:Hollow Eve Festival 436/Game prizes
Hollow Eve Festival 436/Game prizes/Material options
Item:Bow
Item:Castanets
Item:Cistre
Item:Cocobolo flute with blackened leech-shaped keys
Item:Drum stick
Item:Faenellica
Item:Gemshorn
Item:Hichiriki
Item:Hollow Eve 399 gift
Item:Kithara
Item:Medium case
Item:Mirliton
Item:Naqqara
Item:Pick
Item:Rebec
Item:Small case
Item:Syrinx
Item:Tipper
Item:KitharaTeshi's Instruments
Item: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
Item: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
Item:Large portrait framed in woodBreaking and Entering/Library loot
Item: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 prizestrue
Item:Leather chest harness beaded with cocoboloTies for Things (5) Ties for Things (4)Ties for Things (3)Ties for Things (2)Ties for Things (1)
Item:Long mixing stick topped with a trio of bloomsBreaking and Entering/Kitchen lootfalse
Item:Loose-fitting pajama top with polished buttonsBreaking and Entering/Bedroom loot
Item:Lustrous cocobolo cigarillo caseSmokes 'n' Spirits
Item:Medium caseTrue Bard D'Or Teshi's InstrumentsMalik the True BardElepaio's Luthierre
Item:Mesh sieve with a polished cocobolo handle
Item:Mesh sieve with a polished handleBreaking and Entering/Kitchen lootfalse
Item:Metal scissors with wood handlesBreaking and Entering/Work Room lootfalse
Weapon:Miniature toy crossbow composed of woodBreaking and Entering/Armory loot
Item:Miniature turtlesHollow Eve Festival 447/Game prizes Hollow Eve Festival 443/Game prizesHollow Eve Festival 439/Game prizesHollow Eve Festival 436/Game prizes
Item:MirlitonTeshi's Instruments Sinjian's Bardic Requisites
Item:NaqqaraTeshi's Instruments
Item:Narrow recipe box with hingesBreaking and Entering/Kitchen loot
Weapon:Narrow steel-bladed kitchen knife with an engraved handleBreaking and Entering/Kitchen loot