Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::volcano]]OR[[Uses material::Volcano]]
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
`t1` AS t1 ON t0.smw_id=t1.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
`t1` AS t1 ON t0.smw_id=t1.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 | t1 | ALL | PRIMARY | 58 | Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 INNER JOIN `t3` AS t3 ON t2.p_id=t3.id WHERE (t2.o_hash='volcano')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=69478 - Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Item:Fist-sized cambrinth mountain with streams of ruby lava flowing down the sides | War and Craft (2) , War and Craft (1) | |
Weapon:Gargantuan Ushnish war icon set atop an iron-shod haft of dragonwood | Misenseor Goods (3), Misenseor Goods (5) , Misenseor Goods (3) | |
Item:Glassy black obsidian Ushnish emblem suspended from a heavy granite-link chain | Huldah Shrine prizes 421 , Huldah Shrine prizes 410 | |
Item:Grass necklace clasping a cracked fragment of red glass | Greyka's Jewelry | |
Item:Hollow glass shrike enclosing a scene of an erupting volcano | Game of Chicken 425 prizes , Game of Chicken | |
Item:Intricate tapestry cloak depicting a glowing volcano | ||
Item:Ironwood box painted with an erupting volcano | Quick Bite (4) | true |
Item:Cambrinth armband etched with a scene of several Halflings in front of a cottage | ||
Item:Chakrel volcano amulet hung from a black iron chain | ||
Item:Fist-sized cambrinth mountain with streams of ruby lava flowing down the sides | ||
Item:Grass necklace clasping a cracked fragment of red glass | ||
Item:Long brown cloak stitched with a map of Elanthia | ||
Item:Matte silver bracelet engraved with an erupting volcano | ||
Item:Replica volcano with streaks of orange trailing down the sides | ||
Item:Silver anniversary ring molded into a smooth ribbon encircling a serpent's heart ruby | ||
Item:Simple bottle of leather lotion with a volcano-shaped cork | ||
Item:Simple bottle of pelt potion with a volcano-shaped cork | ||
Item:Simple golden necklace with a small crystal charm | ||
Item:Stained glass window depicting a desolate city | ||
Item:Wooden-handled hide scraper with the carved image of an erupting volcano | ||
Item:Long brown cloak stitched with a map of Elanthia | Repurposed Shipments (2) , Repurposed Shipments (1), Hide and Seek | true |
Weapon:Mammoth Ushnish war icon set atop a serpentine haft of flamewood | Misenseor Goods (5) , Misenseor Goods (4) | |
Item:Matte silver bracelet engraved with an erupting volcano | Cacophony of Silver and Glass (2), Cacophony of Silver and Glass (3) , Cacophony of Silver and Glass (2) | |
Item:Miniture chocolate cupcake | Sarhanna's Beach Bungalow , Maerianna's Traveling Tavern | true |
Item:Pyramidal box | Magma Falls Mini-Festival Auction | true |
Item:Range of carved inferno's heart volcanoes | Taisidon Mystery 446/A'baya Esplanade | true |
Item:Replica volcano with streaks of orange trailing down the sides | To Dry For | true |
Item:Rich chocolate cupcake carved in the shape of a volcano | Hollow Bellies (2) | |
Item:Rich chocolate volcano cake drizzled with a melted glaze | Goblin Treats | true |
Shield:Silver target shield inlaid with the image of an erupting volcano | ||
Weapon:Short-hafted hammer | Wise Weapons (2) , Wise Weapons (1) | |
Item:Silver anniversary ring molded into a smooth ribbon encircling a serpent's heart ruby | Tokens of the Heart (1) | |
Shield:Silver target shield inlaid with the image of an erupting volcano | Trintah's Herbal Remedies, Trintah's Herbal Remedies | |
Item:Simple bottle of leather lotion with a volcano-shaped cork | Tromlyn's Tannery | false |
Item:Simple bottle of pelt potion with a volcano-shaped cork | Tromlyn's Tannery, Tromlyn's Tannery | |
Item:Simple golden necklace with a small crystal charm | Greyka's Jewelry | |
Item:Small kertig cylinder topped with a stylized erupting volcano | Item:Elegant smokewood humidor with a Fortune's Star diamond closure | |
Item:Stained glass window depicting a desolate city | Translucence, Translucence | |
Armor:Suit of dusty grey lamellar plate with an engraved breastplate | War and Craft (1), War and Craft (2), War and Craft (2) , War and Craft (1) | |
Item:Volcano globe (1) | Scholar's Museum , Gift Shop | false |
Item:Volcano globe (2) | Fenwyrthie's Curio Shop | |
Item:Volcano with vivid red and orange streams of lava flowing down its sides | Item:Volcano globe (1) | false |
Volcano's heart citrine | ||
Item:Volcano-shaped familiar treat with magma-colored icing | Goblin Treats | true |
Weapon:Gargantuan Ushnish war icon set atop an iron-shod haft of dragonwood | ||
Weapon:Mammoth Ushnish war icon set atop a serpentine haft of flamewood | ||
Weapon:Short-hafted hammer | ||
Item:Wooden-handled hide scraper with the carved image of an erupting volcano | Tromlyn's Tannery | false |