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
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 | 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:Aquamarine and brown diving troll butterfly | Item:Cambrinth chrysalis | |
Item:Aquamarine pony with a silver-hued mane and tail | Pretty Pony (2) , Pretty Pony (1) | |
Armor:Jeweled butterfly mask | ||
Armor:Purple leather mask sprinkled with tiny blue topaz butterflies | ||
Item:Articulated silver belt inlaid with sapphire sirese blossoms | Curse of the Ghost Ship/Incidental Loot | |
Item:Artistically woven applewood picnic basket adorned with Rakash charms | Tavern Troupe Performing Order/Gifts and prizes | |
Weapon:Awgravet ava (1) | Kifa Awrocis (obsolete) , Kifa Awrocis (2), Kifa Awrocis (1) | |
Weapon:Awgravet ava with a bronze-inlaid haft | Kifa Awrocis (Siksraja) | |
Item:Back-laced doeskin corset stitched in a pattern of jewel-toned butterflies | Wavecrester , Tropic Night, Cat's Ninth Life, Backfence Gossip | |
Weapon:Bastard sword with a flower-embossed pink leather grip | Curse of the Ghost Ship/Incidental Loot | |
Shield:Battered ceremonial shield decorated with Enelne's eyes | Beyond the Barrier: The Devastation of Lyras/Incidental Loot | |
Item:Beaded choker set in the center with a blue glass butterfly | Turialo's Haven (8) , Turialo's Haven (4) | |
Item:Beige socks embroidered with colorful butterflies | Taisidon Safari 420 Game Prizes | |
Item:Black and purple stubbed toe butterfly | Item:Cambrinth chrysalis | |
Item:Black damask kimono embroidered with butterflies against an orange tree | Sumptuous Silks (4) | |
Item:Black onyx hairsticks painted with fluttering purple butterflies | Nahja's Knickknacks (4) , Nahja's Knickknacks (3), Nahja's Knickknacks (2), Nahja's Knickknacks (1) | true |
Item:Black walnut lyre with bright flamewood carvings inlaid along the crossbar | Item:Sturdy burlap brewer's knapsack with a heavy leather flap | |
Item:Black watered silk rantija | Permutations of Siksraja , Pawla's Permutations (Siksraja), Pawla's Permutations (2), Pawla's Permutations (1) | |
Item:Blossoming butterfly vine | Shard flora | |
Item:Blue cameo Enelne medallion strung on a silver chain | Visfarej Cehs (obsolete) , Visfarej Cehs | |
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 |