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 |
---|---|---|---|---|---|
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 |