Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::scorpion||scorpion (symbol)]]OR[[Uses material::Scorpion||Scorpion (symbol)]]
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
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
`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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 287 | 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='scorpion') OR (t2.o_hash='scorpion (symbol)'))
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 INNER JOIN `t6` AS t6 ON t4.o_id=t6.id WHERE t4.p_id=2021246 - Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1 - Temporary table t6
INSERT IGNORE INTO `t6` (id) VALUES (70924)
INSERT IGNORE INTO `t6` (id) VALUES (401520)
Query Metrics
Query-Size:6Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Weapon:Abassi (1) | Kilora's Weaponry | |
Item:Aged cherrywood humidor trimmed with a thin golden band | Dunshade: Echo of Tears/End loot | |
Item:Alabaster scorpion pin | Grave earth pile 432 prizes , Grave earth pile 428 prizes, Grave earth pile 425 prizes, Grave earth pile 421 prizes, Grave earth pile | |
Item:Ammunition pouch branded with twin scorpions | Slings and Things (1) | |
Item:Anloral scorpion pin | Soulful Trinkets (2) , Soulful Trinkets (1) | true |
Armor:Crested chain hauberk crafted from blackened steel links | ||
Armor:Dusky black leather gravedigger's gloves with reinforced palms | ||
Armor:Ebony field plate formed from interlocking scales to resemble an exoskeletal scorpion | ||
Armor:Pair of vibrantly crimson boots embroidered with silver scorpions | ||
Armor:Suit of matte black plate armor embellished with a blood red scorpion | ||
Armor:Articulated icy veined scorpion mesosoma of glossy black asharsh'dai | Item:Shadowy backpack pinned with a midnight diamond scorpion , Drathrok's Duskruin 448/Raffle | true |
Armor:Articulated icy veined scorpion pedipalps of glossy black asharsh'dai | Item:Shadowy backpack pinned with a midnight diamond scorpion , Drathrok's Duskruin 448/Raffle | true |
Weapon:Arzfilt | Kilora's Weaponry | |
Item:Black basalt Urrem'tier emblem suspended from a heavy iron chain | Huldah Shrine prizes 421 , Huldah Shrine prizes 410 | |
Item:Black diamond comb shaped like a scorpion with a ruby-tipped stinger | Game of Chicken 425 prizes | |
Item:Black ironwood carving case with a bloodgem scorpion clasp | Altared Visions | |
Item:Black linen sack with small red scorpions embroidered along the seams | treasure map | true |
Item:Black satin gem pouch clasped with a silver ruby-eyed scorpion | Simply Essential (1) | |
Item:Black scorpion blossom | Oasis | |
Item:Black silk tabard appliqued with a brilliant red scorpion | treasure map | true |
Item:Black suede boots with tiny scorpion-shaped rubies | Divine Rialto | |
Item:Blackened pewter scorpion clenching a soulstone between its claws | Inner Illuminations (1) | |
Item:Blackened steel hip chain dangling with tiny cambrinth scorpions | Forever Faithful (2) , Forever Faithful (1) | |
Weapon:Blackened steel throwing hammer with scorpion-shaped rubies set into the handle | Toss-O-Rama | |
Item:Bleached bone amulet painted with faded purple scorpions | Museum of Imperial History | false |
Item:Blood-red leather alchemist's kit clasped with an onyx scorpion | On the Mend (1) | |
Item:Bloodwood-handled kertig clippers | Fancybeards (3) , Fancybeards (2), Fancybeards (1), Item:Dark armure grooming pouch clasped with a scorpion diamond | true |
Item:Bouquet of Desert Scorpion blossoms arranged in a ceramic treasure chest | Perpetual Blossoms of Mer'Kresh (3) , Perpetual Blossoms of Mer'Kresh (2) | true |
Item:Bronze anklet inlaid with a cambrinth avatar | Entrail Toss Arena (3) , Entrail Toss Arena (2), Entrail Toss Arena (1) | |
Item:Bronze armband inlaid with a cambrinth avatar | Entrail Toss Arena (3) , Entrail Toss Arena (2), Entrail Toss Arena (1) | true |
Item:Brushed steel ring set with a large cambrinth scorpion | Forever Faithful (2) , Forever Faithful (1) | |
Item:Cambrinth ankle cuff inlaid with topaz scorpions to spell URREM'TIER | Forever Faithful (2) , Forever Faithful (1) | |
Item:Cambrinth chimaera | Cleric Shop (Riverhaven) | |
Item:Cambrinth scorpion with faceted ruby eyes | ||
Item:Carved basalt link anklet | Zaulfung | |
Item:Carved black basalt scorpion figurine | Zaulfung | |
Item:Carved ebony incense case with an onyx scorpion clasp | Sputkin's Wagon , Sputkin's Splendors (5), Sputkin's Splendors (4), Sputkin's (3), Sputkin's (2), Sputkin's (1) | |
Item:Carved smoky quartz earring shaped like a scorpion's stinger | Zaulfung | |
Weapon:Chipped basalt dagger shaped like a scorpion's stinger | Zaulfung | |
Item:Chocolate brown scorpion with red claws | Thorkim Family Farm 429/Pig Maze | |
Item:Cloth of gold cloak with a purple gold clasp | Drathrok's Duskruin 438/Incidental loot, Drathrok's Duskruin 435/Incidental loot, Drathrok's Duskruin 430/Incidental loot, Drathrok's Duskruin 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot | |
Item:Cloth-of-gold baldric clasped with an onyx scorpion | Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot | |
Item:Clouded glass armband strung with a constellation of tiny stars | Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot | |
Armor:Crested chain hauberk crafted from blackened steel links | ||
Item:Crumpled crimson envelope stamped with a black scorpion | Item:Aged cherrywood humidor trimmed with a thin golden band , Dunshade: Echo of Tears/End loot, Item:Aged cherrywood humidor trimmed with a thin golden band | |
Weapon:Damascened throwing dagger with a bloodstone hilt shaped like a scorpion tail | Ophyr's Tent | |
Item:Dark leather lockpick case embossed with crimson scorpions | Sketchy By Design (6) , Sketchy By Design (5), Sketchy By Design (4), Sketchy By Design (1), Kharson's Tent, Inside The Lifeboat | |
Item:Dark purple silk fan embroidered with twin black scorpions | Game of Chicken 425 prizes , Game of Chicken | |
Item:Dark violet scroll | See the Light (2) , See the Light (1) | |
Armor:Darkened gravecloth aventail trimmed in eclipsed iolite icesilk | Drathrok's Duskruin 448/End Loot | true |