User:Defenestration/SpreadsheetUniqueListPleaseNoNuke: Difference between revisions
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 |
---|---|---|---|---|---|
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,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,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,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,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,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 | |
132,836 | Berek's Pass | Berek's Pass | Ring | Two-Stone Ring | |
132,837 | Berek's Respite | Berek's Respite | Ring | Two-Stone Ring | |
132,843 | Bisco's Collar | Bisco's Collar | Amulet | Gold Amulet | |
132,844 | Bisco's Leash | Bisco's Leash | Belt | Heavy Belt | |
132,845 | Bitterbind Point | Bitterbind Point | Shield | Titanium Spirit Shield | |
132,846 | Bitterdream | Bitterdream | Sceptre | Shadow Sceptre |