Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Item type is::Maul]]
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
INNER JOIN
`t2` AS t2 ON t1.p_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=46481)
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
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
INNER JOIN
`t2` AS t2 ON t1.p_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=46481)
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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 2 | Using temporary; Using filesort | ||||
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, drwiki.t2.id | 1 | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) (2021226).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021226 LIMIT 1
Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item | Is incomplete |
---|---|---|---|
Weapon:Femur-blasting maul | Togs for Togs (3) , Togs for Togs (2), Togs for Togs (1) | ||
Weapon:Gargantuan animite-studded maul | true | ||
Weapon:Haledroth maul fashioned from a broken anchor | Taisidon Mystery 446/A'baya Esplanade | true | |
Weapon:Heavy ash-handled maul with a fireball-shaped steel head | War and Craft (2) , War and Craft (1) | true | |
Weapon:Indurium maul with an ebony handle | Droughtman's Challenge 426/End loot | ||
Weapon:Iron splitting maul with an ironwood handle | Hollow Eve Festival 410/Raffles | ||
Weapon:Iron-studded maul | Curiosities In Coral | true | true |
Weapon:Long-handled throwing maul with a spiked head | Toss-O-Rama, Toss-O-Rama | true | |
Weapon:Massive black steel maul | Maelshyvean cinder beast | true | |
Weapon:Massive kertig maul with gnarled smokewood haft | Sleeping Dragon Corn Maze 425/End loot | ||
Weapon:Maul (1) | Wood Troll (2) , Struan's Weapons and Armor | ||
Weapon:Maul (2) | |||
Weapon:Maul (bone) | false | ||
Weapon:Maul (metal) | false | ||
Weapon:Maul (stone) | false | ||
Weapon:Maul with a wedge-shaped granite head | Squat Bungalow (1) , Corik's Secret: Treasures of the Tomb/Incidental loot | true | |
Weapon:Monstrous star-kissed kertig maul | Item:Imperial weave rucksack set with an etched fracturing goldfyre medallion , Droughtman's Challenge 444/Raffle | true | |
Weapon:Multi-hued maul with snow owl feathers hanging | Over The Edge | true | |
Weapon:Multi-hued maul with snow owl feathers hanging from its grip | Over the Edge (1) | true | |
Weapon:Oak-handled maul | Osmandikar's Crafts and Repairs | true | |
Weapon:Oversized kertig maul capped with a viciously sharp warklin impaler | Drathrok's Duskruin 442/Incidental loot, Drathrok's Duskruin 438/Incidental loot, Drathrok's Duskruin 435/Incidental loot, Drathrok's Duskruin 430/Incidental loot, Drathrok's Duskruin 426/Incidental loot, Drathrok's Duskruin 422/Incidental loot, Drathrok's Duskruin 421/Incidental loot, Drathrok's Duskruin 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot | ||
Weapon:Polished steel maul with an iroko handle | To The Hammer Born (2) , To The Hammer Born (1) | true | |
Weapon:Splitting maul with a brass-banded oak handle | Survivalist Supplies, Survivalist Supplies | ||
Weapon:Splitting maul with a carved ebony handle | Survivalist Supplies, Survivalist Supplies | ||
Weapon:Splitting maul with a leather-wrapped oak handle | Survivalist Supplies, Survivalist Supplies | true | |
Weapon:Double coyote-headed maul with a solid chain shaft | |||
Weapon:Engraved silverwillow-shafted maul with a cambrinth-studded steel head | |||
Weapon:Gargantuan animite-studded maul | true | ||
Weapon:Heavy ash-handled maul with a fireball-shaped steel head | true | ||
Weapon:Iron splitting maul with an ironwood handle | |||
Weapon:Long-handled throwing maul with a spiked head | true | ||
Weapon:Massive black steel maul | true | ||
Weapon:Maul | |||
Weapon:Maul (bone) | false | ||
Weapon:Maul (metal) | false | ||
Weapon:Maul (stone) | false | ||
Weapon:Maul with a wedge-shaped granite head | true | ||
Weapon:Multi-hued maul with snow owl feathers hanging | true | ||
Weapon:Multi-hued maul with snow owl feathers hanging from its grip | true | ||
Weapon:Oak-handled maul | true | ||
Weapon:Woodworker's maul with a leather-wrapped walnut handle | |||
Weapon:Windsteel maul with a speckled spiritwood haft | Ties for Things (6) , Ties for Things (5), Ties for Things (4), Ties for Things (3) | ||
Weapon:Woodworker's maul with a leather-wrapped walnut handle | Prison Riot: The Aftermath/Incidental loot |