Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Mistglass]]OR[[Uses material::Mistglass]]
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 | 220 | 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='Mistglass')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=209821 - 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 | Rarity is |
---|---|---|
Bluefire velvet storybook rose accented with mistglass leaves | Tildi's Blooms (3) , Tildi's Blooms (2), Tildi's Blooms (1) | festival |
Brazen blue-white mistglass anklet encrusted with haze sapphires | Uwresari's Exotic Wonders (2) , Uwresari's Exotic Wonders (1) | |
Briar-covered cane surmounted with a coy mistglass weasel | Huldah Shrine prizes 421 , Huldah Shrine prizes 410, Huldah Shrine prizes 406 | |
Brilliant gold windboard shaped like a lightning bolt | 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 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | end loot |
Broken orlog charm with a face of deep green anjisis | Ahreusse's Atelier (4) , Ahreusse's Atelier (3) | |
Cambrinth torque featuring alternating pieces of mistglass | Hollow Eve Festival 439/Auction | auction |
Carved mistglass bell shaped like a spider arced over a cloud ruby clapper | Hollow Eve Festival 425/Raffles | |
Celeste-blue spun glitter slippers with crescentic mistglass heels | Limited Treasures (1) , Item:Celeste-blue spun glitter cloak with an Elven snowlace overlay and sweeping train | |
Chipped mist glass vase filled with dead dusk roses | Once Possessed (2) | |
Clouded white mistglass sackbut designed to resemble spiderwebbing | Whimsical Winds (5) | |
Clump of cambrinth and green jade endives on a blue mistglass chain | ||
Commemorative coin with rippled edges | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Competition miniature Merelew soldier wielding a tiny trident | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | incidental |
Crescentic fascinator bearing mistglass rolo chains with midwinter's sickle tips | Limited Treasures (1) | |
Curving mistglass flagon with a vaulted dome lid | Ode to Glythtide (1) | |
Dangling pair of concentrenic hoop earrings cradling riftstone starbursts | Limited Treasures (6) | festival |
Deceptively fragile-looking tail guard of mistglass mail | Hashal's Haven | |
Deep blue mistglass phylactery with a braided silk strap | Only The Holy (2) , Only The Holy (1) | |
Deep purple cinquedea | Uwresari's Exotic Wonders (1) | |
Delicate black top hat trimmed in zerarin lace | Damsel In This Dress (4) , Damsel In This Dress (1) | |
Delicate bracelet of interlocking striped seaperch | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Delicate mistglass pilonu decorated with petite spectrolite orbs | Limited Treasures (3) | |
Demure heliotrope orchid mantis | Limited Treasures (2) | |
Diamond-shaped window with mistglass panes | Pane in the Glass | |
Double-necked cross-strung harp of white mistglass inlaid with scenes from the life of Lanival | Hollow Eve Festival 432/Auction | auction |
Dragonfly-shaped loimic pin with blue mistglass wings | Looty Booty (2) | festival |
Electroweave cowl studded in white mistglass | Hollow Eve Festival 443/Raffles , Item:Electroweave carryall embroidered with a sinuous leviathan | |
Elegant mistglass coronet crowned with an empty setting | Empty Settings (2) | |
Elegant spiritwood keepsake box inlaid with intricate mistglass whorls | Limited Treasures (3) | |
Elegantly recurved Elothean battle bow of stormtouched smokewood | Droughtman's Challenge 437/Raffle | auction |
Elven snowlace choker dangling a mistglass-tipped midwinter's sickle | Limited Treasures (1) | |
Enormous mistglass saucer with a ghostly-white sheen | Hollow Eve Festival 439/Auction | auction |
Exquisitely pale mistglass compact patterned with delicate rose petals | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Sleeping Dragon Corn Maze 439/End loot, Sleeping Dragon Corn Maze 436/End loot, Sleeping Dragon Corn Maze 432/End loot | end loot |
Fat blue mistglass mixing stick inlaid with a silvery white moon coral | Garden of Plenty | festival |
Fine steel knitting needles topped with tiny blue mistglass orbs | Snacky Happiness (2) | festival |
Forked tomiek pickaxe with a mistglass handle | Skyward Crafting (8) , Skyward Crafting (7), Skyward Crafting (6) | festival |
Fortune's Star diamond pin caught within an intricate mistglass maze | ||
Fragile blossom with delicate petals | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | incidental |
Fragile blue-white mistglass anklet constructed from a slew of gears | Smaller Side of Life (3) , Smaller Side of Life (2) | festival |
Frosted glass koto depicting gold limned cranes | Item:Instrument case of white mistglass with flame-shaped indurium clasps | |
Frosted seaglass cowbell inlaid with sea-calves along the rim | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | festival |
Gallant mistglass eternity band studded with shards of uncut eldring | Item:Square spiritwood keepsake box with an intricate mistglass latch , Limited Treasures (3) | |
Ghostly white mistglass phial interlaced with niello | Item:Jacinthe dragonfire brocade makeup reticule suspended on silversteel chains , Hollow Eve Festival 425/Auction | |
Gleaming warrior's shield edged in white mistglass | Hollow Eve Festival 432/Auction | auction |
Gleaming white mistglass scepter scattered with red diamonds | Hollow Eve Festival 439/Auction | auction |
Glimmery mistglass nyad captured by a delicate silver chain | Tildi's Blooms (4) , Tildi's Blooms (3) | |
Gloomwood cane set with a blue mistglass orb | Cute as a Button (2) | |
Gloomwood kaleidoscope inlaid with silver | Clear Visions (1) | |
Gloomwood telescope case with mistglass caps | Clear Visions (1) | |
Gnarled gloomwood recurve bow with a translucent white mistglass grip | Hollow Eve Festival 399/Auction |