Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Imperial weave]]OR[[Uses material::Imperial weave]]
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 | 58 | 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='Imperial weave')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=352451 - 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:Braided Imperial weave climbing rope reinforced with steelsilk | Droughtman's Challenge 441/End loot , Droughtman's Challenge 437/End loot, Droughtman's Challenge 433/End loot, Droughtman's Challenge 430/End loot | true |
Item:Capacious Imperial weave saddlebag clasped with a soulstone tower | Guildfest 431/Auction | |
Item:Colorful Imperial weave satchel clasped with a winged rencate and rainbow sapphire pig | Bacon Man's Birthday Bash 419 Auction | true |
Item:Demure emerald green walking dress with an embroidered gold bodice | Estate Holder Charity Auction 434 | |
Item:Demure gown of snowy Imperial weave with fur-trimmed bell sleeves | Turmar-Magen Charity Auction | |
Item:Dingy Imperial weave sack | Hollow Eve Festival 417/Auction | |
Item:E'erdream instrument case set with two lotus flower sapphire clasps | Hollow Eve Festival 417/Auction | |
Item:Elegant backpack crafted from deep crimson Imperial Weave | Hollow Eve Festival 406/Auction | |
Armor:Elegant stoneskin tweed jacket fastened with whiskey quartz buttons | Hollow Eve Festival 443/Auction , Item:Cognac-hued investigator's satchel secured with leather straps | true |
Item:Elite banker's formal contract case generously padded with Imperial weave | Drathrok's Duskruin 430/Auction | |
Item:Festive bag embroidered with vibrantly exploding fireworks | Item:Cloudlake leather pack with an Imperial quartz set in Maiden's marble , Aesthene's Close 445/Raffle | true |
Item:Flowing blindfold of purple Imperial weave | Su Helmas 444: Make Haste!/Raffle , Item:Sindon sack pinned with a purple gold blindfold | true |
Armor:Form-fitting sea diamond icesilk bodysuit shrouded in a chilling vaporous mist | Hollow Eve Festival 447/Auction | true |
Item:Ghostly white Imperial weave toy sack | Owirvald Riverhaven Auction 420 | |
Weapon:Gracefully curved haralun katana with Imperial weave bindings | ||
Armor:High-waisted stoneskin tweed trousers with black piping | Hollow Eve Festival 443/Auction , Item:Cognac-hued investigator's satchel secured with leather straps | true |
Item:Imperial blood monkey wielding a tiny asharsh'dai spear | Item:Miniature asharsh'dai palace with Imperial ruby inlay , Drathrok's Duskruin 442/Raffle | true |
Item:Imperial weave backpack set with an etched burning goldfyre medallion | Droughtman's Challenge 444/Raffle | true |
Item:Imperial weave carryall set with an etched flooded goldfyre medallion | Droughtman's Challenge 444/Raffle | true |
Armor:Imperial weave mask dyed with shadowy camouflage | Item:Canvas bag pinned with a silversteel warrior | true |
Armor:Imperial weave pants dyed with shadowy camouflage | Item:Canvas bag pinned with a silversteel warrior | true |
Armor:Imperial weave ritualist's gloves with embroidered gold eyes on the palms | Su Helmas 438: The Forbidden Temple/End loot | |
Armor:Imperial weave ritualist's sleeves draping from scarab-shaped spaulders | Su Helmas 438: The Forbidden Temple/End loot | |
Item:Imperial weave rucksack set with an etched fracturing goldfyre medallion | Droughtman's Challenge 444/Raffle | true |
Item:Imperial weave saddlebag set with an etched wuthering goldfyre medallion | Droughtman's Challenge 444/Raffle | true |
Item:Imperial weave satchel set with an etched electrified goldfyre medallion | Droughtman's Challenge 444/Raffle | true |
Armor:Imperial weave vest dyed with shadowy camouflage | Item:Canvas bag pinned with a silversteel warrior | true |
Item:Iridescent peach Imperial weave carryall speckled with sparkling crystal teardrops | Owirvald Riverhaven Auction 427 | |
Weapon:Lifesculpted whiskey quartz longbow shrouded in royal purple Imperial weave | Su Helmas 440: Entrapped/Raffle , Item:Canvas tote pinned with an indurium arrow | true |
Item:Low-heeled slippers extravagantly adorned with absinthe emeralds | Turmar-Magen Charity Auction | |
Armor:Midnight-black stormsilk battle kimono belted over an Imperial weave under-robe | Guildfest 445/Auction | true |
Item:Multicolored patchwork Imperial weave tail pouch with a stylized chaos chalcedony dragon clasp | Guildfest 445/Auction | true |
Item:Off-white Imperial weave cloak embroidered with stylized knotwork rats | Hollow Eve Festival 428/Auction | |
Item:Pair of goose-turd hued Imperial weave boots trimmed in abstract blackwork embroidery | Hollow Eve Festival 425/Auction | |
Item:Polished haledroth lighter case inset with a large faceted moonspun ruby | Guildfest 438/Auction | |
Item:Resplendent robes composed of generous layers of fluidly draped Imperial weave | Droughtman's Challenge 433/Raffle | true |
Item:Rimewolf-shaped quiver set with a magnificent Imperial weave and irinai icon | Droughtman's Challenge 437/Raffle | true |
Item:Royal blue Imperial weave caparison embroidered with towers and stars | Guildfest 431/Auction , Item:Capacious Imperial weave saddlebag clasped with a soulstone tower | |
Item:Shimmering Imperial weave kimono scattered with daggers | Estate Holder Mini-Fest 442/Auction | true |
Item:Stately weapon harness of braided Imperial weave reinforced in dawnfire steel | Item:Cloudlake leather satchel with an Imperial topaz set in Maiden's marble , Aesthene's Close 445/Raffle | true |
Item:Tiny graceful prereni of bundled shimmering fibers | House of the Revenant Fang 433/Incidental loot , House of the Revenant Fang 429/Incidental loot | |
Item:Vivid Imperial weave gown consumed in burning goldfyre | Su Helmas 444: Make Haste!/Raffle , Item:Sindon bag pinned with a burning goldfyre flame | true |
Item:Vivid Imperial weave handbag enwreathed in burning goldfyre | Su Helmas 444: Make Haste!/Raffle , Item:Sindon bag pinned with a burning goldfyre flame | true |
Armor:Voluminous khiynit robe stitched with an idyllic garden oasis | Su Helmas 440: Entrapped/Raffle , Item:Canvas pouch pinned with a purple gold garden | true |
Weapon:Gracefully curved haralun katana with Imperial weave bindings | ||
Item:Weathered Imperial weave sigil volume set with a shadow emerald and asharsh'dai medallion | Guildfest 445/Auction , Item:Enormous wraith-bone skull strung with grisly straps of sinew | true |
Weapon:Weighted rockwood staff carved with thirteen-pointed star shaped endcaps | Guildfest 423/Auction | |
Armor:Wraith-bone ritualist's helm beneath a draping violet Imperial weave shroud | Su Helmas 438: The Forbidden Temple/End loot | true |