User:Defenestration/SpreadsheetUniqueListPleaseNoNuke: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
(added dropareas)
(where clause)
Line 2: Line 2:
|tables=items
|tables=items
|fields=items._ID=rowId, items._pageName=pageName, items.name, items.class, items.base_item, items.drop_areas
|fields=items._ID=rowId, items._pageName=pageName, items.name, items.class, items.base_item, items.drop_areas
|items.rarity="Unique"
|where=items.rarity="Unique"
|format=table
|format=table
}}
}}

Revision as of 17:49, 22 March 2023

rowId pageName name class base item drop areas
19,705 User:Balaar/sandbox/testcases/Wurm's Molt Wurm's Molt Belt Leather Belt
37,101 Abhorrent Interrogation Abhorrent Interrogation Gloves Ambush Mitts
37,106 Actum Actum One-Handed Axe Butcher Axe
37,121 Ahuana's Bite Ahuana's Bite Quiver Sharktooth Arrow Quiver
37,122 Akoya's Gaze Akoya's Gaze Helmet Regicide Mask
37,125 Algor Mortis Algor Mortis Gloves Carnal Mitts
37,129 Altered Distant Memory Altered Distant Memory Map Synthesised Map MavenHub
37,130 Amanamu's Gaze Amanamu's Gaze Abyss Jewel Ghastly Eye Jewel
37,131 Ambition Ambition Item Piece Vaal Aspect
37,139 Anathema Anathema Ring Moonstone Ring
37,141 Ancestral Vision Ancestral Vision Jewel Viridian Jewel
37,147 Ancient Skull Ancient Skull Helmet Bone Helmet
37,158 Apex Mode Apex Mode Jewel Cobalt Jewel
37,168 Arn's Anguish Arn's Anguish Belt Cloth Belt
37,180 Assailum Assailum Helmet Sinner Tricorne
37,182 Astral Projector Astral Projector Ring Topaz Ring
37,192 Atziri's Rule Atziri's Rule Warstaff Judgement Staff
37,203 Augmented Distant Memory Augmented Distant Memory Map Synthesised Map MavenHub
37,214 Badge of the Brotherhood Badge of the Brotherhood Amulet Turquoise Amulet
37,223 Beacon of Madness (Cold and Lightning Resistance) Beacon of Madness Boots Two-Toned Boots
37,224 Beacon of Madness (Fire and Cold Resistance) Beacon of Madness Boots Two-Toned Boots
37,225 Beacon of Madness (Fire and Lightning Resistance) Beacon of Madness Boots Two-Toned Boots
37,227 Bear's Girdle Bear's Girdle Belt Leather Belt
37,228 Beauty Beauty Item Piece Vaal Aspect
37,247 Blackflame Blackflame Ring Amethyst Ring
37,272 Blood Price Blood Price Helmet Reaver Helmet
37,276 Bloodnotch Bloodnotch Jewel Crimson Jewel
37,279 Bloodsoaked Medallion Bloodsoaked Medallion Amulet Amber Amulet
37,280 Blunderbore Blunderbore Body Armour Astral Plate
37,287 Bound Fate Bound Fate Belt Cloth Belt
37,293 Breathstealer Breathstealer Gloves Hydrascale Gauntlets
37,311 Cadigan's Crown Cadigan's Crown Helmet Runic Crown
37,313 Calamitous Visions Calamitous Visions Jewel Small Cluster Jewel
37,315 Call of the Void Call of the Void Ring Sapphire Ring
37,319 Cane of Kulemak Cane of Kulemak Warstaff Serpentine Staff
37,327 Ceinture of Benevolence Ceinture of Benevolence Belt Cloth Belt
37,330 Chain of Endurance Chain of Endurance Belt Chain Belt
37,332 Chains of Emancipation Chains of Emancipation Belt Chain Belt
37,364 Coated Weapons Coated Weapons Jewel Viridian Jewel
37,367 Cold Iron Point Cold Iron Point Rune Dagger Ezomyte Dagger
37,383 Contract: Breaking the Unbreakable Contract: Breaking the Unbreakable Contract Preventative Contract
37,384 Contract: Death to Darnaw Contract: Death to Darnaw Contract Naval Contract
37,385 Contract: Heart of Glory Contract: Heart of Glory Contract Familial Contract
37,386 Contract: The Slaver King Contract: The Slaver King Contract Vigilante Contract
37,387 Contract: The Twins Contract: The Twins Contract Vengeful Contract
37,388 Controlled Energy Controlled Energy Jewel Cobalt Jewel
37,389 Cooperation Cooperation Item Piece Vaal Aspect
37,392 Corpsewalker Corpsewalker Boots Carnal Boots
37,394 Cortex Cortex Map Synthesised Map
37,400 Cowl of the Ceraunophile Cowl of the Ceraunophile Helmet Solaris Circlet
37,401 Cowl of the Cryophile Cowl of the Cryophile Helmet Silken Hood
37,402 Cowl of the Thermophile Cowl of the Thermophile Helmet Ezomyte Burgonet
37,413 Crest of Desire Crest of Desire Helmet Fluted Bascinet
37,417 Crown of the Inward Eye Crown of the Inward Eye Helmet Prophet Crown
37,424 Curio of Absorption Curio of Absorption Item Piece Primordial Fragment
37,425 Curio of Consumption Curio of Consumption Item Piece Primordial Fragment
37,426 Curio of Decay Curio of Decay Item Piece Primordial Fragment
37,427 Curio of Potential Curio of Potential Item Piece Primordial Fragment
37,428 Curiosity Curiosity Item Piece Vaal Aspect
37,441 Dark Thoughts Dark Thoughts Jewel Cobalt Jewel
37,468 Defiance of Destiny Defiance of Destiny Amulet Paua Amulet
37,472 Demigod's Authority Demigod's Authority One-Handed Sword Golden Blade
37,490 Dissolution of the Flesh Dissolution of the Flesh Jewel Crimson Jewel
37,493 Divine Inferno Divine Inferno Jewel Crimson Jewel
37,508 Doppelgänger Guise Doppelgänger Guise Body Armour Sadist Garb
37,519 Doryani's Prototype Doryani's Prototype Body Armour Saint's Hauberk
37,550 El'Abin's Visage El'Abin's Visage Helmet Fencer Helm
37,555 Elixir of the Unbroken Circle Elixir of the Unbroken Circle Utility Flask Iron Flask
37,560 Emperor's Vigilance Emperor's Vigilance Shield Steel Kite Shield
37,565 Endless Misery Endless Misery Jewel Cobalt Jewel
37,572 Escalation Escalation Sentinel Brimstone Stalker Sentinel
37,579 Eternal Damnation Eternal Damnation Amulet Agate Amulet
37,583 Expedition's End Expedition's End Body Armour Sentinel Jacket
37,591 Eye of Malice Eye of Malice Helmet Callous Mask
37,600 Faithguard Faithguard Helmet Runic Helm
37,609 Fated End Fated End Ring Paua Ring
37,628 Firesong Firesong Jewel Crimson Jewel
37,631 First Piece of Brutality First Piece of Brutality Item Piece Imperial Staff Piece
37,632 First Piece of Directions First Piece of Directions Item Piece Blunt Arrow Quiver Piece
37,633 First Piece of Focus First Piece of Focus Item Piece Archon Kite Shield Piece
37,634 First Piece of Storms First Piece of Storms Item Piece Callous Mask Piece
37,635 First Piece of the Arcane First Piece of the Arcane Item Piece Legion Sword Piece
37,636 First Piece of Time First Piece of Time Item Piece Cloth Belt Piece
37,646 Fleshcrafter Fleshcrafter Body Armour Necromancer Silks
37,649 Font of Thunder Font of Thunder Shield Mirrored Spiked Shield
37,653 Forbidden Shako Forbidden Shako Helmet Great Crown
37,657 Fortress Covenant Fortress Covenant Jewel Cobalt Jewel
37,658 Fourth Piece of Focus Fourth Piece of Focus Item Piece Archon Kite Shield Piece
37,677 Fury Valve Fury Valve Amulet Turquoise Amulet
37,682 Gamblesprint Gamblesprint Boots Hydrascale Boots
37,698 Glimpse of Chaos Glimpse of Chaos Helmet Vaal Mask
37,703 Goblinedge Goblinedge Dagger Ambusher
37,710 Grace of the Goddess Grace of the Goddess Wand Prophecy Wand
37,713 Grand Spectrum (Cobalt Jewel, minion crit multi) Grand Spectrum Jewel Cobalt Jewel
37,714 Grand Spectrum (Cobalt Jewel, power charge) Grand Spectrum Jewel Cobalt Jewel
37,718 Grand Spectrum (Viridian Jewel, ailment avoidance) Grand Spectrum Jewel Viridian Jewel
37,720 Grand Spectrum (Viridian Jewel, frenzy charge) Grand Spectrum Jewel Viridian Jewel
37,722 Gravebind Gravebind Gloves Hydrascale Gauntlets
37,723 Graven's Secret Graven's Secret Belt Cloth Belt
37,724 Great Old One's Tentacles Great Old One's Tentacles Gloves Eelskin Gloves

More...