Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Item type is::Quarterstaff||Quarter staff]]
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
INNER JOIN
`t3` AS t3 ON t1.o_id=t3.id) ON t0.smw_id=t1.s_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
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
INNER JOIN
`t3` AS t3 ON t1.o_id=t3.id) ON t0.smw_id=t1.s_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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t3 | 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 | 5 | drwiki.t3.id | 1 | ||
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) (2021226).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021226 LIMIT 1 - Temporary table t3
INSERT IGNORE INTO `t3` (id) VALUES (80033)
INSERT IGNORE INTO `t3` (id) VALUES (83044)
Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item | Is incomplete |
---|---|---|---|
Weapon:Charred wooden quarterstaff shod with copper end caps | Wise Weapons (2) , Wise Weapons (1) | ||
Weapon:Crystal-capped quarter staff wrapped in embossed white leather | It's Elemental, It's Elemental | true | |
Weapon:Damaris quarterstaff | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Sleeping Dragon Corn Maze 439/End loot, Aesthene's Close 449/End Loot | true | |
Weapon:Dark metal quarterstaff bracketed by a pair of ravens | |||
Weapon:Darkly stained ebony quarterstaff with black leather-wrapped grips | All Things Bardic (2) , All Things Bardic (1) | ||
Weapon:Diamondwood quarterstaff carved with vines | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Sleeping Dragon Corn Maze 439/End loot, Sleeping Dragon Corn Maze 436/End loot, Sleeping Dragon Corn Maze 432/End loot, Sleeping Dragon Corn Maze 428/End loot | true | |
Weapon:Elegant finivire quarterstaff | Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 438/Drathrok's Assemblage, Drathrok's Duskruin 435/Drathrok's Assemblage, Drathrok's Duskruin 430/Drathrok's Assemblage, Drathrok's Duskruin 426/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true | |
Weapon:Fine ebonwood quarterstaff wrapped with an ivory cloud eel | Wrath of the Storm (2) , Wrath of the Storm (1) | ||
Weapon:Glittery pink quarterstaff carved with images of frolicking fae | Droughtman's Challenge 444/End loot , Droughtman's Challenge 441/End loot, Droughtman's Challenge 437/End loot | true | |
Weapon:Gnarled bogbirch quarterstaff adorned with animal skulls | Aesthene's Close 449/End Loot | true | |
Weapon:Gnarled swamp cypress quarterstaff banded with muracite | House of the Revenant Fang 423/Incidental loot | ||
Weapon:Grey Raven guard's staff with spiked metal bandings (2) | Item:Gleaming platinum Grey Raven guard's ring , Item:Gleaming platinum Grey Raven guard's ring | ||
Weapon:Heavy ash quarterstaff bound in iron at both ends | Lugdon's Wagon | ||
Weapon:Ironwood quarterstaff with platinum bands | Ruins of Ulf'Hara/Supply Wagon , Return to the Keep 423/Supply Wagon | ||
Weapon:Kiralan quarterstaff shaped like a giant electric eel | Droughtman's Challenge 426/End loot | ||
Weapon:Lead-capped quarter staff carved with a spiraling chain of wolverines and centaurs | Vishlan's Wares (Crossing), Vishlan's Wares (Crossing) | true | |
Weapon:Lead-capped quarter staff wrapped with black and grey sharkskin | Vishlan's Wares (3), Vishlan's Wares (3) | true | |
Weapon:Long shadowbark quarterstaff wrapped in shreds of sickly purple-tinged sanguinai | Su Helmas 438: The Forbidden Temple/Raffle | true | |
Weapon:Muracite alchemist's quarterstaff engraved with lines of intersecting triangles | Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot , Aesthene's Close 445/Vault | true | |
Weapon:Quarter staff | S'lai scout | ||
Weapon:Quarterstaff | Zombie kobold savage , Skeletal kobold savage, Milgrym's Weapons (obsolete), Grizzled old war veteran | ||
Weapon:Quarterstaff (metal) | false | ||
Weapon:Quarterstaff (wood) | false | ||
Weapon:Quarterstaff capped with a blackened iron crow | Beyond the Barrier: The Devastation of Lyras/Incidental Loot | ||
Weapon:Simple finivire quarterstaff | Drathrok's Duskruin 422/Drathrok's Assemblage | ||
Weapon:Slender ironrot quarterstaff surmounted with a princess-cut temptress beryl | Droughtman's Challenge 444/Incidental loot | true | |
Weapon:Slender quarterstaff carved from smokewood and reinforced with audrualm tips | 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 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot | ||
Weapon:Slender rosewood quarterstaff with covellite tips | Sleeping Dragon Corn Maze 447/Incidental loot , Sleeping Dragon Corn Maze 439/Incidental loot, Sleeping Dragon Corn Maze 436/Incidental loot, Sleeping Dragon Corn Maze 432/Incidental loot, Sleeping Dragon Corn Maze 428/Incidental loot | ||
Weapon:Sludge-black quarterstaff inlaid with enameled butterflies | Tastelessly Tacky (7) | ||
Weapon:Stalwart ironwood quarterstaff | Milgrym's Weapons | ||
Weapon:Steel quarterstaff | What A Steel | true | |
Weapon:Stout quarter staff | Urglub's Squishing Emporium, Urglub's Squishing Emporium | ||
Weapon:Tamboti quarterstaff painted with a series of stylized Gnomes | |||
Weapon:Twisted kertig quarterstaff with a blackened wiirwood head | Beyond the Barrier: The Devastation of Lyras/End loot | ||
Weapon:Twisting oak quarter staff capped with a copper raccoon | Over The Edge | true | |
Weapon:Unstained deobar quarterstaff | Jhiskar's Provisions (4) , Jhiskar's Provisions (3), Jhiskar's Provisions (2) | ||
Weapon:Banded acanth quarterstaff | |||
Weapon:Banded ebony quarterstaff | true | ||
Weapon:Banded lunat quarterstaff | |||
Weapon:Crystal-capped quarter staff wrapped in embossed white leather | true | ||
Weapon:Darkly stained ebony quarterstaff with black leather-wrapped grips | |||
Weapon:Grey Raven guard's staff with spiked metal bandings (2) | true | ||
Weapon:Heavy ash quarterstaff bound in iron at both ends | |||
Weapon:Lead-capped quarter staff carved with a spiraling chain of wolverines and centaurs | true | ||
Weapon:Lead-capped quarter staff wrapped with black and grey sharkskin | true | ||
Weapon:Quarter staff | true | ||
Weapon:Quarterstaff | true | ||
Weapon:Quarterstaff (crafted) | false | ||
Weapon:Stout quarter staff | true | ||
Weapon:Twisting oak quarter staff capped with a copper raccoon | true |