User:Defenestration/SpreadsheetUniqueListPleaseNoNuke: Difference between revisions
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 |
---|---|---|---|---|---|
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 | |
37,740 | Hand of the Fervent | Hand of the Fervent | Gloves | Zealot Gloves |