User:Moxian/Sandbox: Difference between revisions
Jump to navigation
Jump to search
(Replaced content with "{| class="wikitable" style="text-align: center; width: 220px;" |+ Quality Increase by Rarity ! Item Rarity !! % Increase |- | {{c|normal|Normal}} || ? |- | {{c|magic|Magic}} || ? |- | {{c|rare|Rare}} || ? |- | {{c|unique|Unique}} || 1 |}") Tag: Replaced |
No edit summary |
||
| Line 1: | Line 1: | ||
{ | |||
| | {{#cargo_query:tables=items=ib,items=iu | ||
|join on=iu.base_item_id = ib.metadata_id | |||
| | |fields=GROUP_CONCAT(iu.name)=uname,COUNT(iu.name)=cnt,ib.name=bname | ||
| | |where=iu.rarity_id="unique" | ||
| | |group by=ib.metadata_id | ||
| | |format=table | ||
}} | |||
Revision as of 07:42, 9 June 2024
| uname | cnt | bname |
|---|---|---|
| Abberath's Horn | 1 | Goat's Horn |
| Abyssus,Cowl of the Thermophile,Replica Abyssus | 3 | Ezomyte Burgonet |
| Actum | 1 | Butcher Axe |
| Aegis Aurora | 1 | Champion Kite Shield |
| Ahn's Contempt,Malachai's Vision,Viridi's Veil,Memory Vault,Voll's Vision | 5 | Praetor Crown |
| Ahn's Heritage,Dawnbreaker | 2 | Colossal Tower Shield |
| Ahn's Might,Rigwald's Command,Razor of the Seventh Sun | 3 | Midnight Blade |
| Al Dhih | 1 | Timeworn Claw |
| Algor Mortis,The Embalmer,Fenumus' Weave,Soul Ascension | 4 | Carnal Mitts |
| Allure,Replica Allure,Essentia Sanguis | 3 | Vaal Claw |
| Alpha's Howl,Assailum,Replica Alpha's Howl | 3 | Sinner Tricorne |
| Amanamu's Gaze | 1 | Ghastly Eye Jewel |
| Ambition | 1 | Vaal Aspect |
| Ambu's Charge,Replica Ambu's Charge | 2 | Crusader Chainmail |
| Ancient Skull,Maw of Mischief | 2 | Bone Helmet |
| Apep's Rage | 1 | Omen Wand |
| Apep's Supremacy,Esh's Mirror,Esh's Visage,Apep's Slumber | 4 | Vaal Spirit Shield |
| Asenath's Chant,Wreath of Phrecia,Asenath's Mark | 3 | Iron Circlet |
| Asenath's Gentle Touch | 1 | Silk Gloves |
| Ashes of the Sun | 1 | Driftwood Club |
| Ashrend | 1 | Buckskin Tunic |
| Atziri's Disfavour,Hezmana's Bloodlust,Uul-Netol's Embrace,Uul-Netol's Kiss | 4 | Vaal Axe |
| Atziri's Mirror,Atziri's Reflection | 2 | Golden Buckler |
| Atziri's Promise,Progenesis | 2 | Amethyst Flask |
| Atziri's Rule,Pledge of Hands,The Grey Spire,Hegemony's Era | 4 | Judgement Staff |
| Atziri's Splendour,Atziri's Splendour,Atziri's Splendour,Atziri's Splendour,Atziri's Splendour,Atziri's Splendour,Atziri's Splendour,Atziri's Splendour,Atziri's Splendour,Shadowstitch | 10 | Sacrificial Garb |
| Augyre,Nebulis,Mon'tregul's Grasp,Replica Nebulis,Nebulis | 5 | Void Sceptre |
| Aukuna's Will,Shadows and Dust | 2 | Clasped Mitts |
| Aurseize,Tombfist,Tombfist | 3 | Steelscale Gauntlets |
| Aurumvorax | 1 | Basket Rapier |
| Auxium,The Burden of Truth | 2 | Crystal Belt |
| Axiom Perpetuum | 1 | Bronze Sceptre |
| Badge of the Brotherhood,Fury Valve,Maligaro's Cruelty,Warped Timepiece,Victario's Acuity,Ungil's Harmony,Replica Badge of the Brotherhood | 7 | Turquoise Amulet |
| Balefire | 1 | Opal Sceptre |
| Band of the Victor | 1 | Jet Ring |
| Beacon of Madness | 1 | Two-Toned Boots |
| Beacon of Madness | 1 | Two-Toned Boots |
| Beacon of Madness | 1 | Two-Toned Boots |
| Beauty | 1 | Vaal Aspect |
| Belly of the Beast | 1 | Full Wyrmscale |
| Berek's Pass,Precursor's Emblem,Rigwald's Crest | 3 | Two-Stone Ring |
| Bino's Kitchen Knife | 1 | Slaughter Knife |
| Bisco's Leash,Doryani's Invitation,Dyadian Dawn,Doryani's Invitation,Siegebreaker,Doryani's Invitation,Replica Siegebreaker,Mother's Embrace,Belt of the Deceiver,Kaom's Binding,String of Servitude,Mageblood,Doryani's Invitation,Survivor's Guilt,Meginord's Girdle | 15 | Heavy Belt |
| Bitterbind Point,Rathpith Globe | 2 | Titanium Spirit Shield |
| Black Zenith | 1 | Fingerless Silk Gloves |
| Blackheart,Circle of Guilt,The Warden's Brand,Venopuncture,Icefang Orbit,Circle of Guilt,Voidheart,Le Heup of All | 8 | Iron Ring |
| Blightwell | 1 | Clutching Talisman |
| Blood of the Karui | 1 | Sanctified Life Flask |
| Blood Price | 1 | Reaver Helmet |
| Bloodbond | 1 | Bone Armour |
| Bloodgrip | 1 | Marble Amulet |
| Bloodplay,Replica Bloodplay | 2 | Stiletto |
| Bottled Faith,The Sorrow of the Divine,Replica Sorrow of the Divine,The Overflowing Chalice | 4 | Sulphur Flask |
| Brain Rattler | 1 | Meatgrinder |
| Bramblejack,Wall of Brambles | 2 | Plate Vest |
| Breath of the Council | 1 | Carnal Sceptre |
| Brightbeak,Lavianga's Wisdom | 2 | War Hammer |
| Brinerot Whalers | 1 | Trapper Boots |
| Briskwrap | 1 | Sun Leather |
| Broadstroke | 1 | Heavy Quiver |
| Bronn's Lithe | 1 | Cutthroat's Garb |
| Brutus' Lead Sprinkler | 1 | Ritual Sceptre |
| Cadigan's Crown | 1 | Runic Crown |
| Callinellus Malleus | 1 | Auric Mace |
| Cameria's Avarice,Cameria's Maul,Mjölner | 3 | Gavel |
| Cane of Kulemak,Sire of Shards | 2 | Serpentine Staff |
| Ceaseless Feast | 1 | Spiked Gloves |
| Ceinture of Benevolence,Graven's Secret,The Flow Untethered,The Torrent's Reclamation,Soulthirst,Sunblast,Arn's Anguish,Olesya's Delight,Nevalius Inheritance,Perandus Blazon,The Druggery,Soul Tether,Bound Fate,Replica Soul Tether | 14 | Cloth Belt |
| Cerberus Limb | 1 | Blood Sceptre |
| Chains of Command,Incandescent Heart | 2 | Saintly Chainmail |
| Chalice of Horrors,Thirst for Horrors | 2 | War Buckler |
| Chin Sol,Darkscorn,Arborix | 3 | Assassin Bow |
| Chitus' Needle | 1 | Elegant Foil |
| Cinderswallow Urn,Kiara's Determination | 2 | Silver Flask |
| Circle of Fear,Pyre,Uzaza's Meadow,Tasalio's Sign,Dream Fragments,Precursor's Emblem,Uzaza's Mountain,Uzaza's Valley,Replica Tasalio's Sign,Call of the Void,Circle of Fear,Snakepit | 12 | Sapphire Ring |
| Clayshaper | 1 | Rock Breaker |
| Cloak of Flame | 1 | Scholar's Robe |
| Command of the Pit,Command of the Pit | 2 | Riveted Gloves |
| Contract: Breaking the Unbreakable | 1 | Preventative Contract |
| Contract: Death to Darnaw | 1 | Naval Contract |
| Contract: Heart of Glory | 1 | Familial Contract |
| Contract: The Slaver King | 1 | Vigilante Contract |
| Contract: The Twins | 1 | Vengeful Contract |
| Cooperation | 1 | Vaal Aspect |
| Coralito's Signature | 1 | Diamond Flask |
| Corona Solaris | 1 | Crystal Wand |
| Coruscating Elixir,Dying Sun | 2 | Ruby Flask |
| Cospri's Malice | 1 | Jewelled Foil |
| Cospri's Will | 1 | Assassin's Garb |
| Cowl of the Ceraunophile,Galesight,Thundersight,Flamesight,Wilma's Requital | 5 | Solaris Circlet |
| Cowl of the Cryophile,Starkonja's Head,Saqawal's Flock | 3 | Silken Hood |
| Cragfall | 1 | Serrated Arrow Quiver |
| Craghead | 1 | Serrated Arrow Quiver |
| Craiceann's Carapace,Greed's Embrace | 2 | Golden Plate |
| Crest of Desire | 1 | Fluted Bascinet |
| Crest of Perandus | 1 | Pine Buckler |
| Crystal Vault,Icetomb | 2 | Latticed Ringmail |
| Curio of Absorption | 1 | Primordial Fragment |
| Curio of Consumption | 1 | Primordial Fragment |
| Curio of Decay | 1 | Primordial Fragment |