User:Moxian/Sandbox: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
|join on=iu.base_item_id = ib.metadata_id | |join on=iu.base_item_id = ib.metadata_id | ||
|fields=GROUP_CONCAT(iu.name)=uname,COUNT(iu.name)=cnt,ib.name=bname | |fields=GROUP_CONCAT(iu.name)=uname,COUNT(iu.name)=cnt,ib.name=bname | ||
|where=iu.rarity_id="unique" | |where=iu.rarity_id="unique" AND NOT iu.is_replica | ||
|group by=ib.metadata_id | |group by=ib.metadata_id | ||
|format=table | |format=table | ||
}} | }} | ||
Revision as of 07:44, 9 June 2024
| uname | cnt | bname |
|---|---|---|
| Abberath's Horn | 1 | Goat's Horn |
| Abyssus,Cowl of the Thermophile | 2 | Ezomyte Burgonet |
| Actum | 1 | Butcher Axe |
| Advancing Fortress,Ornament of the East | 2 | Gut Ripper |
| Aegis Aurora | 1 | Champion Kite Shield |
| Agnerod West,Agnerod East,The Enmity Divine,Agnerod North,The Yielding Mortality,Agnerod South | 6 | Imperial Staff |
| Ahkeli's Meadow,Circle of Anguish,Precursor's Emblem,Ahkeli's Mountain,Circle of Anguish,Emberwake,Mokou's Embrace,Ahkeli's Valley,Ngamahu's Sign,Warrior's Legacy | 10 | Ruby Ring |
| Ahn's Heritage,Dawnbreaker | 2 | Colossal Tower Shield |
| Ahuana's Bite,Hyrri's Bite,Hyrri's Demise | 3 | Sharktooth Arrow Quiver |
| Akoya's Gaze,Crown of the Pale King,Gorgon's Gaze | 3 | Regicide Mask |
| Al Dhih | 1 | Timeworn Claw |
| Alberon's Warpath | 1 | Soldier Boots |
| Amanamu's Gaze | 1 | Ghastly Eye Jewel |
| Ambition | 1 | Vaal Aspect |
| Ambu's Charge | 1 | Crusader Chainmail |
| Amplification Rod,Storm Prison,Reverberation Rod | 3 | Spiraled Wand |
| Ancient Skull,Maw of Mischief | 2 | Bone Helmet |
| Annihilation's Approach,Darkray Vectors | 2 | Dragonscale Boots |
| Apep's Rage | 1 | Omen Wand |
| Arakaali's Fang,The Consuming Dark | 2 | Fiend Dagger |
| Asenath's Chant,Asenath's Mark,Wreath of Phrecia | 3 | Iron Circlet |
| Asenath's Gentle Touch | 1 | Silk Gloves |
| Ashcaller,The Poet's Pen | 2 | Carved Wand |
| Ashes of the Sun | 1 | Driftwood Club |
| Ashrend | 1 | Buckskin Tunic |
| Asphyxia's Wrath,Saemus' Gift | 2 | Feathered Arrow Quiver |
| Assailum,Alpha's Howl | 2 | Sinner Tricorne |
| Astral Projector,Nimis,Precursor's Emblem,Kikazaru,Putembo's Meadow,Putembo's Mountain,Valako's Sign,Putembo's Valley,Circle of Regret,Storm Secret,Circle of Regret | 11 | Topaz Ring |
| Atziri's Mirror,Atziri's Reflection | 2 | Golden Buckler |
| Atziri's Promise,Progenesis | 2 | Amethyst Flask |
| Atziri's Splendour,Atziri's Splendour,Atziri's Splendour,Atziri's Splendour,Shadowstitch,Atziri's Splendour,Atziri's Splendour,Atziri's Splendour,Atziri's Splendour,Atziri's Splendour | 10 | Sacrificial Garb |
| Aurumvorax | 1 | Basket Rapier |
| Axiom Perpetuum | 1 | Bronze Sceptre |
| Balefire | 1 | Opal Sceptre |
| Band of the Victor | 1 | Jet Ring |
| Bated Breath,Chain of Endurance,Chains of Emancipation,Coward's Chains,Coward's Legacy,Maligaro's Restraint,Ascent From Flesh | 7 | Chain Belt |
| 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,Rigwald's Crest,Precursor's Emblem | 3 | Two-Stone Ring |
| Bino's Kitchen Knife | 1 | Slaughter Knife |
| Bitterbind Point,Rathpith Globe | 2 | Titanium Spirit Shield |
| Bitterdream,The Dark Seer,The Dark Seer,The Dark Seer | 4 | Shadow Sceptre |
| Black Sun Crest,The Fledgling | 2 | Lacquered Helmet |
| Black Zenith | 1 | Fingerless Silk Gloves |
| Blightwell | 1 | Clutching Talisman |
| Blood of Corruption,Bloodsoaked Medallion,Xoph's Blood,Xoph's Heart,The Anvil | 5 | Amber Amulet |
| Blood of Summer,Dreadbeak,Redbeak | 3 | Rusted Sword |
| Blood of the Karui | 1 | Sanctified Life Flask |
| Blood Price | 1 | Reaver Helmet |
| Bloodbond | 1 | Bone Armour |
| Bloodgrip | 1 | Marble Amulet |
| Bloodplay | 1 | Stiletto |
| Bloodseeker,Law of the Wilds | 2 | Hellion's Paw |
| Blunderbore,Death's Oath | 2 | Astral Plate |
| Bones of Ullr | 1 | Silk Slippers |
| Brain Rattler | 1 | Meatgrinder |
| Bramblejack,Wall of Brambles | 2 | Plate Vest |
| Breath of the Council | 1 | Carnal Sceptre |
| Brinerot Flag,Matua Tupuna,Whakatutuki o Matua | 3 | Tarnished Spirit Shield |
| 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 |
| Bubonic Trail,Bubonic Trail,Voidwalker | 3 | Murder Boots |
| Cadigan's Crown | 1 | Runic Crown |
| Call of the Brotherhood,Precursor's Emblem,Berek's Grip | 3 | Two-Stone Ring |
| Callinellus Malleus | 1 | Auric Mace |
| Cameria's Maul,Mjölner,Cameria's Avarice | 3 | Gavel |
| Cane of Unravelling,The Fulcrum,Soulwrest | 3 | Ezomyte Staff |
| Ceaseless Feast | 1 | Spiked Gloves |
| Cerberus Limb | 1 | Blood Sceptre |
| Chaber Cairn,Chober Chaber,Trypanon | 3 | Great Mallet |
| Chains of Command,Incandescent Heart | 2 | Saintly Chainmail |
| Chernobog's Pillar,Tukohama's Fortress | 2 | Ebony Tower Shield |
| Cherrubim's Maleficence,Farrul's Fur | 2 | Triumphant Lamellar |
| Chitus' Needle | 1 | Elegant Foil |
| Cinderswallow Urn,Kiara's Determination | 2 | Silver Flask |
| Circle of Ambition,Lori's Lantern,Precursor's Emblem,Thief's Torment,The Taming | 5 | Prismatic Ring |
| Circle of Guilt,Venopuncture,Circle of Guilt,Voidheart,Icefang Orbit,Le Heup of All,The Warden's Brand,Blackheart | 8 | Iron Ring |
| Circle of Nostalgia,Circle of Nostalgia,Original Sin,Blackflame,Death Rush,Ming's Heart | 6 | Amethyst Ring |
| Clayshaper | 1 | Rock Breaker |
| Cloak of Defiance,Victario's Influence | 2 | Lacquered Garb |
| Cloak of Flame | 1 | Scholar's Robe |
| Cold Iron Point | 1 | Ezomyte Dagger |
| 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 |
| Cospri's Malice | 1 | Jewelled Foil |
| Cospri's Will | 1 | Assassin's Garb |
| Cragfall | 1 | Serrated Arrow Quiver |