Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Niello]]
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=80848)
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
0
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=80848)
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, const | 90 | 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 |
---|---|---|
Item:Aldamalm violincello inlaid with strips of niello | Musiceum (3) | |
Item:Azurelle bassoon with an abstract niello and silver double helix pattern | Whimsical Winds (4) | |
Item:Barfly's challenger badge crafted from tyrium | Hollow Eve Festival 421/Auction | |
Item:Cambrinth teardrop amulet hanging from a steelsilk cord | Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 441/Incidental loot | true |
Weapon:Ceremonial silver-plated morning star lavishly embellished with niello emblems | Be'ort shrine | |
Item:Coralite kaleidoscope with niello bands | ||
Weapon:Cup-hilt dueling rapier with an intricately nielloed blade | ||
Weapon:Dark crimson sword etched with niello lightning | Misenseor Goods (6) , Misenseor Goods (5) | |
Weapon:Dark steel katavdar embossed with a black-on-black niello dragon | Q'tahhl's Place (2) , Item:Dark steel tailband embossed with a black-on-black niello dragon, Item:Dark steel tailband embossed with a black-on-black niello dragon | true |
Item:Dark steel tailband embossed with a black-on-black niello dragon | Weapon:Dark steel katavdar embossed with a black-on-black niello dragon , Q'tahhl's Place (2), Weapon:Dark steel katavdar embossed with a black-on-black niello dragon | true |
Item:Decorative silver pocket-chain suspending a squared niello fob | Knightly Attire (1) , Hollow Eve Festival 417/Raffles | |
Item:Delicate niello pilgrim's badge | Hollow Eve Festival 421/Raffles | |
Item:Divining mirror orbited by clockwork celestial bodies carved from niello | Future is Now (5) | true |
Item:Double-necked cross-strung harp of white mistglass inlaid with scenes from the life of Lanival | Hollow Eve Festival 432/Auction | true |
Item:Formal-cut black thornweave jacket with niello buttons | Kilt From Scratch | true |
Item:Ghostly white mistglass phial interlaced with niello | Item:Jacinthe dragonfire brocade makeup reticule suspended on silversteel chains , Hollow Eve Festival 425/Auction | |
Item:Glitvire zurna inlaid with Ocean's Deep emerald krakens | Hollow Eve Festival 432/Auction | true |
Item:Glitzy nielloed gold wristlet dusted with crushed estrildite | Uwresari's Exotic Wonders (1) , Finest Box of Gems (1) | |
Item:Glitzy nielloed gold wristlet encrusted with night diamonds | Uwresari's Exotic Wonders (2) , Uwresari's Exotic Wonders (1), Hollow Eve Festival 406/Raffles | |
Item:Gold and niello-wrapped serpent made of bright azure ayabere | Whimsical Winds (7) | |
Weapon:Gracefully curved haralun katana with Imperial weave bindings | ||
Item:Heavy Surlaenis gold marble signet ring embellished with a variety of gems | Hollow Eve Festival 414/Auction | |
Item:Heavy Surlaenis gold marble signet ring inset with the Trader's Guild crest in Imperial quartz | Owirvald Riverhaven Auction 427 | |
Item:Hollow Eve 439 gift | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Ichea, Hollow Eve Festival 439 | true |
Item:Hollow vortex of lightning suspended within a niello octahedron | Hollow Eve Festival 428/Auction | |
Item:Ice-blue crystal medallion hanging from a niello chain | Item:Hollow Eve 406 gift , Item:Hollow Eve 406 gift | |
Item:Intricate niello locket with a platinum chain | Cause for Locket | true |
Item:Dark steel tailband embossed with a black-on-black niello dragon | ||
Item:Glitzy nielloed gold wristlet dusted with crushed estrildite | ||
Item:Glitzy nielloed gold wristlet encrusted with night diamonds | ||
Item:Ice-blue crystal medallion hanging from a niello chain | ||
Item:Large diamondwood trunk embellished with intricate niello knotwork | ||
Item:Placid welkin figurine reticulated with black niello | ||
Item:Polished brass tailband etched with an anchor | ||
Item:Polished steel tailband with serrated edges | ||
Item:Jewelry pest | Mishli , Hollow Eve Festival 447 | true |
Item:Large cambrinth and niello wolf charm | Grey Raven Commissary | |
Item:Large diamondwood trunk embellished with intricate niello knotwork | Hollow Eve Festival 406/Auction | true |
Item:Large felwood box inset with tiny niello spiders | Hollow Eve Festival 425/Auction | |
Item:Mistglass zuceira showing the stronghold of Elamiri in blackenened moonsilver | Musiceum (7) | |
Item:Narrow mahogany ring with diamond-shaped niello inlay | Turialo's Haven (8) , Turialo's Haven (4) | |
Item:Necklace of dove bone flutes connected by thin knotted niello wire | Hollow Eve Festival 436/Raffles , Hollow Eve Festival 428/Raffles | |
Item:Niello belt decorated with seven-pointed stars | Rizadi's Outfitters (4) , Rizadi's Outfitters (3) | |
Item:Niello kaleidoscope inlaid with silver | Gift Me Up | |
Item:Niello mirror inset with gloamstone spiders upon its back | Boggle Blast (5) , Boggle Blast (4) | |
Weapon:Niello-inlaid mace with a gloomwood haft | ||
Item:Nielloed cambrinth tailband webbed in aldamdin | Hashal's Haven | |
Item:Ornate niello ring | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Sleeping Dragon Corn Maze 439/End loot, Sleeping Dragon Corn Maze 436/End loot, Sleeping Dragon Corn Maze 432/End loot, Sleeping Dragon Corn Maze 428/End loot, Item:Simple leather pouch embossed with a hand, Musical Chairs of Doom, Hollow Eve Festival 447/Raffles, Hollow Eve Festival 447/Game prizes, Hollow Eve Festival 443/Raffles, Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Raffles, Hollow Eve Festival 436/Game prizes, Hand of Glory (2), Hand of Glory (1), Game of Chicken 425 prizes, Game of Chicken 421 prizes, Finest Box of Gems (4), Boggle Blast (5), Boggle Blast (4), Boggle Blast (3), Boggle Blast (2), Blood and Gourd (2) | true |
Item:Pair of polished niello cufflinks | Amylia's Attic (3) | true |
Item:Pair of polished pitch-black leather boots fastened with niello buckles | Highway Robbery Redux | true |