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::Clouded arzumos pelt]] OR [[Uses material::Clouded arzumos pelt]]
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
1SIMPLEt1ALLPRIMARY35Using 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='Clouded arzumos pelt')
      INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=307989
  • 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
Cured double leathers edged with strips of arzumos furOuter Beauty (3) Outer Beauty (1)
Dyed black-and-white striped arzumos pelt haversack with a korograth tooth closure
Heavy arzumos hide cloak stitched with intricate silver sigilsSquat Bungalow (1)
Heavy greatcloak with a thick mane of clouded arzumos furTools of the Trader
Item:Arzumos pelt pack
Item:Arzumos skin upholstered loveseat
Item:Arzumos-hide backpack clasped with a small piece of antelope horn
Item:Arzumos-pelt leathercommon
Item:Clouded arzumos pelt
Item:Dyed black-and-white striped arzumos pelt haversack with a korograth tooth closure
Item:Heavy arzumos hide cloak stitched with intricate silver sigils
Item:Primitive clouded arzumos fur longcoat secured by strips of sinew
Item:Slender arzumos fur belt with a carved shell buckle
Item:Striped arzumos fur with sapphire eyes
Item:Tribal war belt tethered with ghastly shrunken heads
Low-heeled boots trimmed with bands of arzumos furClothing Shop (2)
Pale leather sheath branded with a jungle landscapeOuter Beauty (2)
Primitive clouded arzumos fur longcoat secured by strips of sinewCall Of The Wild
Slender arzumos fur belt with a carved shell buckleOuter Beauty (3) Outer Beauty (1)
Striped arzumos fur with sapphire eyesTrue Path (3)
Striped arzumos-hide weapon strapTrading Post (3) Trading Post (2)
Thick arzumos hide cloak pyrographed with esoteric sigilsSquat Bungalow (2)
Thick arzumos pelt bootsFrom Top to Bottom (3) From Top to Bottom (2)From Top to Bottom (1)
Tribal war belt tethered with ghastly shrunken heads
Winged bootsItem:Gold-wrapped shoebox