User:Moxian/Sandbox: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{|class="wikitable" | |||
{{#cargo_query:tables=items=ib,items=iu | {{#cargo_query:tables=items=ib,items=iu | ||
|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)= | |fields=GROUP_CONCAT(iu.name)=uname,COUNT(iu.name)=count,ib.name=bname | ||
|where=iu.rarity_id="unique" | |where=iu.rarity_id="unique" AND NOT iu.is_replica AND NOT iu.is_drop_restricted AND iu.drop_enabled | ||
|group by=ib.metadata_id | |group by=ib.metadata_id | ||
|format= | |format=template | ||
|template=:User:Moxian/Sandbox/trow | |||
|named args=yes | |||
|delimiter=\n | |||
|limit=500 | |||
}} | }} | ||
|} | |||
Latest revision as of 07:48, 9 June 2024
| Goathide Boots | 2 | Abberath's Hooves,Victario's Flight
|
| Gut Ripper | 2 | Advancing Fortress,Ornament of the East
|
| Sharktooth Arrow Quiver | 2 | Ahuana's Bite,Hyrri's Bite |
| Regicide Mask | 2 | Akoya's Gaze,Crown of the Pale King
|
| Carnal Mitts | 2 | Algor Mortis,The Embalmer |
| Satin Gloves | 2 | Allelopathy,Demon Stitcher |
| Sinner Tricorne | 2 | Alpha's Howl,Assailum
|
| Iron Circlet | 2 | Asenath's Mark,Wreath of Phrecia |
| Carved Wand | 2 | Ashcaller,The Poet's Pen |
| Void Sceptre | 2 | Augyre,Mon'tregul's Grasp
|
| Two-Stone Ring | 2 | Berek's Grip,Call of the Brotherhood
|
| Gavel | 2 | Cameria's Maul,Mjölner |
| Ezomyte Staff | 2 | Cane of Unravelling,Soulwrest
|
| Ebony Tower Shield | 2 | Chernobog's Pillar,Tukohama's Fortress
|
| Great Mallet | 2 | Chober Chaber,Trypanon |
| Lacquered Garb | 2 | Cloak of Defiance,Victario's Influence
|
| Assassin Bow | 2 | Darkscorn,Chin Sol |
| Death Bow | 2 | Death's Harp,Iron Commander |
| Astral Plate | 2 | Death's Oath,Blunderbore
|
| Sage's Robe | 2 | Dialla's Malefaction,Zahndethus' Cassock |
| Imperial Skean | 2 | Divinarius,White Wind
|
| Widowsilk Robe | 2 | Doedre's Skin,Infernal Mantle
|
| Saint's Hauberk | 2 | Doryani's Prototype,The Ivory Tower
|
| Vaal Claw | 2 | Essentia Sanguis,Allure
|
| Primordial Staff | 2 | Femurs of the Saints,The Burden of Shadows
|
| Necromancer Silks | 2 | Fleshcrafter,Vis Mortis
|
| Stealth Boots | 2 | Garukhan's Flight,Sin Trek
|
| Reaver Sword | 2 | Hiltless,The Dancing Dervish
|
| Saintly Chainmail | 2 | Incandescent Heart,Chains of Command
|
| War Hammer | 2 | Lavianga's Wisdom,Brightbeak
|
| Granite Flask | 2 | Lion's Roar,Rumi's Concoction |
| Imperial Bow | 2 | Lioneye's Glare,Windripper
|
| Prismatic Ring | 2 | Lori's Lantern,Thief's Torment |
| Karui Sceptre | 2 | Maata's Teaching,Death's Hand
|
| Legion Boots | 2 | March of the Legion,Gang's Momentum
|
| Engraved Wand | 2 | Midnight Bargain,Eclipse Solaris
|
| Amethyst Ring | 2 | Ming's Heart,Death Rush
|
| Glorious Plate | 2 | Perfidy,Kaom's Heart
|
| Vaal Blade | 2 | Rebuke of the Vaal,Varunastra
|
| Spiraled Wand | 2 | Reverberation Rod,Storm Prison |
| Two-Stone Ring | 2 | Rigwald's Crest,Berek's Pass |
| Two-Point Arrow Quiver | 2 | Rigwald's Quills,Skirmish
|
| Diamond Ring | 2 | Romira's Banquet,Gifts from Above
|
| Studded Belt | 2 | Ryslatha's Coil,The Magnate |
| Feathered Arrow Quiver | 2 | Saemus' Gift,Asphyxia's Wrath
|
| Mind Cage | 2 | Scold's Bridle,Rime Gaze
|
| Clasped Mitts | 2 | Shadows and Dust,Aukuna's Will
|
| Harbinger Bow | 2 | Slivertongue,Nuro's Harp
|
| Assassin's Mitts | 2 | Storm's Gift,Snakebite
|
| Ambusher | 2 | Taproot,Goblinedge
|
| Amber Amulet | 2 | The Anvil,Bloodsoaked Medallion
|
| Gnarled Branch | 2 | The Blood Thorn,Fencoil
|
| Nightmare Bascinet | 2 | The Bringer of Rain,Devoto's Devotion |
| Fiend Dagger | 2 | The Consuming Dark,Arakaali's Fang |
| Spidersilk Robe | 2 | The Covenant,Soul Mantle
|
| Judgement Staff | 2 | The Grey Spire,Hegemony's Era
|
| Crusader Plate | 2 | The Iron Fortress,Lioneye's Vision |
| Elegant Round Shield | 2 | The Oppressor,The Squire
|
| Terror Claw | 2 | The Scourge,Rive
|
| Sulphur Flask | 2 | The Sorrow of the Divine,The Overflowing Chalice |
| Crystal Sceptre | 2 | The Supreme Truth,Nycta's Lantern
|
| Simple Robe | 2 | Thousand Ribbons,Tabula Rasa
|
| Murder Mitts | 2 | Thunderfist,Machina Mitts |
| Sadist Garb | 2 | Tinkerskin,Inpulsa's Broken Heart
|
| Sage Wand | 2 | Twyzel,Shade of Solaris
|
| Bronzescale Gauntlets | 2 | Vaal Caress,Slitherpinch |
| Titan Gauntlets | 2 | Veruso's Battering Rams,Kaom's Spirit
|
| Spine Bow | 2 | Voltaxic Rift,Reach of the Council
|
| Crude Bow | 2 | Widowhail,Silverbranch
|
| Golden Mask | 2 | Willclash,The Three Dragons |
| Ezomyte Axe | 2 | Wings of Entropy,Sinvicta's Mettle |
| Stibnite Flask | 2 | Witchfire Brew,Sin's Rebirth |
| Wyrmscale Gauntlets | 2 | Wyrmsign,Tanu Ahi
|