Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Steelsilk]]
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
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246 AND t1.o_id=68921)
AND 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
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246 AND t1.o_id=68921)
AND 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 | index_merge | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id,o_id_3 | 5,9 | 398 | Using intersect(o_id,o_id_3); Using where; Using temporary; Using filesort | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Armor:Deep blue chain patterned in silvery-white steelsilk with dazzling stars entwined among hemlock blossoms | ||
Armor:Double-breasted coat tailored of dark steelsilk (1) | ||
Armor:Double-breasted coat tailored of dark steelsilk (2) | ||
Armor:Ebony mail interwoven with golden steelsilk links forming a cascade of lightning bolts | ||
Armor:Fine chainmail armor lined in steelsilk | ||
Armor:Pair of steelsilk trousers with blackened steel buttons | ||
Armor:Pair of steelsilk trousers with blackened steel buttons (2) | ||
Armor:Rugged wolfskin leathers | ||
Armor:Scarlet canvas-backed bone breastplate | ||
Armor:Silvered chain woven over the heart with steelsilk links forming a white dove bearing a broken sword | ||
Armor:Sinuous icesteel hauberk embellished with intricate patterns of haze sapphires | ||
Armor:Small damite helm | ||
Item:Armure tunic cut in a strident style and tinted harmonious shades of red | Natural Beauty (2) | |
Item:Assassin's thigh pouch with steelsilk ties | Quest for Kanton's Dagger | |
Armor:Austere brigandine hauberk fastened with steelsilk straps | Hollow Eve Festival 406/Raffles | |
Item:Austere judge's robe sewn from somber black steelsilk | treasure map | true |
Item:Austere steelsilk mantle with a soulstone clasp | Merit Badges (4) , Merit Badges (3), Merit Badges (2) | true |
Item:Austere steely blue kimono cut to display a Longleaf lotusweave under-robe | Limited Treasures (2) | |
Item:Baggy blue overalls with folded cuffs | Sleeping Dragon Corn Maze 447/Incidental loot , Sleeping Dragon Corn Maze 443/Incidental loot, Sleeping Dragon Corn Maze 439/Incidental loot, Sleeping Dragon Corn Maze 436/Incidental loot, Sleeping Dragon Corn Maze 432/Incidental loot | |
Weapon:Balanced metal dart | Mimfilrin's Darts and Blades | |
Weapon:Barbed dart with sleek black feather flights | Over the Edge (1) | |
Weapon:Barbed dart with sleek black feather flights (2) | Over the Edge (2) | |
Item:Bedraggled robes with brownish-red bloodstains covering a Barbarians' Guild crest | Darker Shade of Night (1) | |
Item:Beige steelsilk cloak with a missing clasp | Pi'rasha's Pins (3) | true |
Item:Belted doeskin baldric tooled with a flame wreathed black dragon | ||
Item:Billowing robe of heavy grey and scarlet silk | War and Craft (2) , War and Craft (1), Escogar's Magical Aids | |
Item:Black bear-hide sporran adorned with raccoon tails | ||
Armor:Black leather helm reinforced with a multitude of ironwood plates (1) | Goods for Life (2) , Goods for Life (1) | |
Armor:Black leather helm reinforced with a multitude of ironwood plates (2) | Goods for Life (4) , Goods for Life (3) | |
Item:Blackened eyepatch of reinforced camlet sporting a Drogor's Wrath sapphire emblem | Natural Beauty (2) | |
Weapon:Blackened steel parry stick with sturdy steelsilk straps | Goods for Life (4) , Goods for Life (3), Goods for Life (2), Goods for Life (1) | |
Weapon:Blackened steel trident (1) | ||
Weapon:Blackened steel trident (2) | Dark Defenders (2) | |
Weapon:Blackwood latchbow with a steelsilk wrapped stock | Drathrok's Duskruin 442/Incidental loot, Drathrok's Duskruin 438/Incidental loot, Drathrok's Duskruin 435/Incidental loot, Drathrok's Duskruin 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot | |
Item:Blue-grey steelsilk backpack dangling small bones from lengths of leather cord | Dunshade: Echo of Tears/End loot | |
Item:Blue-grey steelsilk cloak trimmed black braid | All the King's Men (2) , All the King's Men (1) | |
Item:Blue-grey steelsilk cloak trimmed with black braid | All the King's Men (3) | true |
Armor:Bone greaves etched with grimacing skulls | ||
Armor:Bone vambraces with silver skull clasps | Paladins' Guild , Emporium | |
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:Braided toolstrap with steelsilk ties | Ties for Things (5) , Ties for Things (4), Ties for Things (3), Ties for Things (2), Ties for Things (1) | |
Weapon:Bright red indurium scimitar dangling a trio of feathers from its hilt | Droughtman's Challenge 444/End loot , 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:Bronze-tipped indigo steelsilk backsheath embroidered with the image of a laughing dragon | Hollow Eve Festival 414/Raffles | |
Armor:Burnished chain gloves laced with steelsilk ribbon | Storms of Silk | |
Item:Cambrinth teardrop amulet hanging from a steelsilk cord | Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 441/Incidental loot | true |
Armor:Chain-lined steelsilk robe sashed with electric blue cire | Storms of Silk | |
Armor:Chainmail robe overlain by long swaths of steelsilk | Hollow Eve Festival 410/Raffles | |
Item:Charcoal-grey steelsilk casaque with an upright collar | Knight at the Club (2) | true |
Item:Coal black steelsilk dress hemmed with acenite beads | Turialo's Haven (10) | |
Item:Cream-colored steelsilk gown with a forest-green overskirt | Wandering Woodsman (5) | true |