Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::butterfly]]OR[[Uses material::Butterfly]]
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
20
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
20
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 325 | 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='butterfly')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=67551 - 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:Blue chiffon gown intricately embroidered with colorful butterflies | Turialo's Haven (8) , Turialo's Haven (4), Turialo's Haven (2) | |
Item:Blue glass bell decorated with hand-painted butterflies | Tending the Fold (2) , Tending the Fold (1) | |
Item:Blue jaspe odaj gathered by a thick copper brooch | Comfortable Rakash (3) , Comfortable Rakash (2), Comfortable Rakash (1) | |
Item:Blue silk butterfly wings | ||
Item:Blue topaz butterfly pin bejeweled with garnets and pearls | Flower Gazebo (2) , Flower Gazebo (1) | |
Item:Braided silver ring set with a large cambrinth butterfly | Forever Faithful (2) , Forever Faithful (1) | |
Item:Brick red and silver rusty armor butterfly | Item:Cambrinth chrysalis | |
Item:Bright blue bent-antennaed broken helmet butterfly | Item:Cambrinth chrysalis | |
Item:Bright canary-yellow camlet umbrella with a carved zingana handle | Taisidon Safari 420 Game Prizes , Deluxe Safari 417 Game Prizes | |
Item:Bright red ribbons embroidered with butterflies | Pretty as a Yak | |
Item:Bright yellow distant middens butterfly | Item:Cambrinth chrysalis | |
Item:Brightly colored butterfly doll with graceful gossamer wings | Item:Gemstone-studded dragonfly doll with delicate gossamer wings , Animal Agenda | |
Item:Brilliantly colored butterfly doll with transparent chiffon wings | Plush and Nonsense , Item:Glitter-covered dragonfly doll with delicate gossamer wings | |
Item:Broken butterfly hairpin with badly twisted wings | Item:Delicate butterfly hairpin of silver filigree inlaid with polished amethyst and dark amber crystals , Item:Delicate butterfly hairpin of silver filigree inlaid with fiery red and verdant green crystals, Item:Delicate butterfly hairpin of platinum filigree inlaid with polished amethyst and dark amber crystals, Item:Delicate butterfly hairpin of platinum filigree inlaid with fiery red and verdant green crystals, Item:Delicate butterfly hairpin of silver filigree inlaid with pristine white and dark azure crystals, Item:Delicate butterfly hairpin of silver filigree inlaid with polished amethyst and dark amber crystals, Item:Delicate butterfly hairpin of silver filigree inlaid with cloudy white and dark azure crystals, Item:Delicate butterfly hairpin of silver filigree inlaid with bright pink and periwinkle-blue crystals, Item:Delicate butterfly hairpin of platinum filigree inlaid with cloudy white and dark blue crystals, Item:Delicate butterfly hairpin of platinum filigree inlaid with bright pink and periwinkle-blue crystals, Item:Delicate butterfly hairpin of gold filigree inlaid with polished amethyst and dark amber crystals, Item:Delicate butterfly hairpin of gold filigree inlaid with fiery red and verdant green crystals, Item:Delicate butterfly hairpin of gold filigree inlaid with cloudy white and dark blue crystals, Item:Delicate butterfly hairpin of gold filigree inlaid with bright pink and periwinkle blue crystals | |
Item:Brushed gold jewelry box etched with a garden scene | MegaSafari 413 game prizes , Basket of colored darts | |
Item:Brushed silver jewelry box etched with a garden scene | ||
Item:Butterfly (1) | Heavenly Entrances (1) | |
Item:Butterfly haircomb | Item:Small sandalwood chest with intricate fretwork carvings , Dunshade: Echo of Tears/End loot | |
Item:Butterfly pendant suspended from a long multi-colored chain | ||
Weapon:Butterfly spear wrapped in saffron silk | Basimah's (3) , Basimah's (1) | |
Item:Butterfly wings of brightly colored gossamer | Flights of Fancy (3) , Flights of Fancy (2), Flights of Fancy (1) | true |
Shield:Butterfly-shaped shield inlaid with vibrant crystals | Beyond the Barrier: The Devastation of Lyras/Incidental Loot | |
Item:Cambrinth ankle cuff inlaid with amethyst butterflies to spell ENELNE | Forever Faithful (2) , Forever Faithful (1) | |
Item:Cerulean blue velvet backpack clasped with a golden butterfly | Hollow Eve Festival 414/Raffles | |
Item:Charcoal black papa's cooking butterfly | Item:Cambrinth chrysalis | |
Item:Chiffon butterfly wing mask hued in pastels | Aerial Artistry | |
Item:Cloisonne butterfly necklace with a braided silk cord | Turialo's Haven (8) , Turialo's Haven (4), Turialo's Haven (2) | |
Item:Cloisonne butterfly with large rose-patterned wings | Tildi's Blooms (2) | |
Item:Cloisonne pin shaped to resemble a butterfly | Feleah Family Crafts (7) , Feleah Family Crafts (6) | |
Item:Cloth of gold cloak with a butterfly-shaped enameled clasp | Su Helmas 444: Make Haste!/Incidental loot , Su Helmas 440: Entrapped/Incidental loot | true |
Item:Cloudstone Wayerd pyramid carved into the shape of a butterfly | Garden of Plenty | true |
Item:Colorful butterfly charm with an empty setting in the center of its back | Empty Settings (1) | |
Item:Colorful butterfly pinata with widespread wings | ||
Item:Colorful fabric butterflies | Jester's General Store | |
Item:Colorful fan shaped like a large butterfly wing | Occasional Treasures | |
Item:Copper and patina weapon rack | Frother's Beasts | |
Item:Cowled brown cassock with hundreds of gossamer butterflies clinging to its folds | Akaterina's Cassocks | |
Item:Crimson rose butterfly with soft velvet wings | Tildi's Blooms (4) , Tildi's Blooms (3) | |
Item:Curved golden earcuff tipped with an orchid alexandrite | Blanve's Bounty (4) | |
Item:Curved platinum earcuff tipped with an orchid alexandrite | Blanve's Bounty (4) | |
Item:Curved silver earcuff tipped with an orchid alexandrite | Blanve's Bounty (4) | |
Item:Dark blue silk backpack embroidered with tiny flowers | Fair Daisy | |
Item:Dark green muracite pauldron bearing a kaleidoscope of silk butterflies | Hollow Eve Festival 443/Raffles | |
Item:Dark palmwood ocarina painted with whimsical butterflies | Whimsical Winds (7) | |
Item:Dark red floor-length gown embroidered with a golden butterfly | Turialo's Haven (8) , Turialo's Haven (4), Turialo's Haven (2) | |
Item:Dead butterfly | Eclectic Eccentric (3) , Eclectic Eccentric (2) | |
Item:Deep green backpack of plush velvet with sterling silver buttons | Stuff It, Stuff It (1) | |
Item:Deep red clumsy barber butterfly | Item:Cambrinth chrysalis | |
Item:Delicate butterfly amulet suspended from a frayed jute cord | Amulets by Liathe (6) , Amulets by Liathe (5) | |
Item:Delicate butterfly hairpin of gold filigree inlaid with bright pink and periwinkle blue crystals | Tokens of Affection |