Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Item type is::TM Foci||Ritual focus]]
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 | system | PRIMARY | 1 | Using temporary; Using filesort | ||||
1 | SIMPLE | t2 | ALL | PRIMARY | 2 | |||||
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 - Temporary table t3
INSERT IGNORE INTO `t3` (id) VALUES (234314)
INSERT IGNORE INTO `t3` (id) VALUES (234314)
Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneItem | Found |
---|---|
Agonite pin set with a delicate cluster of rikar crystals | Return to the Keep 431/Supply Wagon |
Amber beehive surrounded by golden honey bees | Ritual Addiction |
Anloral star of thirteen points | Ritual Addiction |
Banded fluorite pendulum suspended on a silver chain | Focus on the Past (2) ,Focus on the Past (1) |
Beaten copper figure holding a telescope aloft | Focus on the Past (2) ,Focus on the Past (1) |
Bent gold snake charm etched with a knotwork of vine-like sigils | Vatari's Ritual Addiction (3) |
Black gold circlet set with a clear Xibar topaz | Droughtman's Challenge 426/Incidental loot |
Bone medallion resembling a running antelope | Vatari's Ritual Addiction (2) |
Bouquet of silk daisies bound with twine | Vatari's Ritual Addiction (5) |
Braided cord rosary strung with several wooden beads | Vatari's Ritual Addiction (2) |
Broken compass in a sigil-seared wooden case | Vatari's Ritual Addiction (5) |
Brushed gold signet ring cradling an aurora tourmaline | Droughtman's Challenge 444/Incidental loot ,Droughtman's Challenge 441/Incidental loot,Droughtman's Challenge 437/Incidental loot,Droughtman's Challenge 433/Incidental loot,Droughtman's Challenge 430/Incidental loot |
Carved ivory lily with a delicate green glass stem | Hollow Eve Festival 421/Raffles |
Carved pick of ivory marked with several runes | Vatari's Ritual Addiction (2) ,Vatari's Ritual Addiction (1) |
Ceremonial scourge with a diamond-hide grip | Drathrok's Duskruin 430/Drathrok's Assemblage |
Clear glass charm etched with a floral motif | Su Helmas 444: Make Haste!/End loot ,Su Helmas 440: Entrapped/End loot,Su Helmas 438: The Forbidden Temple/End loot,Su Helmas 434: The Forbidden Temple/End loot |
Coiled onyx adder set with ruby eyes | Vatari's Ritual Addiction (2) |
Copper dodecahedron with raised edges terminating in tiny globes | Focus on the Past (2) ,Focus on the Past (1) |
Coursing Hound of Rutilor forged from windsteel | Ritual Addiction |
Cracked geode with chunks of amethyst | Vatari's Ritual Addiction (1) |
Cracked sigil-laced skull darkened with soot | Vatari's Ritual Addiction (4) |
Crystal ball with wisps of darkness swirling inside it | |
Crystal-bone globe caught in a web of interlocking finivire twigs | Guildfest 423/Auction |
Cylindrical seal stamp | Focus on the Past (2) ,Focus on the Past (1) |
Dark ka'hurst pin set with a moon-shaped aurora opal | Return to the Keep 431/Supply Wagon |
Delicate sungold pin | Droughtman's Challenge 426/End loot |
Dented bronze censer attached to a sigilated amulet chain | Vatari's Ritual Addiction (5) |
Devotional amulet carved from Idon's sapphire | 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 |
Dried khor'vela leaf strung on a braided leather cord | Limited Treasures (4) ,Item:Formal charcoal-grey steelsilk robe pinned with a windsteel seven-pointed star |
Dull covellite lump etched with esoteric and complex sigils | Vatari's Ritual Addiction (3) |
Etched adderwood bow | Vatari's Ritual Addiction (2) ,Vatari's Ritual Addiction (1) |
Ethereal Phelim shell sliced lengthwise | Ritual Addiction |
Flawlessly cut crystal fist inset with Imperial gemstones | Hollow Eve Festival 428/Auction |
Glued-shut unguent jar carved with a sigil on its side | Vatari's Ritual Addiction (5) |
Gnarled azurelle branch dangling myriad stone amulets | Drathrok's Duskruin 430/Drathrok's Assemblage ,Drathrok's Duskruin 426/Drathrok's Assemblage |
Gnarled branch with a small leather-bound grip | Finest Box of Gems (3) ,Finest Box of Gems (1) |
Green gold armband inset with a trail of tiny blood rubies | Droughtman's Challenge 426/Incidental loot |
Heavy steel armband dangling crow feather amulets | Vatari's Ritual Addiction (2) |
Icesteel anklet accented with tiny howlite snowflakes | Droughtman's Challenge 426/Incidental loot |
Jade apple | Crypt fiend |
Jade beads worked to resemble interlocking leaves | Droughtman's Challenge 426/Incidental loot |
Katamba-black volume titled "A Merelew's Guide to Lunar Magic" | Finest Box of Gems (4) |
Kelpzyte death adder coiled in ambush | Ritual Addiction |
Lapis lazuli anklet with three golden charms | Vatari's Ritual Addiction (2) |
Lirisan pin set with a piece of purple zoetia | Return to the Keep 431/Supply Wagon |
Livery badge displaying the scales of justice | Ritual Addiction |
Luminous moonsilver clasp pierced by a field of stars | Su Helmas 444: Make Haste!/End loot ,Su Helmas 440: Entrapped/End loot,Su Helmas 438: The Forbidden Temple/End loot,Su Helmas 434: The Forbidden Temple/End loot,Aesthene's Close 449/End Loot |
Lustrous pearl cow seated in the crook of a tri-color crescent moon | Shard Theater Faire 419 raffles |
Malevolent Harawep's Spider with a bloodgem hourglass | Sleeping Dragon Corn Maze 432/End loot ,Sleeping Dragon Corn Maze 428/End loot |
Massive vengeance ruby fireball | Sleeping Dragon Corn Maze 432/End loot ,Sleeping Dragon Corn Maze 428/End loot |