Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Spun glitter]]OR[[Uses material::Spun glitter]]
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 | 133 | 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='Spun glitter')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=445945 - 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:Adorably cute spun glitter pinafore bedecked with rows of eyelet lace trim | Puffs of Glitter (2) , Puffs of Glitter (1) | |
Item:Alabaster thornweave pants embellished with spun glitter bands | Fashionable Panda (2) | |
Item:Ankle-tied slippers of sirese blue spun glitter | Natural Beauty (1) , Hollow Eve Festival 417/Raffles | |
Item:Apple green spun glitter tunic embellished with silverweave | Fashionable Panda (2) | |
Item:Artfully woven glitvire picnic basket lined in dusk-hued spun glitter | Tildi's Blooms (4) , Tildi's Blooms (3) | |
Item:Backless spun glitter dress dyed shimmering silver | Damsel In This Dress (2) | |
Item:Black hair ribbon of spun glitter | Hide and Silk (3) | |
Item:Black knee-high combat boots with spun glitter laces | Puffs of Glitter (2) , Puffs of Glitter (1) | |
Item:Black top hat accented by a band of electrum spun glitter | Hide and Silk (3) | |
Item:Blob made from sparkly spun glitter ribbons | Tildi's Blooms (4) , Tildi's Blooms (3), Tildi's Blooms (2) | |
Item:Breathtaking classically-styled tutu composed of iridescent peacock feathers | Limited Treasures (2) | |
Item:Bright purple spun glitter pajama bottoms embroidered with unicorns | Sleepwalkers (5) | true |
Item:Burnished copper garter composed of spun glitter | Galleria of Garters (2) | |
Item:Camlet and spun glitter hand-puppet resembling a jellyfish | Cleric wrapped tightly in dark robes | |
Item:Celeste-blue spun glitter cloak with an Elven snowlace overlay and sweeping train | Limited Treasures (1) | |
Item:Charcoal-grey slippers with spun glitter straps | Nigeyi's (4) | |
Item:Chocolate-brown homespun cookie pouch cinched with spun glitter | Hollow Eve Festival 447/Raffles , Hollow Eve Festival 443/Raffles | true |
Item:Colorful tea chest trimmed with colorful spun glitter ribbons | Tea For Tamsine (1) | |
Item:Corseted gown of spun glitter displaying ulhari prisms | Damsel In This Dress (3) | |
Item:Corseted wedding gown of spun glitter displaying ulhari prisms | Damsel In This Dress (3) | |
Item:Crescentic fascinator bearing mistglass rolo chains with midwinter's sickle tips | Limited Treasures (1) | |
Item:Dainty leaf green spun glitter slippers fit with polished glitvire heels | Nigeyi's (4) , Nigeyi's (3), Nigeyi's (2) | |
Item:Dainty pair of icesteel spun glitter slippers | Smaller Side of Life (3) , Smaller Side of Life (2) | |
Item:Dainty spun glitter slippers adorned with star-cut twilight sapphires | Puffs of Glitter (3) | |
Item:Daring flame-red spun glitter dress with an asymmetrical skirt | Damsel In This Dress (3) | |
Item:Deep blue-hued spun glitter gown featuring a trailing skirt of ruffled seasilk | Natural Beauty (4) | true |
Item:Deep purple spun glitter summer dress with lace petticoats | Damsel In This Dress (5) , Damsel In This Dress (3) | |
Item:Delicate spray of spun glitter Ilithic apple blossoms tinted in soft pastel hues | Fashionable Panda (2) | |
Item:Demure emerald green walking dress with an embroidered gold bodice | Estate Holder Charity Auction 434 | |
Item:Diaphanous gown of wisteria mistsilk with a cascading spun glitter floral motif | Natural Beauty (1) | |
Item:Dramatic cloak fastened with a clasp | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | true |
Item:Electrum spun glitter dress with a ruffled black tulle underskirt | Hide and Silk (3) | |
Item:Elegant black sash crafted from spun glitter | Turialo's Haven (8) | |
Item:Elegant red floor-length gown crafted entirely from spun glitter | Turialo's Haven (8) | |
Weapon:Elegantly swept iridescent shamshir emanating glitzy clouds of prismatic glitter | Droughtman's Challenge 441/Raffle , Item:Canvas tote pinned with a purple gold crown | true |
Item:Ethereal fiery scarlet chiffon dress with a spun glitter collar and a flirty hemline | Damsel In This Dress (5) , Damsel In This Dress (3) | |
Item:Ethereal spun glitter cape lined in heliotrope icesilk | Tildi's Blooms (4) , Tildi's Blooms (3) | |
Item:Extravagant spun glitter capelet fastened with a massive silveress bow | Puffs of Glitter (3) | |
Item:Fiery scarlet satin skirt with spun glitter petticoats | Tastelessly Tacky (12) , Tastelessly Tacky (11) | |
Item:Filmy wrap of spun glitter enhanced by subtle silvery embroidery | Natural Beauty (2) | |
Item:Flowing robes flecked with tiny droplets | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | true |
Item:Fluttery skirt with a glittery gauze overlay | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Folding chair with a cushioned seat | Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Fragile pale blue tea towel embellished with a fringe of peony-shaped cutouts | Tea for Tamsine (4) , Tea For Tamsine (5), Item:Aromatic sandalwood tea hamper overflowing with an abundance of pink peonies | |
Item:Gaudy gypsy caravan with walls of firesilk and spun glitter | Limited Treasures (1) | |
Item:Gaudy repair case striped with rainbow hues | Siegery Shop (4) , Siegery Shop (3), Siegery Shop (2), Siegery Shop (1) | |
Item:Glitzy twilight evening gown of spun glitter and silveress | Puffs of Glitter (3) | |
Item:Glorious goldweave doughnut purse drizzled with rainbow sapphire sprinkles | Puffs of Glitter (2) , Puffs of Glitter (1) | |
Item:Graceful fan painted with swirling blossoms | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Template:HE2020Fabrics |