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,099 Abberath's Hooves Abberath's Hooves Boots Goathide Boots
37,100 Abberath's Horn Abberath's Horn Wand Goat's Horn
37,101 Abhorrent Interrogation Abhorrent Interrogation Gloves Ambush Mitts
37,104 Abyssus Abyssus Helmet Ezomyte Burgonet
37,105 Acton's Nightmare Acton's Nightmare Map Overgrown Shrine Map
37,106 Actum Actum One-Handed Axe Butcher Axe
37,107 Advancing Fortress Advancing Fortress Claw Gut Ripper
37,108 Aegis Aurora Aegis Aurora Shield Champion Kite Shield
37,110 Agnerod East Agnerod East Staff Imperial Staff
37,111 Agnerod North Agnerod North Staff Imperial Staff
37,112 Agnerod South Agnerod South Staff Imperial Staff
37,113 Agnerod West Agnerod West Staff Imperial Staff
37,115 Ahkeli's Meadow Ahkeli's Meadow Ring Ruby Ring
37,116 Ahkeli's Mountain Ahkeli's Mountain Ring Ruby Ring
37,117 Ahkeli's Valley Ahkeli's Valley Ring Ruby Ring
37,118 Ahn's Contempt Ahn's Contempt Helmet Praetor Crown
37,119 Ahn's Heritage Ahn's Heritage Shield Colossal Tower Shield
37,120 Ahn's Might Ahn's Might One-Handed Sword Midnight Blade
37,121 Ahuana's Bite Ahuana's Bite Quiver Sharktooth Arrow Quiver
37,122 Akoya's Gaze Akoya's Gaze Helmet Regicide Mask
37,123 Al Dhih Al Dhih Claw Timeworn Claw
37,124 Alberon's Warpath Alberon's Warpath Boots Soldier Boots
37,125 Algor Mortis Algor Mortis Gloves Carnal Mitts
37,126 Allelopathy Allelopathy Gloves Satin Gloves
37,127 Allure Allure Claw Vaal Claw
37,128 Alpha's Howl Alpha's Howl Helmet Sinner Tricorne
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,132 Ambu's Charge Ambu's Charge Body Armour Crusader Chainmail
37,133 Amplification Rod Amplification Rod Wand Spiraled Wand
37,139 Anathema Anathema Ring Moonstone Ring
37,140 Anatomical Knowledge Anatomical Knowledge Jewel Cobalt Jewel
37,141 Ancestral Vision Ancestral Vision Jewel Viridian Jewel
37,147 Ancient Skull Ancient Skull Helmet Bone Helmet
37,148 Ancient Waystones Ancient Waystones Jewel Crimson Jewel
37,149 Andvarius Andvarius Ring Gold Ring
37,150 Angler's Plait Angler's Plait Ring Unset Ring
37,154 Annihilation's Approach Annihilation's Approach Boots Dragonscale Boots
37,155 Apep's Rage Apep's Rage Wand Omen Wand
37,156 Apep's Slumber Apep's Slumber Shield Vaal Spirit Shield
37,157 Apep's Supremacy Apep's Supremacy Shield Vaal Spirit Shield
37,158 Apex Mode Apex Mode Jewel Cobalt Jewel
37,159 Apparitions (jewel) Apparitions Jewel Viridian Jewel
37,160 Arakaali's Fang Arakaali's Fang Rune Dagger Fiend Dagger
37,161 Araku Tiki Araku Tiki Amulet Coral Amulet
37,162 Arborix Arborix Bow Assassin Bow
37,165 Architect's Hand Architect's Hand Gloves Ambush Mitts
37,168 Arn's Anguish Arn's Anguish Belt Cloth Belt
37,171 Ascent From Flesh Ascent From Flesh Belt Chain Belt
37,172 Asenath's Chant Asenath's Chant Helmet Iron Circlet
37,173 Asenath's Gentle Touch Asenath's Gentle Touch Gloves Silk Gloves
37,174 Asenath's Mark Asenath's Mark Helmet Iron Circlet
37,175 Ashcaller Ashcaller Wand Carved Wand
37,176 Ashes of the Stars Ashes of the Stars Amulet Onyx Amulet
37,177 Ashes of the Sun Ashes of the Sun One-Handed Mace Driftwood Club
37,178 Ashrend Ashrend Body Armour Buckskin Tunic
37,179 Asphyxia's Wrath Asphyxia's Wrath Quiver Feathered Arrow Quiver
37,180 Assailum Assailum Helmet Sinner Tricorne
37,181 Assassin's Haste Assassin's Haste Jewel Cobalt Jewel
37,182 Astral Projector Astral Projector Ring Topaz Ring
37,183 Astramentis Astramentis Amulet Onyx Amulet
37,184 Atop the Atlas Atop the Atlas Watchstone Platinum Valdo's Rest Watchstone
37,185 Atziri's Acuity Atziri's Acuity Gloves Vaal Gauntlets
37,186 Atziri's Disfavour Atziri's Disfavour Two-Handed Axe Vaal Axe
37,187 Atziri's Foible Atziri's Foible Amulet Paua Amulet
37,188 Atziri's Mirror Atziri's Mirror Shield Golden Buckler
37,189 Atziri's Promise Atziri's Promise Utility Flask Amethyst Flask
37,190 Atziri's Reflection Atziri's Reflection Shield Golden Buckler
37,191 Atziri's Reign Atziri's Reign Jewel Crimson Jewel
37,192 Atziri's Rule Atziri's Rule Warstaff Judgement Staff
37,193 Atziri's Splendour (Armour and Energy Shield) Atziri's Splendour Body Armour Sacrificial Garb
37,194 Atziri's Splendour (Armour and Life) Atziri's Splendour Body Armour Sacrificial Garb
37,195 Atziri's Splendour (Armour, Energy Shield and Life) Atziri's Splendour Body Armour Sacrificial Garb
37,196 Atziri's Splendour (Armour, Evasion and Energy Shield) Atziri's Splendour Body Armour Sacrificial Garb
37,197 Atziri's Splendour (Armour, Evasion and Life) Atziri's Splendour Body Armour Sacrificial Garb
37,198 Atziri's Splendour (Energy Shield) Atziri's Splendour Body Armour Sacrificial Garb
37,199 Atziri's Splendour (Evasion and Energy Shield) Atziri's Splendour Body Armour Sacrificial Garb
37,200 Atziri's Splendour (Evasion and Life) Atziri's Splendour Body Armour Sacrificial Garb
37,201 Atziri's Splendour (Evasion, Energy Shield and Life) Atziri's Splendour Body Armour Sacrificial Garb
37,202 Atziri's Step Atziri's Step Boots Slink Boots
37,203 Augmented Distant Memory Augmented Distant Memory Map Synthesised Map MavenHub
37,204 Augyre Augyre Sceptre Void Sceptre
37,205 Aukuna's Will Aukuna's Will Gloves Clasped Mitts
37,206 Aul's Uprising (All Attributes) Aul's Uprising Amulet Onyx Amulet
37,207 Aul's Uprising (Dexterity) Aul's Uprising Amulet Onyx Amulet
37,208 Aul's Uprising (Intelligence) Aul's Uprising Amulet Onyx Amulet
37,209 Aul's Uprising (Strength) Aul's Uprising Amulet Onyx Amulet
37,210 Aurseize Aurseize Gloves Steelscale Gauntlets
37,211 Aurumvorax Aurumvorax Thrusting One-Handed Sword Basket Rapier
37,212 Auxium Auxium Belt Crystal Belt
37,213 Axiom Perpetuum Axiom Perpetuum Sceptre Bronze Sceptre
37,214 Badge of the Brotherhood Badge of the Brotherhood Amulet Turquoise Amulet
37,215 Balefire Balefire Sceptre Opal Sceptre
37,218 Band of the Victor Band of the Victor Ring Jet Ring
37,221 Bated Breath Bated Breath Belt Chain Belt
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

More...

Retrieved from "https://www.poewiki.net/index.php?title=User:Defenestration/SpreadsheetUniqueListPleaseNoNuke&oldid=1344620"