Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Item type is::Arbalest||Arbalast]]
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
0
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
0
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 (83135)
INSERT IGNORE INTO `t3` (id) VALUES (0)
Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item | Is incomplete |
---|---|---|---|
Weapon:Acanth wood arbalest carved with tiny vines | Ratchet Shack | ||
Weapon:Arbalest | Urglub's Squishing Emporium | ||
Weapon:Arbalest (crafted) | false | ||
Weapon:Azurelle and vardite battle arbalest | Owirvald Riverhaven Auction 420 | ||
Weapon:Damaris arbalest | 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 iron siege arbalest with limbs wrought to resemble a soaring vulture | Visions of Holiness (3) | true | |
Weapon:Dwarven iron arbalest emblazoned with the hammer-and-mountain symbol of the Gardul City State | Armaments by Sqinth (1), Armaments by Sqinth (2), Armaments by Sqinth (2) , Armaments by Sqinth (1) | ||
Weapon:Gloomwood arbalest with a polished steel lath | Ratchet Shack | ||
Weapon:Heavily tarnished arbalest studded with a rusty goshawk figurine | Sister Seendra's Salvation Station | true | |
Weapon:Horseman's arbalest with a thick leather stirrup | Drathrok's Duskruin 422/Incidental loot , Drathrok's Duskruin 421/Incidental loot | true | |
Weapon:Lacquered dragonwood marksman's arbalest with a tightly braided steelsilk string | Droughtman's Challenge 426/End loot | ||
Weapon:Mahogany arbalest with steel fittings | |||
Weapon:Maple arbalest with iron fittings | Ratchet Shack | ||
Weapon:Mariner's arbalest with a diamondwood stock | Droughtman's Challenge 426/Incidental loot | ||
Weapon:Mistwood horseman's arbalest inlaid with anlora-avtoma knotwork | Iprilu's Emporium | false | |
Weapon:Modwir arbalest with a series of small notches cut into the stock | Hollow Eve Festival 428/Raffles | true | |
Weapon:Sanded rowan arbalest with scorch marks | Dying to Shop, Dying to Shop (1) | true | |
Weapon:Shadowbark and abyssium siege arbalest bearing shifting whorls of tidal flows | Item:Imperial weave carryall set with an etched flooded goldfyre medallion , Droughtman's Challenge 444/Raffle | true | |
Weapon:Silversteel forester's arbalest with a felwood stock | Drathrok's Duskruin 430/Incidental loot , Drathrok's Duskruin 426/Incidental loot | ||
Weapon:Silversteel forester's arbalest with a zingana stock | House of the Revenant Fang 437/Shadowy Safehouse , House of the Revenant Fang 433/Shadowy Safehouse | ||
Weapon:Soldier's siege arbalest with a polished obsidian boltplate | Festival Armory | ||
Weapon:Spruce arbalest with a bronze windlass | Ratchet Shack | ||
Weapon:Sturdy arbalest made of cured steel-edged ironwood | Pyie Rate's Supplies For The Distinguished Sailor | ||
Weapon:Tamboti pirate's arbalest with an aldamdin stirrup resembling a kraken's maw | Hollow Eve Festival 439/Auction | true | |
Weapon:Acanth wood arbalest carved with tiny vines | |||
Weapon:Arbalest | true | ||
Weapon:Dwarven iron arbalest emblazoned with the hammer-and-mountain symbol of the Gardul City State | |||
Weapon:Gloomwood arbalest with a polished steel lath | |||
Weapon:Heavily tarnished arbalest studded with a rusty goshawk figurine | |||
Weapon:Maple arbalest with iron fittings | |||
Weapon:Sanded rowan arbalest with scorch marks | true | ||
Weapon:Zingana mariner's arbalest accented with dendritic opal barnacles | Hollow Eve Festival 443/Auction | true |