Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Item type is::Hand of Glory ring]]
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=752480)
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=752480)
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 |
---|---|---|---|
Item:Resplendent darkstone ring | Item:Rough korograth leather pouch secured with a telothian fist , House of the Revenant Fang 437/Shadowy Safehouse, House of the Revenant Fang 433/Shadowy Safehouse, House of the Revenant Fang 429/Shadowy Safehouse, House of the Revenant Fang 423/Shadowy Safehouse, Aesthene's Close 445/Vault, Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot | true | |
Item:Resplendent glitvire ring | House of the Revenant Fang 437/Shadowy Safehouse , House of the Revenant Fang 433/Shadowy Safehouse, House of the Revenant Fang 429/Shadowy Safehouse, House of the Revenant Fang 423/Shadowy Safehouse, Item:Austere stormsilk pouch clasped with a starsteel lightning bolt, Aesthene's Close 445/Vault, Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot | true | |
Item:Resplendent gloomwood ring | House of the Revenant Fang 437/Shadowy Safehouse , House of the Revenant Fang 433/Shadowy Safehouse, House of the Revenant Fang 429/Shadowy Safehouse, House of the Revenant Fang 423/Shadowy Safehouse, Item:Austere stormsilk pouch clasped with a starsteel lightning bolt, Aesthene's Close 445/Vault, Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot | true | |
Item:Resplendent haralun ring | Item:Rough korograth leather pouch secured with a telothian fist , House of the Revenant Fang 437/Shadowy Safehouse, House of the Revenant Fang 433/Shadowy Safehouse, House of the Revenant Fang 429/Shadowy Safehouse, House of the Revenant Fang 423/Shadowy Safehouse, Aesthene's Close 445/Vault, Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot | true | |
Item:Resplendent iroko ring | House of the Revenant Fang 437/Shadowy Safehouse , House of the Revenant Fang 433/Shadowy Safehouse, House of the Revenant Fang 429/Shadowy Safehouse, House of the Revenant Fang 423/Shadowy Safehouse, Item:Austere stormsilk pouch clasped with a starsteel lightning bolt, Aesthene's Close 445/Vault, Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot | true | |
Item:Resplendent niello ring | Item:Rough korograth leather pouch secured with a telothian fist , House of the Revenant Fang 437/Shadowy Safehouse, House of the Revenant Fang 433/Shadowy Safehouse, House of the Revenant Fang 429/Shadowy Safehouse, House of the Revenant Fang 423/Shadowy Safehouse, Aesthene's Close 445/Vault, Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot | true | |
Item:Ring of Glory (Agility) | Artificing products | false | |
Item:Ring of Glory (Charisma) | Artificing products | false | |
Item:Ring of Glory (Discipline) | Artificing products | false | |
Item:Ring of Glory (Intelligence) | Artificing products | false | |
Item:Ring of Glory (Reflex) | Artificing products | false | |
Item:Ring of Glory (Stamina) | Artificing products | false | |
Item:Ring of Glory (Strength) | Artificing products | false | |
Item:Ring of Glory (Wisdom) | Artificing products | false | |
Item:Simple alerce ring | Snake Pit , Sleeping Dragon Corn Maze 428/End loot, Musical Chairs of Doom, Harawep Shrine 421, Hand of Glory (2), Hand of Glory (1), Grave earth pile 421 prizes, Game of Chicken 425 prizes, Game of Chicken 421 prizes, Boggle Blast (2), Bobbing for Leeches | true | |
Item:Simple audrualm ring | Sleeping Dragon Corn Maze 428/End loot , Item:Simple leather pouch embossed with a hand, Musical Chairs of Doom, Harawep Shrine 425, Harawep Shrine 421, Hand of Glory (2), Hand of Glory (1), Grave earth pile 421 prizes, Game of Chicken 425 prizes, Game of Chicken 421 prizes, Boggle Blast (2), Bobbing for Leeches | true | |
Item:Simple darkstone ring | Sleeping Dragon Corn Maze 428/End loot , Musical Chairs of Doom, Harawep Shrine 425, Harawep Shrine 421, Hand of Glory (2), Hand of Glory (1), Grave earth pile 421 prizes, Game of Chicken 425 prizes, Game of Chicken 421 prizes, Boggle Blast (2), Bobbing for Leeches | true | |
Item:Simple glitvire ring | Sleeping Dragon Corn Maze 428/End loot , Musical Chairs of Doom, Harawep Shrine 421, Hand of Glory (2), Hand of Glory (1), Grave earth pile 432 prizes, Grave earth pile 428 prizes, Grave earth pile 425 prizes, Grave earth pile 421 prizes, Game of Chicken 425 prizes, Game of Chicken 421 prizes, Boggle Blast (2), Bobbing for Leeches | true | |
Item:Simple gloomwood ring | Sleeping Dragon Corn Maze 428/End loot , Musical Chairs of Doom, Harawep Shrine 425, Hand of Glory (2), Hand of Glory (1), Grave earth pile 421 prizes, Game of Chicken 425 prizes, Game of Chicken 421 prizes, Boggle Blast (2), Bobbing for Leeches | true | |
Item:Simple haralun ring | Sleeping Dragon Corn Maze 428/End loot , Harawep Shrine 421, Hand of Glory (2), Hand of Glory (1), Grave earth pile 421 prizes, Game of Chicken 425 prizes, Game of Chicken 421 prizes, Boggle Blast (2), Bobbing for Leeches, Blood and Gourd (5), Blood and Gourd (4), Blood and Gourd (3) | true | |
Item:Simple iroko ring | Sleeping Dragon Corn Maze 428/End loot , Musical Chairs of Doom, Harawep Shrine 425, Harawep Shrine 421, Hand of Glory (2), Hand of Glory (1), Grave earth pile 421 prizes, Game of Chicken 425 prizes, Game of Chicken 421 prizes, Boggle Blast (2), Bobbing for Leeches | true | |
Item:Simple niello ring | Sleeping Dragon Corn Maze 428/End loot , Musical Chairs of Doom, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes, Hand of Glory (2), Hand of Glory (1), Grave earth pile 421 prizes, Game of Chicken 425 prizes, Game of Chicken 421 prizes, Boggle Blast (5), Boggle Blast (4), Boggle Blast (3), Boggle Blast (2), Bobbing for Leeches | true |