Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Ash (wood)]]OR[[Uses material::Ash (wood)]]
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
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
`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
20
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 186 | Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.id | 1 | Using 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='Ash (wood)')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=531181 - 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:4Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Weapon:Ash-handled war hammer | Flower Power, Flower Power (5) | |
Weapon:Ash-hilted oben with an enameled pommel | Flower Power (5) | |
Weapon:Ash-rubbed scimitar with a silver hilt | Ristmuir's Armory | |
Weapon:Axe (1) | Struan's Weapons and Armor, Struan's Weapons and Armor | |
Item:Backless cane-seat chair | Treywood Cottage Crafters | |
Weapon:Battered ash spear | Zombie kobold headhunter , Skeletal kobold headhunter | |
Item:Blackened steel skinning knife covered in ashes | treasure map | true |
Weapon:Boarding pike with a leaf blade | Curse of the Ghost Ship/Incidental Loot | |
Item:Bones | True Bard D'Or , Tall Human Peddler, Malik the True Bard | |
Item:Bow | True Bard D'Or , Teshi's Instruments, Malik the True Bard, Elepaio's Luthierre | |
Item:Brightly painted wooden mask | Focus on the Past (2) , Focus on the Past (1) | |
Item:Brown canvas jacket with ash buttons | Ithinnu's Clothier and Cobbler (2) , Ithinnu's Clothier and Cobbler (1) | true |
Item:Carved ash cufflinks inset with ivory | Knightly Attire (1) | |
Item:Carved blue ash haircomb with edges shadowed by cobalt ink | All Tressed Up (2) | true |
Weapon:Cracked ash spear | Zombie kobold headhunter , Skeletal kobold headhunter | |
Weapon:Curlade (1) | Struan's Weapons and Armor, Struan's Weapons and Armor | |
Weapon:Curving ash-hafted halberd embossed with knotwork vines | Pointed Ramarck's, Pointed Ramarck's | |
Item:Damask-lined flower basket crafted from white ash | Tildi's Flowers (2) | |
Item:Delicate ash necklace carved into a strand of Elven ivy | Turialo's Haven (8) , Turialo's Haven (4) | |
Item:Delicate ash necklace carved into a strand of elven ivy | ||
Item:Delicate pixie | Whittler Roakin | |
Item:Delicate wooden fife inlaid with ebony | That's a Wrap | true |
Item:Dining table with white legs | Heikea (2) , Heikea (1) | |
Weapon:Double-stringed crossbow with a carved teak stock | Curse of the Ghost Ship/Incidental Loot | |
Item:Dusty archeologist's satchel covered in archaic palimpsest | Su Helmas 438: The Forbidden Temple/Raffle | true |
Item:Ebony lyra viol | Gadelica's Riches for the Reverent (4) , Gadelica's Riches for the Reverent (3) | |
Item:Elegant clay pipe carved with a flurry of snowflakes | ||
Item:Elegantly-carved ash closet | Frother's Beasts | |
Item:Enelne statuette | Visfarej Cehs (obsolete) , Visfarej Cehs | |
Weapon:Fang-like curved steel dagger with a cabochon peridot pommel stone | Pointed Ramarck's | |
Item:Fiddle | True Bard D'Or , House of Bardic Blues | |
Weapon:Flail (2) | Struan's Weapons and Armor | |
Item:Flawed crystal cube | ||
Item:Flute | True Bard D'Or , Sinjian's Bardic Requisites, Elepaio's Luthierre | |
Item:Gittern | Malik the True Bard | |
Item:Glossy ash origami case embellished with a spring scene | Order of the White Rose/Gifts and prizes | |
Item:Glossy howlite varna grasping a Katamba-black onyx sphere | Limited Treasures (4) , Item:Katamba-black shadesatin odaj secured with a howlite varna | |
Weapon:Gnarled ash staff topped with a piece of cambrinth carved into the shape of a fist | Morum Melgorehn/End loot | |
Item:Gnarled ash staff topped with a weathered copper owl | Dunshade: Echo of Tears/End loot | |
Item:Graceful ash cittern inlaid with an ebony compass rose | Nytingale's Instruments (9) | |
Item:Green imbuement rod fashioned from ash wood | Tool as a Cucumber | true |
Item:Guild Leader Kalika doll | Great Outdoors (5) , Great Outdoors (4), Great Outdoors (3), Great Outdoors (2), Great Outdoors (1) | |
Weapon:Hammer | Struan's Weapons and Armor, Struan's Weapons and Armor | |
Item:Handwoven ash fishing creel | Zivis Cehs | |
Weapon:Heavy ash quarterstaff bound in iron at both ends | Lugdon's Wagon | |
Weapon:Heavy ash-handled maul with a fireball-shaped steel head | War and Craft (2) , War and Craft (1) | |
Weapon:Heavy boar spear with spiked wings behind the blade | Dwarven Deals | |
Item:Hollow Eve 399 gift | ||
Item:Inlaid ash and iroko wall with a design of bare trees against a full moon | Trees Four Walls | true |
Weapon:Iron-studded footman's flail | Milgrym's Weapons |