Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Noun is::gauntlets]]
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='gauntlets') AND t1.p_id=2021224)
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
110
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='gauntlets') AND t1.p_id=2021224)
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
110
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, p_id, o_hash, s_id_2 | p_id | 262 | const, const | 312 | Using index condition; 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 | Is incomplete |
---|---|---|---|
Armor:Aubergine gauntlets inset with stormfire topazes | Shiny's Shinies (2) , In Shining Armor | ||
Armor:Augmented gladiatorial gauntlets (crafted) | true | ||
Armor:Battered plate gauntlets | Drathrok's Duskruin 419/Incidental loot | ||
Armor:Battle-worn heavy plate gauntlets | Ruins of Ulf'Hara/Supply Wagon , Return to the Keep 423/Supply Wagon | ||
Armor:Black gauntlets embellished with golden seven-pointed stars | Imperial Imports (1) | ||
Armor:Black gauntlets forged to resemble razor-sharp claws of a lion's paw | Outcast Military Surplus | ||
Armor:Black gauntlets trimmed in platinum | Acaph's Acquisitions | ||
Armor:Black leather gauntlets | Thug (creature5) , Footpad (creature5) | ||
Armor:Black leather gauntlets with bronze charms sewn into the cuffs | Emmiline's Cottage | ||
Armor:Black leather gauntlets with knotwork tooled on the flared cuffs | Elemental Lunacy | ||
Armor:Black leather gauntlets with steel spikes along the knuckles | Item:Glistening black armored pack with platinum rivet fastenings , Curse of the Ghost Ship/End Loot | ||
Armor:Black scale gauntlets with ornamental silvered talons extending from the fingertips | Edword's Accoutrements (4) , Edword's Accoutrements (3), Edword's Accoutrements (2) | ||
Armor:Black steel gauntlets | Maelshyvean cinder beast | ||
Armor:Black taloned gauntlets made to resemble a snake's shifting scales | Gift of the Tail | ||
Armor:Blackened bone gauntlets | Leftovers (3) , Leftovers (2), Leftovers (1) | ||
Armor:Blackened bone gauntlets with the shadowy image of a panther | Leftovers (3) , Leftovers (2), Leftovers (1) | ||
Armor:Blackened chain gauntlets affixed with tarnished steel wrist guards | Item:Dusky-black basilisk hide satchel decorated with pard claws along the flap , Curse of the Ghost Ship/End Loot | ||
Armor:Blackened chain gauntlets tipped in silver claws | Alret | ||
Armor:Blackened leather gauntlets | Griniel's Cottage | ||
Armor:Blackened mail gauntlets (1) | It's Elemental | ||
Armor:Blackened mail gauntlets (2) | Akigwe's Legacy: Secrets of the Tower/End loot | ||
Armor:Blackened mail gauntlets worked with silver gryphons | Women at Arms (4) , Women at Arms (3), Women at Arms (2), Women at Arms (1) | ||
Armor:Blackened steel gauntlets with spiked knuckles | Goods For The Soul | ||
Armor:Blackened steel heavy plate gauntlets | Ruins of Ulf'Hara/Supply Wagon , Return to the Keep 423/Supply Wagon | ||
Armor:Bleached bone gauntlets | Pirate mercenary , Paladins' Guild , Emporium | ||
Armor:Bloodstained bone gauntlets | Leftovers (3) | ||
Armor:Bloodstained bone gauntlets with dark encrusted talons | Leftovers (3) | ||
Armor:Blued chain gauntlets with fire-gilded fluted steel cuffs | Edword's Accoutrements (1) | true | |
Armor:Bone gauntlets | Scavenger goblin , Forager goblin | ||
Armor:Brass-studded leather dueling gauntlets with gilt-edged tooling on the cuffs | Hollow Eve Festival 406/Raffles , Hollow Eve Festival 396/Raffles, Edword's Accoutrements (4), Edword's Accoutrements (3), Edword's Accoutrements (2) | ||
Armor:Bronze gauntlets edged with green verdigris | Acaph's Acquisitions | ||
Armor:Bronze scale gauntlets augmented with antiqued silver lames | Edword's Accoutrements (1) | ||
Armor:Bronze spike-knuckled gauntlets | Martrem's Forge and Armory | ||
Armor:Burnished silver gauntlets with sable leather cuffs edged in thin bronze chain | Elahkti's Metal Arts, Elahkti's Metal Arts (2) , Elahkti's Metal Arts (1) | ||
Armor:Cerulean blue heavy plate gauntlets | Ruins of Ulf'Hara/Supply Wagon , Return to the Keep 423/Supply Wagon | ||
Armor:Chalky white bone gauntlets | Skin and Bones | false | |
Armor:Crimson bone gauntlets with dark encrusted talons | Leftovers (5) , Leftovers (4) | true | |
Armor:Crimson gauntlets trimmed in black | Moon Mage Pavilion , Essential Sects Shop (1) | ||
Armor:Damite plate gauntlets embedded with shards of kertig-laced granite | Hollow Eve Festival 414/Auction | ||
Armor:Dark chain gauntlets with spiked golden knuckle guards | Edword's Accoutrements (3) , Edword's Accoutrements (2) | true | |
Armor:Dark chain gauntlets with spiked iron knuckle guards | Prison Riot: The Aftermath/Incidental loot | ||
Armor:Dark gauntlets embossed with the symbol of Trothfang | Anthyl's Wagon (1) | ||
Armor:Dark gauntlets with an etched red adder on the back of the hands | Stalwart Asketian herald | ||
Armor:Dark red gauntlets with golden rivets | Acaph's Acquisitions, Acaph's Acquisitions | ||
Armor:Dark spiked gauntlets | War at Sea | true | |
Armor:Dark steel gauntlets affixed with curved talons | Dragon Priest zealot | ||
Armor:Dark steel gauntlets set with shadowy sapphires | Hollow Eve Festival 406/Raffles | ||
Armor:Dark steelsilk gauntlets (1) | Goods for Life (1) | ||
Armor:Dark steelsilk gauntlets (2) | Goods for Life (2), Goods for Life (4) , Goods for Life (3), Goods for Life (2) | ||
Armor:Darkened blue chain gauntlets backed with bladed knuckles | Item:Thick leather backpack embellished with polished blue chain links , Item:Thick leather backpack embellished with polished blue chain links, Dunshade: Echo of Tears/End loot |