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