Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Seasilk]]OR[[Uses material::Seasilk]]
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 | 123 | 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='Seasilk')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=1303906 - 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 |
---|---|---|
Item:Elegant seasilk sash | ||
Item:Emerald green seasilk turtle with sparkling ocean jasper eyes | Ode to Glythtide (2) | |
Item:Exquisitely tailored shirt composed of black seasilk | Finer Things (5) | |
Item:Fiery seasilk boots with void-black spiritgem heels | Hollow Eve Festival 436/Auction | auction |
Item:Firestorm chiffon pantaloons layered over a tawny-gold seasilk lining | Clothes By Any Other Flame (2) | festival |
Item:Firestorm chiffon robe layered over a tawny-gold seasilk lining | Clothes By Any Other Flame (2) | festival |
Item:Firestorm chiffon shirt layered over a tawny-gold seasilk lining | Clothes By Any Other Flame (2) | festival |
Item:Firestorm taffeta cloak lined with tawny-gold seasilk | Clothes By Any Other Flame (2) | festival |
Armor:Fitted rose gold leather vest laced with bright pink seasilk ribbons | Killer Pinks | festival |
Item:Flax-colored seasilk shirt long gathered sleeves | All the King's Men (2) , All the King's Men (1) | |
Item:Flax-colored seasilk shirt with long gathered sleeves | All the King's Men (3) | festival |
Item:Flirty flamingo-pink sundress featuring off-the-shoulder sleeves | Hot Tropics | festival |
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 | incidental |
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 | |
Armor:Foggy grey leathers edged in seasilk braiding | 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 | end loot |
Armor:Foggy grey seasilk mask embellished with tempest sapphires | 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 | end loot |
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 | |
Weapon:Gar tooth spiked knuckles with trailing black seasilk ribbons | Natural Selections (4) | |
Item:Garnet-red seasilk frock coat with charcoal grey silk lapels and frontings | Knotty Pirate | festival |
Item:Glossy cerulean seasilk pajama bottoms piped in gold | Sleepwalkers (5) | festival |
Item:Glossy goose turd-hued seasilk gown clasped at the shoulders with gold cereus | Cultured Attire (6) | |
Item:Glossy seasilk bathing bloomers adorned with gold filigree seashells | Bathed in Splendor | |
Item:Glossy seasilk heart-shaped pocket secured with a gold-stippled coralite nugget | All the Loot | |
Item:Glossy seasilk shell-shaped pocket secured with a gold-stippled coralite nugget | All the Loot | |
Item:Glossy seasilk star-shaped pocket secured with a gold-stippled coralite nugget | All the Loot | |
Item:Glossy seasilk treat belt | Familiar Treats | festival |
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 | |
Item:Graceful pair of golden seasilk slippers with tapered atulave heels | Natural Beauty (4) | festival |
Template:HE2020Fabrics | ||
Item:Heavily embroidered sash with gemstone fractals | 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 |
Item:Hollow Eve 439 gift | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Ichea, Hollow Eve Festival 439 | end loot |
Talk:Hollow Eve Festival 436/Game prizes | ||
Hollow Eve Festival 436/Game prizes/Material options | ||
Item:Hourglass-shaped goldenglow glaes windboard trimmed in azure seasilk | Hollow Eve Festival 443/Auction | auction |
Item:Intricately ruched garter | 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:Jungle-green caftan ornately embroidered in shades of gold | Hot Tropics | festival |
Item:Knee-length seasilk pants with a modest leather belt | Limited Treasures (6) | festival |
Item:Large origami grimoire bound in emerald-hued seasilk | Hollow Eve Festival 436/Auction | auction |
Item:Layered black and grey seasilk cloak with a heavy silver chain at the collar | Cultured Attire (6) | |
Item:Length of fabric (2) | 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 |
Item:Lightly padded Rissan-orange seasilk doublet with a pointed peplum | Swish Slash and Stab | festival |
Item:Long glossy fuchsia seasilk dress ruched at the high waist with several tiny gold stars | Cultured Attire (6) | |
Item:Long-sleeved scarlet seasilk tunic with a beaded neckline | Hero to Go (4) , Hero to Go (3) | festival |
Item:Lustrous fuchsia seasilk sarong fringed with white silk | Hot Tropics | festival |
Item:Lustrous seasilk weapon harness trimmed with a row of shark teeth | Finest Box of Gems (4) | |
Item:Lustrous seasilk wedding gown with embroidered design | Natural Beauty (4) | festival |
Item:Maroon seasilk slacks with tailored pleats | Fishy's Pants Mart (4) | |
Item:Mauve seasilk robe lined with cream silk | Emperor's New Robes (2) , Emperor's New Robes (1) | festival |
Item:Merchant's seasilk purse fastened by a glossy kelpzyte abacus | Limited Treasures (5) | festival |
Item:Milky white seasilk robe embroidered along the hemline | Haute Dogs and Fat Cats |