User:Defenestration/SpreadsheetUniqueListPleaseNoNuke: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
(where clause)
(order by)
Line 3: Line 3:
|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
|where=items.rarity="Unique"
|where=items.rarity="Unique"
|order_by=items.name
|format=table
|format=table
}}
}}

Revision as of 17:51, 22 March 2023

rowId pageName name class base item drop areas
10,202 Impresence (Cold) Impresence Amulet Onyx Amulet
10,208 Impresence (Physical) Impresence Amulet Onyx Amulet
37,647 User:Balaar/sandbox/testcases/Wurm's Molt Wurm's Molt Belt Leather Belt
47,877 Impresence (Fire) Impresence Amulet Onyx Amulet
51,193 Hyrri's Ire Hyrri's Ire Body Armour Zodiac Leather
54,058 Inevitability Inevitability Jewel Cobalt Jewel
58,836 Indigon Indigon Helmet Hubris Circlet
64,350 Hyrri's Bite Hyrri's Bite Quiver Sharktooth Arrow Quiver
132,703 Abberath's Hooves Abberath's Hooves Boots Goathide Boots
132,704 Abberath's Horn Abberath's Horn Wand Goat's Horn
132,705 Abhorrent Interrogation Abhorrent Interrogation Gloves Ambush Mitts
132,709 Acton's Nightmare Acton's Nightmare Map Overgrown Shrine Map
132,710 Actum Actum One-Handed Axe Butcher Axe
132,711 Advancing Fortress Advancing Fortress Claw Gut Ripper
132,712 Aegis Aurora Aegis Aurora Shield Champion Kite Shield
132,714 Agnerod East Agnerod East Staff Imperial Staff
132,715 Agnerod North Agnerod North Staff Imperial Staff
132,716 Agnerod South Agnerod South Staff Imperial Staff
132,717 Agnerod West Agnerod West Staff Imperial Staff
132,719 Ahkeli's Meadow Ahkeli's Meadow Ring Ruby Ring
132,720 Ahkeli's Mountain Ahkeli's Mountain Ring Ruby Ring
132,721 Ahkeli's Valley Ahkeli's Valley Ring Ruby Ring
132,722 Ahn's Contempt Ahn's Contempt Helmet Praetor Crown
132,723 Ahn's Heritage Ahn's Heritage Shield Colossal Tower Shield
132,724 Ahn's Might Ahn's Might One-Handed Sword Midnight Blade
132,725 Ahuana's Bite Ahuana's Bite Quiver Sharktooth Arrow Quiver
132,726 Akoya's Gaze Akoya's Gaze Helmet Regicide Mask
132,727 Al Dhih Al Dhih Claw Timeworn Claw
132,728 Alberon's Warpath Alberon's Warpath Boots Soldier Boots
132,730 Allelopathy Allelopathy Gloves Satin Gloves
132,731 Allure Allure Claw Vaal Claw
132,732 Alpha's Howl Alpha's Howl Helmet Sinner Tricorne
132,734 Amanamu's Gaze Amanamu's Gaze Abyss Jewel Ghastly Eye Jewel
132,735 Ambition Ambition Item Piece Vaal Aspect
132,736 Ambu's Charge Ambu's Charge Body Armour Crusader Chainmail
132,743 Anathema Anathema Ring Moonstone Ring
132,744 Anatomical Knowledge Anatomical Knowledge Jewel Cobalt Jewel
132,751 Ancient Skull Ancient Skull Helmet Bone Helmet
132,752 Ancient Waystones Ancient Waystones Jewel Crimson Jewel
132,754 Angler's Plait Angler's Plait Ring Unset Ring
132,758 Annihilation's Approach Annihilation's Approach Boots Dragonscale Boots
132,759 Apep's Rage Apep's Rage Wand Omen Wand
132,760 Apep's Slumber Apep's Slumber Shield Vaal Spirit Shield
132,762 Apex Mode Apex Mode Jewel Cobalt Jewel
132,763 Apparitions (jewel) Apparitions Jewel Viridian Jewel
132,764 Arakaali's Fang Arakaali's Fang Rune Dagger Fiend Dagger
132,765 Araku Tiki Araku Tiki Amulet Coral Amulet
132,766 Arborix Arborix Bow Assassin Bow
132,769 Architect's Hand Architect's Hand Gloves Ambush Mitts
132,772 Arn's Anguish Arn's Anguish Belt Cloth Belt
132,773 Ascent From Flesh Ascent From Flesh Belt Chain Belt
132,774 Asenath's Chant Asenath's Chant Helmet Iron Circlet
132,776 Asenath's Mark Asenath's Mark Helmet Iron Circlet
132,777 Ashcaller Ashcaller Wand Carved Wand
132,778 Ashes of the Stars Ashes of the Stars Amulet Onyx Amulet
132,779 Ashes of the Sun Ashes of the Sun One-Handed Mace Driftwood Club
132,780 Ashrend Ashrend Body Armour Buckskin Tunic
132,781 Asphyxia's Wrath Asphyxia's Wrath Quiver Feathered Arrow Quiver
132,782 Assailum Assailum Helmet Sinner Tricorne
132,783 Assassin's Haste Assassin's Haste Jewel Cobalt Jewel
132,784 Astral Projector Astral Projector Ring Topaz Ring
132,785 Astramentis Astramentis Amulet Onyx Amulet
132,786 Atop the Atlas Atop the Atlas Watchstone Platinum Valdo's Rest Watchstone
132,787 Atziri's Acuity Atziri's Acuity Gloves Vaal Gauntlets
132,788 Atziri's Disfavour Atziri's Disfavour Two-Handed Axe Vaal Axe
132,789 Atziri's Foible Atziri's Foible Amulet Paua Amulet
132,790 Atziri's Mirror Atziri's Mirror Shield Golden Buckler
132,791 Atziri's Promise Atziri's Promise Utility Flask Amethyst Flask
132,792 Atziri's Reflection Atziri's Reflection Shield Golden Buckler
132,793 Atziri's Reign Atziri's Reign Jewel Crimson Jewel
132,795 Atziri's Splendour (Armour and Energy Shield) Atziri's Splendour Body Armour Sacrificial Garb
132,796 Atziri's Splendour (Armour and Life) Atziri's Splendour Body Armour Sacrificial Garb
132,797 Atziri's Splendour (Armour, Energy Shield and Life) Atziri's Splendour Body Armour Sacrificial Garb
132,798 Atziri's Splendour (Armour, Evasion and Energy Shield) Atziri's Splendour Body Armour Sacrificial Garb
132,799 Atziri's Splendour (Armour, Evasion and Life) Atziri's Splendour Body Armour Sacrificial Garb
132,800 Atziri's Splendour (Energy Shield) Atziri's Splendour Body Armour Sacrificial Garb
132,801 Atziri's Splendour (Evasion and Energy Shield) Atziri's Splendour Body Armour Sacrificial Garb
132,802 Atziri's Splendour (Evasion and Life) Atziri's Splendour Body Armour Sacrificial Garb
132,803 Atziri's Splendour (Evasion, Energy Shield and Life) Atziri's Splendour Body Armour Sacrificial Garb
132,804 Atziri's Step Atziri's Step Boots Slink Boots
132,807 Aukuna's Will Aukuna's Will Gloves Clasped Mitts
132,808 Aul's Uprising (All Attributes) Aul's Uprising Amulet Onyx Amulet
132,810 Aul's Uprising (Intelligence) Aul's Uprising Amulet Onyx Amulet
132,811 Aul's Uprising (Strength) Aul's Uprising Amulet Onyx Amulet
132,812 Aurseize Aurseize Gloves Steelscale Gauntlets
132,813 Aurumvorax Aurumvorax Thrusting One-Handed Sword Basket Rapier
132,815 Axiom Perpetuum Axiom Perpetuum Sceptre Bronze Sceptre
132,816 Badge of the Brotherhood Badge of the Brotherhood Amulet Turquoise Amulet
132,817 Balefire Balefire Sceptre Opal Sceptre
132,820 Band of the Victor Band of the Victor Ring Jet Ring
132,824 Bated Breath Bated Breath Belt Chain Belt
132,826 Beacon of Madness (Cold and Lightning Resistance) Beacon of Madness Boots Two-Toned Boots
132,827 Beacon of Madness (Fire and Cold Resistance) Beacon of Madness Boots Two-Toned Boots
132,828 Beacon of Madness (Fire and Lightning Resistance) Beacon of Madness Boots Two-Toned Boots
132,830 Bear's Girdle Bear's Girdle Belt Leather Belt
132,831 Beauty Beauty Item Piece Vaal Aspect
132,832 Belly of the Beast Belly of the Beast Body Armour Full Wyrmscale
132,833 Belt of the Deceiver Belt of the Deceiver Belt Heavy Belt
132,834 Beltimber Blade Beltimber Blade One-Handed Sword Eternal Sword
132,835 Berek's Grip Berek's Grip Ring Two-Stone Ring

More...