User:Moxian/Sandbox: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(11 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
|
Satin Gloves | 2 | Allelopathy,Demon Stitcher
|
Feathered Arrow Quiver | 2 | Asphyxia's Wrath,Saemus' Gift |
Sinner Tricorne | 2 | Assailum,Alpha's Howl
|
Astral Plate | 2 | Blunderbore,Death's Oath
|
Two-Stone Ring | 2 | Call of the Brotherhood,Berek's Grip
|
Saintly Chainmail | 2 | Chains of Command,Incandescent Heart
|
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
|
Nightmare Bascinet | 2 | Devoto's Devotion,The Bringer of Rain |
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
|
Engraved Wand | 2 | Eclipse Solaris,Midnight Bargain
|
Vaal Claw | 2 | Essentia Sanguis,Allure
|
Primordial Staff | 2 | Femurs of the Saints,The Burden of Shadows
|
Necromancer Silks | 2 | Fleshcrafter,Vis Mortis
|
Legion Boots | 2 | Gang's Momentum,March of the Legion
|
Judgement Staff | 2 | Hegemony's Era,The Grey Spire
|
Reaver Sword | 2 | Hiltless,The Dancing Dervish
|
Sharktooth Arrow Quiver | 2 | Hyrri's Bite,Ahuana's Bite
|
Sadist Garb | 2 | Inpulsa's Broken Heart,Tinkerskin
|
Titan Gauntlets | 2 | Kaom's Spirit,Veruso's Battering Rams
|
War Hammer | 2 | Lavianga's Wisdom,Brightbeak
|
Imperial Bow | 2 | Lioneye's Glare,Windripper
|
Crusader Plate | 2 | Lioneye's Vision,The Iron Fortress |
Prismatic Ring | 2 | Lori's Lantern,Thief's Torment |
Karui Sceptre | 2 | Maata's Teaching,Death's Hand
|
Gavel | 2 | Mjölner,Cameria's Maul |
Void Sceptre | 2 | Mon'tregul's Grasp,Augyre
|
Harbinger Bow | 2 | Nuro's Harp,Slivertongue |
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 |
Two-Stone Ring | 2 | Rigwald's Crest,Berek's Pass
|
Terror Claw | 2 | Rive,The Scourge |
Diamond Ring | 2 | Romira's Banquet,Gifts from Above
|
Granite Flask | 2 | Rumi's Concoction,Lion's Roar |
Studded Belt | 2 | Ryslatha's Coil,The Magnate
|
Mind Cage | 2 | Scold's Bridle,Rime Gaze
|
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
|
Bronzescale Gauntlets | 2 | Slitherpinch,Vaal Caress |
Assassin's Mitts | 2 | Snakebite,Storm's Gift |
Spidersilk Robe | 2 | Soul Mantle,The Covenant
|
Ezomyte Staff | 2 | Soulwrest,Cane of Unravelling
|
Simple Robe | 2 | Tabula Rasa,Thousand Ribbons |
Ambusher | 2 | Taproot,Goblinedge
|
Amber Amulet | 2 | The Anvil,Bloodsoaked Medallion
|
Gnarled Branch | 2 | The Blood Thorn,Fencoil
|
Fiend Dagger | 2 | The Consuming Dark,Arakaali's Fang |
Carnal Mitts | 2 | The Embalmer,Algor Mortis
|
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
|
Murder Mitts | 2 | Thunderfist,Machina Mitts
|
Great Mallet | 2 | Trypanon,Chober Chaber |
Ebony Tower Shield | 2 | Tukohama's Fortress,Chernobog's Pillar |
Sage Wand | 2 | Twyzel,Shade of Solaris
|
Vaal Blade | 2 | Varunastra,Rebuke of the Vaal
|
Lacquered Garb | 2 | Victario's Influence,Cloak of Defiance
|
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 |
Iron Circlet | 2 | Wreath of Phrecia,Asenath's Mark |
Wyrmscale Gauntlets | 2 | Wyrmsign,Tanu Ahi
|