Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Vardite]]OR[[Uses material::Vardite]]
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 | 94 | 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='Vardite')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=313805 - 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 |
---|---|---|
Weapon:Copperwood handled hatchet with a wedge-shaped kertig head | treasure map, Item:Worn and tattered map | true |
Item:Crystal-bone key traced with vardite accents | Drathrok's Duskruin 446/Drathrok's Assemblage , Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 438/Drathrok's Assemblage, Drathrok's Duskruin 435/Drathrok's Assemblage, Drathrok's Duskruin 430/Drathrok's Assemblage | true |
Weapon:Darkstone cuska dangling korograth leather pouches from sinuous chains | Hollow Eve Festival 417/Auction | |
Item:Diamond-cut vardite neithrel band fastened by several matching chains | Bardic Journey (4) | |
Item:Dragon-head forging hammer with a viridian ilomba haft | Drathrok's Duskruin 435/Auction | true |
Item:Elite banker's formal contract case generously padded with Imperial weave | Drathrok's Duskruin 430/Auction | |
Item:Elongated vardite mask shaped like a carrot | ||
Item:Fierce wolverine ring of flawless vardite | Su Helmas 444: Make Haste!/End loot , Su Helmas 440: Entrapped/End loot, Su Helmas 438: The Forbidden Temple/End loot, Su Helmas 434: The Forbidden Temple/End loot | true |
Item:Firestained vardite cauldron with eerily glowing mammoth bone ring handles | Hollow Eve Festival 432/Auction | true |
Weapon:Flowery vardite katavdar edged with a ring of sharpened scales | Item:Flowery vardite tailband carved with a layer of sharpened scales | true |
Item:Flowery vardite tailband carved with a layer of sharpened scales | Weapon:Flowery vardite katavdar edged with a ring of sharpened scales , Drathrok's Duskruin 446/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot | true |
Shield:Gleaming vardite deflector traced in glowing truegold | Aesthene's Close 449/End Loot | true |
Item:Gleaming vardite hinges | Transmutation chest , Simian Cage, Seastar Curios, S'Kra Kor warrior (2), S'Kra Kor villager (2), S'Kra Kor shaman (2), S'Kra Kor dancer | |
Item:Gold-scaled angiswaerd with firestained vardite and eldring eyes | Return to the Keep 431/Incidental loot , House of the Revenant Fang 437/Incidental loot | |
Armor:Greaves of thin vardite plates securely riveted to a padded armure interior | Owirvald Riverhaven Auction 427 , Item:Khiynit backpack with a vardite clasp | |
Item:Heavy vardite coffee mug stamped with the image of a regal dragon's head | Limited Treasures (2) | |
Armor:Heavy vardite vambraces painted with a decorative wave pattern | Taisidon Mystery 446/A'baya Esplanade | true |
Item:Ice-veined leather arm pouch of dusky peach | treasure map | true |
Weapon:Imbricated hurlable war hammer forged from a marbled vardite-kertig alloy | Sleeping Dragon Corn Maze 447/End loot , Aesthene's Close 449/End Loot | true |
Shield:Imposing vardite oval shield shrouded in jeweled lyrandia vines | Owirvald Riverhaven Auction 420 | |
Item:Intricate vardite shesegri ring interspersed with dragon's eye ruby flecks | Sumptuous Silks (4) , Sumptuous Silks (3), Sumptuous Silks (2) | true |
Weapon:Ironwood-hafted hand mace crowned with a spherical vardite head | Prison Riot: The Aftermath/End loot , Curse of the Ghost Ship/End Loot | |
Item:Carved flamewood abacus with polished vardite beads | ||
Item:Intricate vardite shesegri ring interspersed with dragon's eye ruby flecks | ||
Item:Kertig spider with vardite chelicerae | Accents for the Arachnophile (7) , Accents for the Arachnophile (6), Accents for the Arachnophile (5), Accents for the Arachnophile (4), Accents for the Arachnophile (3) | |
Item:Khiynit backpack with a vardite clasp | Owirvald Riverhaven Auction 427 | |
Armor:Lamellar gloves (crafted) | ||
Weapon:Long-bladed vardite hanger with a walnut handle | Sleeping Dragon Corn Maze 428/End loot | |
Weapon:Long-bladed vardite hanger with an ivory handle | Sleeping Dragon Corn Maze 447/End loot , Aesthene's Close 449/End Loot | true |
Shield:Massive vardite phalanx shield with a blackened skull boss | Su Helmas 424: The Forbidden Temple/End loot | |
Item:Muscular vardite lion | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade, Taisidon Mystery 439/A'baya Esplanade, Taisidon Mystery 435/A'baya Esplanade | true |
Item:Necklace of morgawr fang flutes connected by vardite wire | House of the Revenant Fang 437/Shadowy Safehouse , House of the Revenant Fang 433/Shadowy Safehouse | |
Item:Opulent thigh bag cut from goldweave | Thryntyrlz BagMaker's Yurt (4) | |
Item:Pair of polished vardite cufflinks | Amylia's Attic (3) | true |
Armor:Pair of vardite brigandine gloves embellished with tawny feathers | Hollow Eve Festival 414/Auction | true |
Item:Polished morlam mysanda of tiger lily carnelian set in vardite | Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot , Aesthene's Close 445/Vault | true |
Item:Polished orange vardite sackbut adorned with onyx koi designs | Whimsical Winds (3) | |
Weapon:Saffron vardite morning star | Sputkin's Splendors (4), Sputkin's Splendors (5) , Sputkin's Splendors (4) | |
Armor:Segmented bone gloves reinforced with gravecloth padding | Drathrok's Duskruin 442/Incidental loot, Drathrok's Duskruin 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot | true |
Armor:Segmented bone helm fastened to a gravecloth hood | Drathrok's Duskruin 442/Incidental loot, Drathrok's Duskruin 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot | true |
Armor:Segmented bone mask reinforced with a vardite bridge | Drathrok's Duskruin 442/Incidental loot, Drathrok's Duskruin 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot | true |
Item:Sharpened vardite skinning knife stamped with a unicorn | Drogor Shrine | true |
Shield:Triple-reinforced vardite pavise shield | ||
Item:Shrunken yeehar skull with twin howlite spheres set into the eye sockets | treasure map | true |
Shield:Simple vardite aegis | Guildfest 412/Auction | |
Item:Slim vardite knife wrapped in tawny gold and amethyst silks | House of the Revenant Fang 437/Incidental loot | |
Item:Small silver Wayerd pyramid inlaid with vardite squares | Skyward Crafting (2) | true |
Weapon:Smokewood nightstick studded with heavy vardite knobs | treasure map, Item:Worn and tattered map | true |
Item:Stormtouched cloudbark kalimba with seven prismatic keys | Hollow Eve Festival 443/Auction | |
Item:Tiny icon of metal | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes |