Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Tyrium]]OR[[Uses material::Tyrium]]
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 | 257 | 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='Tyrium')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=209850 - 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 |
---|---|---|
Armor:Rich purple breastplate decorated with mottled ruddy black verenite | ||
Armor:Tyrium balaclava decorated with a row of night diamonds along the edge | ||
Armor:Tyrium balaclava decorated with a row of vivid lime yoakenite beads along the edge | ||
Weapon:Balanced tyrium nodachi inlaid with verdant moonsilver | House of the Revenant Fang 433/Incidental loot | true |
Item:Barfly's challenger badge crafted from tyrium | Hollow Eve Festival 421/Auction | |
Item:Bat-winged leather boots covered in iridescent scales | Squat Bungalow (2) | |
Item:Black ankle pouch stitched with a tyrium-hued donkey | Hollow Eve Festival 428/Raffles | |
Shield:Blackened steel targe embellished with a complex tyrium-studded design | treasure map, Item:Worn and tattered map | true |
Item:Bocote telescope case with tyrium end caps | ||
Item:Charred gloomwood cufflinks edged in tyrium | Finer Things (5) | |
Item:Coiled serpent ring with tyrium and kiralan scales | Hollow Eve Festival 443/Auction | true |
Item:Commemorative coin with rippled edges | 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:Compact lockpick case stamped with a depiction of the Darkfell Abyss | Sketchy By Design (9) | |
Item:Competition miniature Merelew soldier wielding a tiny trident | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | true |
Item:Dark blue leather bullwhip with a tyrium-studded grip | Hollow Eve Festival 410/Raffles | |
Item:Deep plum and black tartan kilt fastened with a tyrium dagger-shaped pin | Naked Sheep (5) | |
Item:Deep plum westan wool vest secured with tyrium buttons | Naked Sheep (5) | true |
Weapon:Deep purple cinquedea | Uwresari's Exotic Wonders (1) | |
Item:Delicate bracelet of interlocking striped seaperch | 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:Delicate cluster of tyrium shalryia blossoms | House of the Revenant Fang 433/Incidental loot , House of the Revenant Fang 429/Incidental loot | |
Weapon:Diamondwood riste embedded with tyrium blades | Hollow Eve Festival 439/Auction | true |
Item:Diaphanous gown of wisteria mistsilk with a cascading spun glitter floral motif | Natural Beauty (1) | |
Armor:Diminutive long-sleeved robe crafted from a fine mesh of miniscule tyrium links | Hollow Eve Festival 403/Auction | true |
Item:Dusty serpentine-hide mining supplies bag edged by folksy alshabi stone talismans | Limited Treasures (1) | |
Weapon:Dwarven greataxe with an intricately-engraved tyrium double-bladed head | Aesthene's Close 449/End Loot , Aesthene's Close 445/Vault | true |
Weapon:Elegant tyrium nodachi inlaid with lilac moonsilver | House of the Revenant Fang 433/Incidental loot | |
Item:Engraved tyrium ball-peen hammer accented with a leather-wrapped handle | Item:Polished haralun toolbox set with a simple gold lock , Item:Polished haralun toolbox set with a simple gold lock, Hollow Eve Festival 403/Auction, Guildfest 401/Auction | true |
Item:Etched tyrium Tokka deck | Future is Now (4) | |
Item:Extravagant tyrium engagement ring flaunting a circle of voilynes | Wedding Belles (2) , Wedding Belles (1) | true |
Item:Fluted tyrium hairstick topped with a topaz-hued zerarin wool Idon's Trumpet | Tildi's Blooms (3) , Tildi's Blooms (2), Tildi's Blooms (1) | |
Weapon:Folded tyrium and kertig katana with an elaborately watermarked blade | Hollow Eve Festival 399 Auction, Item:Gloomwood katana sheath wrapped in braided shadesatin dyed a deep wine red , Hollow Eve Festival 399/Auction, Item:Gloomwood katana sheath wrapped in braided shadesatin dyed a deep wine red | |
Item:Form-fitting zerarin lace gown fastened by tyrium buckles | Damsel In This Dress (1) | |
Item:Fragile blossom with delicate petals | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | true |
Item:Frosted seaglass cowbell inlaid with sea-calves along the rim | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | true |
Weapon:Frosted tyrium nodachi inlaid with blued moonsilver | House of the Revenant Fang 433/Incidental loot | |
Weapon:Gargantuan tyrium dire mace enwreathed with thorny shrike's bounty brambles | Hollow Eve Festival 432/Auction | true |
Item:Glamorous black purse stitched with a tyrium-hued spider | Hollow Eve Festival 425/Raffles | |
Armor:Gleaming plate gauntlets embellished with tyrium scrollwork along the cuffs | treasure map | true |
Weapon:Glittering knuckles fashioned from a multi-colored alloy of tyrium shards | Hollow Eve Festival 439/Auction | true |
Item:Glitvire and tyrium key | Item:Octagonal glitvire sweetheart's token box with a latticework tyrium lid , Limited Treasures (1), Item:Hexagonal glitvire suitor's token box with a latticework tyrium lid | |
Item:Globular dusky smokewood case | Hollow Eve Festival 410/Raffles | |
Item:Gloomwood katana sheath wrapped in braided shadesatin dyed a deep wine red | Hollow Eve Festival 399/Auction | |
Weapon:Gloomwood khuj with a dark purple blade | Uwresari's Exotic Wonders (1) | |
Weapon:Gloomwood khuj with er'qutrite inlay along the blade | Uwresari's Exotic Wonders (1) | |
Weapon:Gloomwood skirmisher's lance with a leaf-shaped tyrium tip | Hollow Eve Festival 403 Auction, Hollow Eve Festival 403/Auction | |
Shield:Gloomwood tower shield banded with tyrium | Uwresari's Exotic Wonders (1) | |
Item:Golden brown westan wool vest layered over a tyrium-threaded lipka cotton shirt | Limited Treasures (1) | |
Item:Gracefully curved tyrium earcuff draped with chains of pure white mistglass | Hollow Eve Festival 417/Auction | true |
Template:HE2020Metals | ||
Item:Hammered toe bells in the shape of 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 | true |