Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::serpent]]OR[[Uses material::Serpent]]
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
20
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
20
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 286 | 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='serpent')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=188890 - 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 |
---|---|---|
Item:Black walnut serpent fitted with soft bardic blue leather | Whimsical Winds (1) | |
Weapon:Blackened short sword etched with thin silver serpents | Hero to Go (1) | |
Item:Bleached bone torque shaped into a sea serpent skeleton with onyx eyes | Drogor Shrine | true |
Weapon:Bog oak quarterstaff carved to resemble a long snake | treasure map | true |
Weapon:Bone-hilted sabre with an intricately engraved blade | Fiery Souls (2) | |
Weapon:Braided cane of steel and carved ironwood | Walk This Way (2) | |
Item:Brass origami case | Aesry Surlaenis'a , Origami Boutique | |
Item:Brass serpent lamp | New Lamps for Gold | |
Shield:Brilliant pink triangular sipar accented with rose gold trim | Killer Pinks | |
Item:Brilliant red-gold reptile skin cloak | In Plain Sight (6) , In Plain Sight (5), In Plain Sight (4), In Plain Sight (3), In Plain Sight (2) | |
Item:Burnished copper stamping stick engraved with twining serpents | Perfect Percussion (3) | |
Armor:Burnished war plate emblazoned with a dragon entangled by serpents | Paladins' Guild , Emporium | |
Item:Cambrinth Hodierna idol | Idon Abide the Ten (3) , Idon Abide the Ten (2), Idon Abide the Ten (1) | |
Item:Cambrinth pilonu adorned with a serpent's heart ruby | Hashal's Haven | |
Item:Cambrinth pilonu inset with a Heke'mhhg lazuli | Hashal's Haven | |
Weapon:Carved ban-minahle light crossbow bearing a cambrinth medallion on the stock | Bardic Journey, Bardic Journey (7) , Bardic Journey (6) | |
Weapon:Carved ban-minahle light crossbow bearing a circular cambrinth medallion on the stock | Bardic Journey, Bardic Journey (7) , Bardic Journey (6) | |
Item:Carved chakrel serpent hung from braided leather | Burning Embers (2) | |
Item:Carved halmik serpent | Whimsical Winds (3) | |
Item:Carved ivory pegleg inlaid with a sinuous jade serpent | Item:Soft velvet haversack encased by a net of cambrinth beads , Item:Soft velvet haversack encased by a net of cambrinth beads, Curse of the Ghost Ship/End Loot | |
Item:Circlet crafted from gold wire and crystal beads | Fair Daisy | |
Item:Circular badge etched with a dragon grasping its tail in its jaws | Estate Holder gifts | |
Item:Coiled cambrinth serpent | Idon Abide the Ten (1) | |
Item:Coiled metal serpent band devouring a blackened unicorn spinel | Hollow Eve Festival 436/Auction | true |
Item:Coiled serpent ring with tyrium and kiralan scales | Hollow Eve Festival 443/Auction | true |
Item:Curling gold engagement ring crafted to resemble a lithe serpent | Wholesale Wagon | |
Item:Curried serpent kabob featuring chunks of cobra and adder meat | Engine Room Roasting Pit (3) | |
Weapon:Curved damascened scimitar with a serpent-shaped topaz pommel | Cultured Attire (6) | |
Item:Dagger-shaped crystal pendant intricately sculpted with coiling serpents and set with brilliant emeralds and rubies | Curiosities In Coral | true |
Weapon:Damascene falchion with an ironwood hilt shaped like a writhing serpent | ||
Item:Dark velvet gem pouch suspended from a blackwater jet belt toggle | House of the Revenant Fang 423/Incidental loot | |
Item:Dark walnut serpent fitted with crimson leather | Whimsical Winds (1) | |
Item:Dark walnut serpent painted with blossoming jasmine | Whimsical Winds (1) | |
Item:Dark watersilk bag bearing a detailed cambrinth medallion | Premium token raffles , Estate Holder gifts | |
Armor:Darkened mail dyed rust-red with a spiked emblem upon the chest | Dunshade: Echo of Tears/End loot | |
Weapon:Darkened onyx-hilted lata | ||
Armor:Darkened red chain helm with the visage of a striking serpent | Dunshade: Echo of Tears/End loot | |
Weapon:Darkened scimitar with a simply embossed blade | King Fade's Back Alley Bazaar (1) | |
Weapon:Darkened steel back-sword with an intricate gold handguard | Sleeping Dragon Corn Maze 428/End loot , Sleeping Dragon Corn Maze 425/End loot, Sleeping Dragon Corn Maze 421/End loot | |
Weapon:Darkspine flight crossbow with a carved ophidian-capped stock | Su Helmas: Revealed!/End loot , Su Helmas 424: The Forbidden Temple/End loot | |
Item:Delicate gold pendant in the shape of a winged serpent clutching a cambrinth egg in its talons | War and Craft (2) , War and Craft (1) | |
Item:Dragon claw necklace cut from polished black coral | Marine Marvels (3) , Marine Marvels (2), Marine Marvels (1) | true |
Weapon:Dragon-headed maul with a bocote grip | Squat Bungalow (2) | |
Weapon:Dragonwood composite bow carved to appear like two intertwined serpents | Wyrmtongue's Wares | |
Item:Dried serpent husk | Marbled angiswaerd , Grave earth pile 432 prizes, Grave earth pile 428 prizes, Grave earth pile 425 prizes, Grave earth pile 421 prizes, Grave earth pile | |
Item:Dull serpent earcuff | Pumpkin Contest 2013 , Prison Riot: The Aftermath/End loot | |
Item:Dull serpent ring of mottled steel | Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot | |
Weapon:Elegant crossbow painted with scales | Squat Bungalow (2) | |
Item:Elven gold nose-ring shaped like a snake eating its tail | Onwifa's Jewels (2) | |
Armor:Fine mesh balaclava adorned with a sinuous serpent along the neckline | War and Craft (2) , War and Craft (1) |