Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Blackened moonsilver]]
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=295049)
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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246 AND t1.o_id=295049)
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, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, const | 407 | 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:Filigree necklace comprised of blued moonsilver strands encircling a gem | Stolen from the Moons (3) , Item:Blue-black backpack | |
Item:Fine blackened moonsilver earcuff displaying a summer's heart sapphire | Stolen from the Moons (1) | |
Weapon:Firestained broadsword inlaid with blackened moonsilver symbols | Limited Treasures (3) , Item:Deep midnight-blue demonscale scabbard wrapped in blackened moonsilver threads | |
Item:Firestained vardite cauldron with eerily glowing mammoth bone ring handles | Hollow Eve Festival 432/Auction | true |
Item:Fist-sized sungold globe set upon a conical blackened moonsilver base | Owirvald Riverhaven Auction 420 | |
Item:Flamboyant jacquard gown showcasing skirts that resemble a roaring conflagration | Guildfest 416/Auction | |
Item:Fluted crescent of blackened moonsilver with rays displaying smoke rubies | Stolen from the Moons (3) | |
Item:Formal camlet trousers tinted the deep hue of night-tinged clouds | Natural Beauty (2) | |
Item:Fossilized adan'f skull inset with a pair of crimson moonsilver orbs | Limited Treasures (2) | |
Item:Fragile blackened moonsilver earcuff fashioned into intricate filigree | Stolen from the Moons (1) | |
Item:Fragile blued moonsilver tailband cradling a dwalgim | Stolen from the Moons (1) | |
Weapon:Frosted tyrium nodachi inlaid with blued moonsilver | House of the Revenant Fang 433/Incidental loot | |
Armor:Gilded uthamar armet crested with blued moonsilver spikes | Return to the Keep 431/Supply Wagon | |
Weapon:Glaes and crimson moonsilver kris shaped like twining serpents | Guildfest 431/Auction | |
Item:Glass-topped mikkhalbamar case secured with a prismatic moonsilver clasp | Item:Tarnished token , Stolen from the Moons (3) | |
Weapon:Gleaming dawnfire steel throwing hammer incised with glowing moonsilver symbols | Su Helmas 440: Entrapped/Raffle , Item:Canvas sack pinned with an agonite ziggurat | true |
Armor:Gleaming uthamar half plate fit with blued moonsilver pauldrons | Return to the Keep 431/Supply Wagon | |
Weapon:Glittering icesteel pike staff with a blade of hiromin | Droughtman's Challenge 441/End loot , Droughtman's Challenge 437/End loot | true |
Item:Glossy blued moonsilver-ringed octopus | Stolen from the Moons (3) | |
Item:Glowing blackened moonsilver necklace hung with a crescent-shaped crystal | Sleeping Dragon Corn Maze 447/End loot | true |
Item:Glowing blued moonsilver necklace hung with a crescent-shaped crystal | Sleeping Dragon Corn Maze 447/End loot | true |
Item:Glowing crimson moonsilver captain's ring engraved with an open eye | Droughtman's Challenge 441/Raffle | true |
Item:Glowing crimson moonsilver necklace hung with a crescent-shaped crystal | Sleeping Dragon Corn Maze 447/End loot | true |
Item:Glowing crimson moonsilver ring cradling an enormous fire whirl ruby | 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:Glowing moonsilver dove with faceted eldring eyes | ||
Item:Glowing moonsilver necklace hung with a crescent-shaped crystal | Sleeping Dragon Corn Maze 447/End loot | true |
Item:Glowing verdant moonsilver captain's ring engraved with blooming wild vines | Droughtman's Challenge 441/Raffle | true |
Item:Graceful crimson moonsilver engagement ring cradling a perfect midnight ruby | Stolen from the Moons (1) | |
Item:Gracefully curved pendant of lilac moonsilver inset with a huge absinthe emerald | Turmar-Magen Charity Auction | |
Item:Gracefully flowing cloak of living vines with a high collar of flowers | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade, Taisidon Mystery 439/A'baya Esplanade, Taisidon Mystery 435/A'baya Esplanade | |
Weapon:Greenheart battle bow adorned with golden feathers | 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, Sleeping Dragon Corn Maze 425/End loot, Aesthene's Close 449/End Loot | true |
Weapon:Grimwood longbow with gais symbols nestled among tendrils of blackened moonsilver | Item:Shadowy pack pinned with a midnight diamond moon , Drathrok's Duskruin 448/Raffle | true |
Armor:Gryphon-like plate chanfron forged from silversteel | Guildfest 431/Auction , Item:Capacious Imperial weave saddlebag clasped with a soulstone tower | |
Item:Handful of tiny verdant moonsilver and violet amber beads | Stolen from the Moons (3) | |
Weapon:Haralun flanged mace with a luminous blackened moonsilver-wrapped haft | Stolen from the Moons (2) | |
Item:Heart-shaped vengeance rubies wrapped in blackened moonsilver chains | Item:Provocative black dress flaunting elaborate blackened moonsilver beading , Limited Treasures (4) | |
Item:Heavy blackened moonsilver earrings cradling nightfire opals | Item:Tantalizing ebony duchess satin gown with a dramatically high collar , Limited Treasures (4) | |
Item:Heavy blued moonsilver anklet displaying a single dwalgim | Stolen from the Moons (1) | |
Item:Heavy blued moonsilver tailband featuring an ocean's heart diamond | Stolen from the Moons (1) | |
Item:Heavy moonsilver necklace inset with forest's heart garnets | Stolen from the Moons (1) | |
Item:Heavy moonsilver repair case with an embroidered shoulder strap | Stolen from the Moons (3) , Item:Miniature Rose Maiden's Cavern crafted from blackened moonsilver, Item:Miniature Dwarven maiden figurine wrought from blued moonsilver, Item:Miniature Dwarven lady figurine wrought from lilac moonsilver, Item:Miniature Dwarven huntress figurine wrought from verdant moonsilver, Item:Miniature Dwarven damsel figurine wrought from blackened moonsilver, Item:Miniature Cordhvirae Stonesekker figurine holding a thorny white sapphire rose | |
Item:Hexad of moonsilver monocles of varying sizes | Stolen from the Moons (3) | |
Item:High war saddle clad in silversteel plates | Guildfest 431/Auction , Item:Capacious Imperial weave saddlebag clasped with a soulstone tower | |
Armor:Icesteel armor frosted with moonsilver | Guildfest 431/Auction | true |
Armor:Icesteel aventail outlined in eerily glowing blackened moonsilver | Drathrok's Duskruin 448/End Loot | true |
Shield:Icesteel buckler displaying an array of blued moonsilver shards | Stolen from the Moons (2) | |
Armor:Icesteel cap outlined in eerily glowing blackened moonsilver | Drathrok's Duskruin 448/End Loot | true |
Armor:Icesteel cuirass inlaid with labyrinthine moonsilver | Droughtman's Challenge 444/End loot , Droughtman's Challenge 441/End loot, Droughtman's Challenge 437/End loot, Droughtman's Challenge 433/End loot | true |
Armor:Icesteel greaves outlined in eerily glowing blackened moonsilver | Drathrok's Duskruin 448/End Loot | true |
Armor:Icesteel hauberk outlined in eerily glowing blackened moonsilver | Drathrok's Duskruin 448/End Loot | true |