Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::harawep||spider]]
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='harawep') OR (t1.o_hash='spider')
))
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
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='harawep') OR (t1.o_hash='spider')
))
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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | range | s_id, p_id, o_hash, s_id_2 | o_hash | 258 | 818 | Using index condition; Using temporary; Using filesort | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.s_id | 1 | Using where | |
1 | SIMPLE | t2 | eq_ref | PRIMARY | PRIMARY | 4 | drwiki.t1.p_id | 1 | Distinct |
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:3Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Item:Ash-grey spider with the image of a golden coin decorating its abdomen | Accents for the Arachnophile (1) | |
Atulave | ||
Item:Audrualm spider with barbed legs and oversized chelicerae | Accents for the Arachnophile (2) | |
Weapon:Audrualm-legged blade spider | ||
Item:Aurulent sanowret crystal set in a platinum wildling spider | Accents for the Arachnophile (7) , Accents for the Arachnophile (6), Accents for the Arachnophile (5) | |
Item:Banded grass spider with long spinnerets | Thorkim Family Farm 429/Pig Maze | |
Item:Biomechanical tarantula | Hollow Eve Festival 432 | true |
Item:Black backpack shaped like a spider | Scarlett's Web Race | |
Item:Black beaded handbag set with a silver spider clasp | Packrat's Piece of Paradise (3) , Packrat's Piece of Paradise (2), Packrat's Piece of Paradise (1) | |
Item:Black cambrinth blade spider | Underground | |
Item:Black goodie bag decorated with gold spiders | Dark Delights | |
Item:Black high-heeled sandals with long thin straps | Whimsies (1) | |
Item:Black iron spider inset with a multitude of glittering gemstones | All Wound Up (2) | |
Item:Black jumping spider with iridescent blue chelicerae | Thorkim Family Farm 429/Pig Maze | |
Item:Black leather cloak with a onyx spider clasp | Underground | |
Item:Black linen robe adorned with the shark of Drogor | Hollow Eve Festival 417/Raffles | |
Item:Black linen robe adorned with the spider of Harawep | Hollow Eve Festival 417/Raffles | |
Item:Black metal vial etched with a huge spider | Visions of Holiness (2) | |
Item:Black onyx spider with an intricate white web design on its abdomen | Accents for the Arachnophile (1) | |
Armor:Black pard leathers with an albino spider enameled on the chest | Underground | |
Item:Black plush spider wearing a grass skirt | This 'N' That (7) , This 'N' That (6) | |
Item:Black pouch embroidered with a black widow | Droughtman's Challenge 444/End loot , Droughtman's Challenge 441/End loot | true |
Item:Black shadesatin rosette set with a gloomwood medallion | Obscure Memories (2) | |
Item:Black shadowbark ghironda with a painted wiirwood wheel | Item:Polished gold moradu-bone harp case , Hollow Eve Festival 425/Auction | |
Item:Black silk fan with a gold spider rivet | Bacon Man's Birthday Bash 419/Pig Maze | |
Item:Black socks shot through with silver strands forming intricate webs | Nahja's Knickknacks (4) , Nahja's Knickknacks (3), Nahja's Knickknacks (2), Nahja's Knickknacks (1) | false |
Item:Black spider pinata | In The Hollow (2) | |
Item:Black spidersilk knapsack featuring a web design | Great Outdoors, Great Outdoors (5) | |
Item:Black velvet cloak embroidered with a silvery web upon which sits an onyx spider | Eden's Parlour | |
Item:Black vest with a white spider web embroidered on its pocket | Bacon Man's Birthday Bash 419/Pig Maze | |
Item:Black widow spider (1) | Heavenly Entrances (1) | |
Item:Black widow stamp | Stamped! , Barbarian Paradise | |
Item:Black-clad priestess of Harawep bobblehead | Mordiv's Fun House (3) | |
Armor:Blackened chain gloves fixed with tarnished steel wrist guards | Item:Dusky-blue basilisk hide satchel decorated with ur hhrki'izh claws along the flap , Item:Dusky-blue basilisk hide satchel decorated with ur hhrki'izh claws along the flap, Curse of the Ghost Ship/End Loot | |
Item:Blackened leather armband seared with the image of a rampant wolf spider | Accents for the Arachnophile (2) | |
Item:Blackened metallic pinwheel centered with a bright red spider | Greeter Gifts | |
Item:Blackened moonsilver spider icon poised to display a blood ruby hourglass | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade, Taisidon Mystery 439/A'baya Esplanade, Taisidon Mystery 435/A'baya Esplanade | true |
Weapon:Blackened steel bastard sword with a carved spider pommel | Obscure Memories (6) , Obscure Memories (3), Obscure Memories (1) | |
Weapon:Blackened steel broadsword with silver spiders etched along the blade | Obscure Memories (6) , Obscure Memories (3), Obscure Memories (1) | |
Item:Blade spider knapsack crafted from fuzzy black felt | Packrat's Piece of Paradise (3) , Packrat's Piece of Paradise (2), Packrat's Piece of Paradise (1) | |
Item:Blade spiderling | Accents for the Arachnophile (7) | |
Weapon:Bleached bone trident bearing intricate carvings (1) | Piralpa Tridents (2) , Piralpa Tridents (1) | |
Weapon:Bleached bone trident bearing intricate carvings (2) | ||
Item:Bloated black spider pinata | In The Hollow (2) , In The Hollow (1) | |
Item:Blood-red spider with the crest of the Empaths' Guild etched into its abdomen | Accents for the Arachnophile (1) | |
Item:Bloodwood hide scraper branded with a multitude of black spiders | Great Outdoors (4) , Great Outdoors (2), Great Outdoors (1) | true |
Item:Bone glass spider pendant | Item:Silvery party cracker | |
Item:Bone recorder criss-crossed with an elaborate web | Dark Symphony (2) , Dark Symphony (1) | |
Item:Bone-white spider with a pair of monstrous red eyes decorating its abdomen | Accents for the Arachnophile (1) | |
Item:Braided gold toe ring etched with fine spider web designs | Pi'botuk Pel'arsharra |