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
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
`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
0
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 |
---|---|---|
Weapon:Acid-etched two-handed sword with quillions shaped like writhing serpents | Turquoise Tent | |
Item:Adderstone band carved into a sea serpent grasping its own tail | Drogor Shrine | true |
Weapon:Adderwood latchbow set with serpent's heart rubies | Snake Pit | |
Weapon:Adderwood shortbow shaped like twin serpents | Snake Pit | |
Item:Agate ring with a bronze serpentine band | Trader Shop (Crossing) | |
Item:Animite earring shaped like a serpent coiled around an aevanstone | Visions in Crystal | |
Weapon:Antiqued silver-edged broadsword with a snake-shaped brass guard and falcon pommel | Iprilu's Emporium (obsolete) | |
Armor:Burnished war plate emblazoned with a dragon entangled by serpents | ||
Armor:Darkened mail dyed rust-red with a spiked emblem upon the chest | ||
Armor:Darkened red chain helm with the visage of a striking serpent | ||
Armor:Fine mesh balaclava adorned with a sinuous serpent along the neckline | ||
Armor:Old leather helm tooled with writhing serpents | ||
Item:Bat-winged leather boots covered in iridescent scales | Squat Bungalow (2) | |
Item:Black gold monocle with silver filigree | Scavenger Hunt 2013 | |
Item:Black hooded cloak embroidered with a snake around the hem | Crafty Cloaks (2) , Crafty Cloaks (1) | |
Item:Black jade tailband elegantly carved with serpent scales | Turialo's Haven (6) , Turialo's Haven (5), Turialo's Haven (3) | |
Item:Black linen robe adorned with the adder of Asketi | Hollow Eve Festival 417/Raffles | |
Item:Black snakeskin backpack clasped with a gold serpent coiled around a sapphire | Obscured Visions | |
Item:Black snakeskin sheath wrapped with twisted iron wire | Obscured Visions | |
Item:Black velvet cloak embroidered with a hissing serpent coiled around a sword | Gildalily's Adornments | |
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 |