Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Iroko]]
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=537693)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
505
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
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246 AND t1.o_id=537693)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
505
OFFSET
10
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 | 93 | 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:Dark iroko wood repair case | Siegery Shop (4) , Siegery Shop (3), Siegery Shop (2), Siegery Shop (1) | |
Weapon:Darkened iroko arbalest with anloral holy symbols upon a glaes lath | Hollow Eve Festival 414/Auction | true |
Item:Eccentric tawny suede boots flaunting multi-colored faesilk fringe | Limited Treasures (3) | |
Item:Elegant iroko keepsake box inlaid with intricate blue gold whorls | Limited Treasures (3) | |
Item:Feathery seaweed fronds dappled with swirls | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | |
Item:Folding chair with a cushioned seat | Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Fragile sea globe with a polished base | 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:Gloomy iroko-framed oubliette trimmed with bloodlace panels | Kitten Emporium (3) , Kitten Emporium (2) | |
Item:Glossy iroko clogs with stocky heels | Nigeyi's (4) | |
Item:Glossy iroko floor laid with wide planks | Floors for Thought (2) | true |
Template:HE2020Woods | ||
Item:Harp case of woven iroko | Musiceum (1) | |
Item:Hexagonal divining mirror set within an iroko frame | Future is Now (5) | true |
Item:Hexagonal iroko trinket box | Finer Things (5) | |
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 |
Talk:Hollow Eve Festival 436/Game prizes | ||
Hollow Eve Festival 436/Game prizes/Material options | ||
Item:Inlaid ash and iroko wall with a design of bare trees against a full moon | Trees Four Walls | true |
Item:Iroko circlet adorned with faceted heliotropes | Everlasting Beauty (2) , Everlasting Beauty (1) | |
Weapon:Iroko club with a rawhide-wrapped handle | ||
Item:Iroko comb with wide teeth | Everlasting Beauty (2) , Everlasting Beauty (1) | |
Item:Iroko door inset with a brass relief of a snake-haired woman's head | Katy Gore The Door | |
Item:Iroko door with a demon's head door knocker | Two Doors Down (2) , Two Doors Down (1) | true |
Item:Iroko hairbrush adorned with a painted design | Everlasting Beauty (2) , Everlasting Beauty (1) | |
Item:Iroko hautbois with oravir keys | Musiceum (3) , Musiceum (2), Musiceum (1) | |
Item:Iroko kaleidoscope with tyrium bands | Hollow Eve Festival 439/Raffles | |
Item:Iroko key | Limited Treasures (1) | |
Item:Iroko lyre inlaid with niello | Lute the Room | |
Item:Iroko nehpar'i topped with an arachnid-shaped headstock | Item:Large aldamalm instrument case with an erythraean toggle | |
Item:Iroko settee carved with snarling visages | Sofa So Good (2) , Sofa So Good (1) | true |
Item:Iroko woodburning | Reinventing the Wheel (4) | true |
Item:Iroko-framed arched window | Pane in the Glass | |
Item:Iroko-framed octagon window | Pane in the Glass | |
Item:Iroko-framed shaman's bodhran with coralite-caught thin pigskin drumheads | This Little Piggy (6) | |
Item:Iroko-paneled wall with a thin chair rail | Wally's World of Walls (2) , Wally's World of Walls (1) | true |
Weapon:Iron iltesh incised with intricate irises along the iroko handle | ||
Item:Harp case of woven iroko | ||
Item:Rich brown instrument bow made of iroko | ||
Item:Wide iroko bracelet carved with birds in flight | ||
Item:Jaundice-yellow iroko alchemist's kit set with a sickly green spiritgem | Hollow Eve Festival 443/Auction | true |
Item:Lacquered abacus strung with polished beads | 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:Lacquered band set with a tiny clownfish | 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:Latticed picnic basket tied with sea otters | 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:Lifesculpted iroko violincello with tawny amber tuning pegs | Hollow Eve Festival 410/Auction | |
Item:Miniature Merelew woodsman figurine carrying an iroko walking staff | Siegery Shop (5) | |
Item:Miniature Stylist Almodivar figurine immaculately attired in midnight green madun | Siegery Shop (2) | |
Item:Miniature fur-clad sideshow performer skewered by three thin zingana spears | Item:Spacious flat-top travel trunk plastered with numerous faded sideshow posters , Limited Treasures (1) | |
Item:Miniature orichalcum-framed trader shop enclosed in goldweave | Kitten Emporium (3) , Kitten Emporium (2) | |
Item:Miniature turtles | 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:Octagonal box enameled with a Harawep's Pawn spider | Accents for the Arachnophile (2) | |
Item:Octagonal casket made of iroko wood aged to a dark brown hue | Limited Treasures (2) | true |
Item:Ornate iroko 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, 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), Finest Box of Gems (3), Finest Box of Gems (2), Finest Box of Gems (1), Boggle Blast (2), Blood and Gourd (2) | true |
Item:Overfed avian bodysuit shrouded in plumage | This Little Piggy (6) | |
Item:Pair of dark iroko chopsticks capped in boneflower-carved ivory | Tildi's Blooms (4) , Tildi's Blooms (3) | |
Item:Pair of dice with shell-shaped pips | 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:Pair of interlocking iroko and alerce armbands | Accents for the Arachnophile (5) , Accents for the Arachnophile (4), Accents for the Arachnophile (3) | |
Item:Pair of iroko sandals with black madun straps | Fashionable Panda (2) | |
Item:Pale iroko ring carved with tiny images of death spirits | Game of Chicken 425 prizes , Game of Chicken 421 prizes, Game of Chicken | |
Item:Pilgrim's badge sculpted with the emblem of an Immortal | 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:Polished cane entangled by a sprawling kraken | 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:Polished comb with blossoms in bas-relief | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Weapon:Polished iroko stonebow with a fuchsia leather sling | Killer Pinks | true |
Weapon:Polished steel maul with an iroko handle | To The Hammer Born (2) , To The Hammer Born (1) | true |
Item:Polished wand topped with a starfish | 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:Repair case of polished wood with fittings | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | true |
Item:Resplendent iroko ring | House of the Revenant Fang 437/Shadowy Safehouse , House of the Revenant Fang 433/Shadowy Safehouse, House of the Revenant Fang 429/Shadowy Safehouse, House of the Revenant Fang 423/Shadowy Safehouse, Item:Austere stormsilk pouch clasped with a starsteel lightning bolt, Aesthene's Close 445/Vault, Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot | true |
Item:Rich brown instrument bow made of iroko | Musiceum (3) , Musiceum (2), Musiceum (1) | |
Weapon:Rich golden iroko flight bow tipped by forest green stura atulave | Hollow Eve Festival 421/Auction | |
Item:Round yo-yo engraved with 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 | |
Item:Several iroko bars in differing shades | Hair Apparent (4) , Hair Apparent (3) | |
Item:Sharpened copper razor with a polished handle | 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:Simple iroko ring | Sleeping Dragon Corn Maze 428/End loot , Musical Chairs of Doom, Harawep Shrine 425, Harawep Shrine 421, Hand of Glory (2), Hand of Glory (1), Grave earth pile 421 prizes, Game of Chicken 425 prizes, Game of Chicken 421 prizes, Boggle Blast (2), Bobbing for Leeches | |
Item:Slender kaleidoscope with burnished bands | 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:Small coralite xylophone with a wide leather strap | Musiceum (8) | |
Item:Spherical iroko token box with an intricate blue gold latch | Limited Treasures (3) | |
Item:Spherical suitor's token box of richly contrasting iroko marquetry | Limited Treasures (1) | |
Item:Spherical sweetheart's token box of richly contrasting iroko marquetry | Limited Treasures (1) | |
Weapon:Subtly twisted iroko trident suspending a trio of midwinter's sickles | Piralpa Tridents (3) | |
Item:Sweeping dendritic cloak of living vines strewn with small 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 | |
Item:Tall tankard topped with a sprawling kraken | 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:Triangular iroko psaltery adorned with cambrinth flourishes | Dark Symphony (5) , Dark Symphony (4), Dark Symphony (3) | |
Weapon:Twisted iroko staff inlaid with slender lines of niello | ||
Item:Wide iroko bracelet carved with birds in flight | Natural Beauty (1) |