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::horseshoe]]
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_blob` AS t1
INNER JOIN
  `t2` AS t2 ON t1.p_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
  (
   (t1.o_hash='horseshoe')
  )
  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
  10
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt2ALLPRIMARY2Using temporary; Using filesort
1SIMPLEt1refs_id, p_id, o_hash, s_id_2p_id262drwiki.t2.id, const15Using index condition
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4drwiki.t1.s_id1Using where
Auxilliary Tables
  • Temporary table t2
      Recursively computed hierarchy for element(s) (2021227).
      SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
ItemSource isRare item
Chestnut horsehide arm pouch with fringed leather drawstringsPerformance Portage (2) Performance Portage (1)
Chestnut horsehide journey pack with fringed leather drawstringsPerformance Portage (2) Performance Portage (1)
Chestnut horsehide shoulder sack with fringed leather drawstringsPerformance Portage (2) Performance Portage (1)
Chestnut horsehide thigh bag with fringed leather drawstringsPerformance Portage (2) Performance Portage (1)
Crescent horsehide shieldFaithful Defender, Faithful Defender (2) Faithful Defender (1)
Crooked steel horseshoe stamped with the crest of the Rangers' GuildToss-O-Rama, Toss-O-Rama
Dimpled steel horseshoe stamped with the crest of the Empaths' guildToss-O-Rama
Enveloping cloak of soft black cashmere clasped with a sterling silver horseshoePerfect Rose (2)
Fire-hardened steel horseshoe stamped with the crest of the Warrior Mage GuildToss-O-Rama, Toss-O-Rama
Gold and diamond horseshoe ringBlood and Gourd (4) Blood and Gourd (3)Blood and Gourd (2)Blood and Gourd (1)
Hand-tooled horsehide saddle bags with silver lioness buckles
Horseshoe (crafted)false
Horseshoe pin set with brown topazSibtiem's Creations
Ice-veined leather saddlebag clasped with silversteelLimited Treasures (3)
Item:Black leather thigh quiver with a sterling silver horseshoe clasp
Item:Blackened steel belt hook with an embossed leather hip guard
Item:Brown leather vest with gold buckles
Item:Carved dark oak desk
Item:Chestnut cashmere hooded cloak lined with soft dark sable
Item:Enveloping cloak of soft black cashmere clasped with a sterling silver horseshoe
Item:Gold and diamond horseshoe ring
Item:Horseshoe pin set with brown topaz
Knobby steel horseshoe stamped with the crest of the Barbarians' GuildToss-O-Rama
Large horseshoe (crafted)false
Loosely fitted pale muslin shirt clasped at the cuffs with gold horseshoesItem:Rugged leather pack clasped with an iron horseshoe 6th-Year Estate Holder Token Auctiontrue
Pitted steel horseshoeToss-O-Rama, Toss-O-Rama
Pitted steel horseshoe stamped with the crest of the Clerics' GuildToss-O-Rama
Polished steel horseshoe stamped with the crest of the Traders' GuildToss-O-Rama, Toss-O-Rama
Rugged leather pack clasped with an iron horseshoe6th-Year Estate Holder Token Auctiontrue
Rusty steel horseshoe stamped with the crest of the Bards' GuildToss-O-Rama, Toss-O-Rama
Shadowy black horseshoe inset with an onyx heronToss-O-Rama, Toss-O-Rama
Shield:Crescent horsehide shield
Steel horseshoe inlaid with pink sapphiresToss-O-Rama, Toss-O-Rama
Steel horseshoe labeled "Nose Breaker"Toss-O-Rama, Toss-O-Rama
Twisted steel horseshoe stamped with the crest of the Moon Mage GuildToss-O-Rama, Toss-O-Rama
Weapon:Acid-etched steel horseshoe stamped with the crest of the Paladins' Guild
Weapon:Blackened steel horseshoe inlaid with an emerald four-leaf clover
Weapon:Blackened steel horseshoe inlaid with crossed garnet roses
Weapon:Blackened steel horseshoe stamped with the crest of the Thieves' Guild
Weapon:Blood-red horseshoe inlaid with an ivory skull and crossbones
Weapon:Crooked steel horseshoe stamped with the crest of the Rangers' Guild
Weapon:Dimpled steel horseshoe stamped with the crest of the Empaths' guild
Weapon:Fire-hardened steel horseshoe stamped with the crest of the Warrior Mage Guild
Weapon:Knobby steel horseshoe stamped with the crest of the Barbarians' Guild
Weapon:Large horseshoe (crafted)false
Weapon:Pitted steel horseshoe
Weapon:Pitted steel horseshoe stamped with the crest of the Clerics' Guild
Weapon:Polished steel horseshoe stamped with the crest of the Traders' Guild
Weapon:Rusty steel horseshoe stamped with the crest of the Bards' Guild
Weapon:Shadowy black horseshoe inset with an onyx heron