User:Findar

Test Page

testbed

Item	Base Item	Drop Level
Abberath's Hooves	Goathide Boots	N/A
Abberath's Horn	Goat's Horn	N/A
Abhorrent Interrogation	Ambush Mitts	N/A
Abyssus	Ezomyte Burgonet	N/A
Acton's Nightmare	Overgrown Shrine Map	N/A
Actum	Butcher Axe	N/A
Advancing Fortress	Gut Ripper	N/A
Aegis Aurora	Champion Kite Shield	73
Agnerod East	Imperial Staff	N/A
Agnerod North	Imperial Staff	N/A
Agnerod South	Imperial Staff	N/A
Agnerod West	Imperial Staff	N/A
Ahkeli's Meadow	Ruby Ring	N/A
Ahkeli's Mountain	Ruby Ring	N/A
Ahkeli's Valley	Ruby Ring	N/A
Ahn's Contempt	Praetor Crown	N/A
Ahn's Heritage	Colossal Tower Shield	N/A
Ahn's Might	Midnight Blade	N/A
Al Dhih	Timeworn Claw	N/A
Alberon's Warpath	Soldier Boots	N/A
Algor Mortis	Carnal Mitts	75
Allelopathy	Satin Gloves	N/A
Allure	Vaal Claw	N/A
Alpha's Howl	Sinner Tricorne	N/A
Altered Distant Memory	Synthesised Map	N/A
Amanamu's Gaze	Ghastly Eye Jewel	N/A
Ambu's Charge	Crusader Chainmail	N/A
Ancient Skull	Bone Helmet	N/A
Andvarius	Gold Ring	71
Angler's Plait	Unset Ring	N/A
Apep's Rage	Omen Wand	N/A
Apep's Slumber	Vaal Spirit Shield	N/A
Apep's Supremacy	Vaal Spirit Shield	N/A
Apex Mode	Cobalt Jewel	N/A
Arakaali's Fang	Fiend Dagger	N/A
Araku Tiki	Coral Amulet	N/A
Arborix	Assassin Bow	N/A
Architect's Hand	Ambush Mitts	N/A
Arn's Anguish	Cloth Belt	N/A
Ascent From Flesh	Chain Belt	N/A
Asenath's Gentle Touch	Silk Gloves	75
Asenath's Mark	Iron Circlet	N/A
Ashcaller	Carved Wand	N/A
Ashrend	Buckskin Tunic	N/A
Asphyxia's Wrath	Feathered Arrow Quiver	N/A
Assailum	Sinner Tricorne	80
Astral Projector	Topaz Ring	N/A
Astramentis	Onyx Amulet	N/A
Atziri's Acuity	Vaal Gauntlets	N/A
Atziri's Disfavour	Vaal Axe	N/A
Atziri's Foible	Paua Amulet	16
Atziri's Promise	Amethyst Flask	N/A
Atziri's Reflection	Golden Buckler	N/A
Atziri's Reign	Crimson Jewel	N/A
Atziri's Rule	Judgement Staff	N/A
Atziri's Splendour	Sacrificial Garb	N/A
Atziri's Splendour	Sacrificial Garb	N/A
Atziri's Splendour	Sacrificial Garb	N/A
Atziri's Splendour	Sacrificial Garb	N/A
Atziri's Splendour	Sacrificial Garb	N/A
Atziri's Splendour	Sacrificial Garb	N/A
Atziri's Splendour	Sacrificial Garb	N/A
Atziri's Splendour	Sacrificial Garb	N/A
Atziri's Splendour	Sacrificial Garb	N/A
Atziri's Step	Slink Boots	N/A
Augmented Distant Memory	Synthesised Map	N/A
Augyre	Void Sceptre	N/A
Aukuna's Will	Clasped Mitts	N/A
Aul's Uprising	Onyx Amulet	N/A
Aul's Uprising	Onyx Amulet	N/A
Aul's Uprising	Onyx Amulet	N/A
Aul's Uprising	Onyx Amulet	N/A
Aurseize	Steelscale Gauntlets	N/A
Aurumvorax	Basket Rapier	N/A
Auxium	Crystal Belt	73
Axiom Perpetuum	Bronze Sceptre	N/A
Badge of the Brotherhood	Turquoise Amulet	N/A
Balefire	Opal Sceptre	N/A
Bated Breath	Chain Belt	N/A
Beacon of Madness	Two-Toned Boots	N/A
Beacon of Madness	Two-Toned Boots	N/A
Beacon of Madness	Two-Toned Boots	N/A
Bear's Girdle	Leather Belt	N/A
Belly of the Beast	Full Wyrmscale	N/A
Belt of the Deceiver	Heavy Belt	N/A
Beltimber Blade	Eternal Sword	77
Berek's Grip	Two-Stone Ring	N/A
Berek's Pass	Two-Stone Ring	N/A
Berek's Respite	Two-Stone Ring	N/A
Bino's Kitchen Knife	Slaughter Knife	N/A
Bisco's Collar	Gold Amulet	N/A
Bisco's Leash	Heavy Belt	N/A
Bitterbind Point	Titanium Spirit Shield	N/A
Bitterdream	Shadow Sceptre	N/A
Black Sun Crest	Lacquered Helmet	N/A
Blackflame	Amethyst Ring	N/A
Blackgleam	Blazing Arrow Quiver	N/A
Blackheart	Iron Ring	N/A
Blasphemer's Grasp	Assassin's Mitts	N/A
Blightwell	Clutching Talisman	N/A
Blood of Corruption	Amber Amulet	N/A
Blood of the Karui	Sanctified Life Flask	N/A
Bloodbond	Bone Armour	N/A
Bloodgrip	Marble Amulet	N/A
Bloodplay	Stiletto	N/A
Bloodseeker	Hellion's Paw	N/A
Blunderbore	Astral Plate	N/A
Bones of Ullr	Silk Slippers	N/A
Bottled Faith	Sulphur Flask	N/A
Brain Rattler	Meatgrinder	77
Bramblejack	Plate Vest	N/A
Breath of the Council	Carnal Sceptre	N/A
Breathstealer	Hydrascale Gauntlets	N/A
Brightbeak	War Hammer	N/A
Brinerot Flag	Tarnished Spirit Shield	N/A
Brinerot Mark	Unset Ring	N/A
Brinerot Whalers	Trapper Boots	N/A
Briskwrap	Sun Leather	N/A
Broken Faith	Archon Kite Shield	N/A
Bronn's Lithe	Cutthroat's Garb	N/A
Brutal Restraint	Timeless Jewel	N/A
Brute Force Solution	Cobalt Jewel	N/A
Brutus' Lead Sprinkler	Ritual Sceptre	N/A
Bubonic Trail	Murder Boots	73
Bubonic Trail	Murder Boots	73
Caer Blaidd, Wolfpack's Den	Underground River Map	N/A
Calamitous Visions	Small Cluster Jewel	N/A
Call of the Brotherhood	Two-Stone Ring	N/A
Callinellus Malleus	Auric Mace	N/A
Cameria's Avarice	Gavel	N/A
Cameria's Maul	Gavel	N/A
Cane of Kulemak	Serpentine Staff	N/A
Cane of Unravelling	Ezomyte Staff	N/A
Carcass Jack	Varnished Coat	N/A
Careful Planning	Viridian Jewel	N/A
Carnage Heart	Onyx Amulet	N/A
Cerberus Limb	Blood Sceptre	N/A
Chains of Command	Saintly Chainmail	N/A
Chains of Emancipation	Chain Belt	N/A
Chalice of Horrors	War Buckler	N/A
Chernobog's Pillar	Ebony Tower Shield	N/A
Cherrubim's Maleficence	Triumphant Lamellar	N/A
Chill of Corruption	Viridian Jewel	N/A
Chin Sol	Assassin Bow	N/A
Chitus' Apex	Necromancer Circlet	N/A
Chober Chaber	Great Mallet	N/A
Choir of the Storm	Lapis Amulet	N/A
Cinderswallow Urn	Silver Flask	N/A
Circle of Anguish	Ruby Ring	N/A
Circle of Fear	Sapphire Ring	N/A
Circle of Guilt	Iron Ring	N/A
Circle of Nostalgia	Amethyst Ring	N/A
Circle of Regret	Topaz Ring	N/A
Clayshaper	Rock Breaker	N/A
Cloak of Defiance	Lacquered Garb	N/A
Cloak of Flame	Scholar's Robe	N/A
Cloak of Tawm'r Isley	Savant's Robe	N/A
Cold Iron Point	Ezomyte Dagger	N/A
Combat Focus	Cobalt Jewel	N/A
Combat Focus	Crimson Jewel	N/A
Combat Focus	Viridian Jewel	N/A
Command of the Pit	Riveted Gloves	N/A
Command of the Pit	Riveted Gloves	N/A
Contract: Breaking the Unbreakable	Preventative Contract	80
Contract: Death to Darnaw	Naval Contract	81
Contract: Heart of Glory	Familial Contract	81
Contract: The Slaver King	Vigilante Contract	80
Contract: The Twins	Vengeful Contract	81
Coralito's Signature	Diamond Flask	N/A
Corpsewalker	Carnal Boots	N/A
Cortex	Synthesised Map	N/A
Coruscating Elixir	Ruby Flask	N/A
Cospri's Malice	Jewelled Foil	N/A
Cospri's Will	Assassin's Garb	N/A
Coward's Chains	Chain Belt	N/A
Coward's Legacy	Chain Belt	N/A
Cowl of the Ceraunophile	Solaris Circlet	N/A
Cowl of the Cryophile	Silken Hood	N/A
Cowl of the Thermophile	Ezomyte Burgonet	N/A
Craghead	Serrated Arrow Quiver	N/A
Craiceann's Carapace	Golden Plate	N/A
Craiceann's Chitin	Magistrate Crown	N/A
Craiceann's Pincers	Titan Gauntlets	N/A
Craiceann's Tracks	Goliath Greaves	N/A
Crest of Desire	Fluted Bascinet	N/A
Crest of Perandus	Pine Buckler	N/A
Crown of Eyes	Hubris Circlet	N/A
Crown of Thorns	Vine Circlet	N/A
Crown of the Inward Eye	Prophet Crown	N/A
Crown of the Pale King	Regicide Mask	N/A
Crown of the Tyrant	Magistrate Crown	N/A
Curtain Call	Plague Mask	N/A
Cybil's Paw	Thresher Claw	N/A
Cyclopean Coil	Leather Belt	N/A
Dance of the Offered	Carnal Boots	N/A
Daresso's Courage	Baroque Round Shield	N/A
Daresso's Defiance	Full Dragonscale	N/A
Daresso's Passion	Estoc	N/A
Daresso's Salute	Citrine Amulet	N/A
Darkness Enthroned	Stygian Vise	73
Darkray Vectors	Dragonscale Boots	N/A
Darkscorn	Assassin Bow	N/A
Dead Reckoning	Cobalt Jewel	N/A
Death's Door	Crusader Boots	N/A
Death's Hand	Karui Sceptre	72
Death's Harp	Death Bow	N/A
Death's Oath	Astral Plate	N/A
Death Rush	Amethyst Ring	N/A
Death and Taxes	Necropolis Map	N/A
Debeon's Dirge	Despot Axe	N/A
Deerstalker	Deerskin Boots	N/A
Deidbell	Gilded Sallet	N/A
Demon Stitcher	Satin Gloves	N/A
Dendrobate	Sentinel Jacket	N/A
Devoto's Devotion	Nightmare Bascinet	74
Dialla's Malefaction	Sage's Robe	N/A
Disintegrator	Maelström Staff	N/A
Divinarius	Imperial Skean	N/A
Divination Distillate	Large Hybrid Flask	N/A
Doedre's Damning	Paua Ring	N/A
Doedre's Elixir	Greater Mana Flask	N/A
Doedre's Scorn	Lunaris Circlet	N/A
Doedre's Skin	Widowsilk Robe	N/A
Doedre's Tenure	Velvet Gloves	N/A
Doomfletch	Royal Bow	N/A
Doomsower	Lion Sword	N/A
Doon Cuebiyari	Vaal Sceptre	74
Doppelgänger Guise	Sadist Garb	N/A
Doryani's Catalyst	Vaal Sceptre	N/A
Doryani's Delusion	Titan Greaves	N/A
Doryani's Delusion	Sorcerer Boots	N/A
Doryani's Delusion	Slink Boots	N/A
Doryani's Fist	Vaal Gauntlets	70
Doryani's Invitation	Heavy Belt	N/A
Doryani's Invitation	Heavy Belt	N/A
Doryani's Invitation	Heavy Belt	N/A
Doryani's Invitation	Heavy Belt	N/A
Doryani's Machinarium	Maze Map	N/A
Doryani's Prototype	Saint's Hauberk	N/A
Dreadarc	Cleaver	N/A
Dream Fragments	Sapphire Ring	N/A
Dreamfeather	Eternal Sword	N/A
Drillneck	Penetrating Arrow Quiver	N/A
Duskdawn	Maelström Staff	N/A
Dusktoe	Ironscale Boots	N/A
Dyadian Dawn	Heavy Belt	N/A
Dyadus	Infernal Axe	N/A
Dying Breath	Iron Staff	N/A
Dying Sun	Ruby Flask	N/A
Earendel's Embrace	Grinning Fetish	N/A
Eber's Unification	Hubris Circlet	N/A
Eclipse Solaris	Engraved Wand	N/A
Edge of Madness	Etched Greatsword	N/A
Efficient Training	Crimson Jewel	N/A
Elegant Hubris	Timeless Jewel	N/A
Emberwake	Ruby Ring	N/A
Emperor's Cunning	Viridian Jewel	N/A
Emperor's Mastery	Prismatic Jewel	N/A
Emperor's Might	Crimson Jewel	N/A
Emperor's Vigilance	Steel Kite Shield	N/A
Emperor's Wit	Cobalt Jewel	N/A
Empire's Grasp	Goliath Gauntlets	N/A
Energised Armour	Crimson Jewel	N/A
Energy From Within	Cobalt Jewel	N/A
Ephemeral Edge	Dusk Blade	N/A
Esh's Mirror	Vaal Spirit Shield	N/A
Esh's Visage	Vaal Spirit Shield	N/A
Essence Worm	Unset Ring	N/A
Essentia Sanguis	Vaal Claw	N/A
Ewar's Mirage	Antique Rapier	N/A
Expedition's End	Sentinel Jacket	N/A
Extractor Mentis	Agate Amulet	N/A
Eye of Chayula	Onyx Amulet	N/A
Eye of Innocence	Citrine Amulet	77
Eye of Malice	Callous Mask	73
Eyes of the Greatwolf	Greatwolf Talisman	82
Ezomyte Peak	Iron Hat	N/A
Facebreaker	Strapped Mitts	N/A
Fairgraves' Tricorne	Tricorne	N/A
Faminebind	Rustic Sash	N/A
Farrul's Bite	Harlequin Mask	N/A
Farrul's Chase	Slink Boots	N/A
Farrul's Fur	Triumphant Lamellar	N/A
Farrul's Pounce	Hydrascale Gauntlets	N/A
Fate of the Vaal	Gemstone Sword	N/A
Fated End	Paua Ring	N/A
Feastbind	Rustic Sash	N/A
Femurs of the Saints	Primordial Staff	N/A
Fencoil	Gnarled Branch	N/A
Fenumus' Shroud	Widowsilk Robe	N/A
Fenumus' Spinnerets	Assassin's Boots	N/A
Fenumus' Toxins	Necromancer Circlet	N/A
Fenumus' Weave	Carnal Mitts	N/A
Fertile Mind	Cobalt Jewel	N/A
Fevered Mind	Cobalt Jewel	N/A
Fidelitas' Spike	Jagged Foil	N/A
First Piece of Brutality	Imperial Staff Piece	N/A
First Piece of Directions	Blunt Arrow Quiver Piece	N/A
First Piece of Focus	Archon Kite Shield Piece	N/A
First Piece of Storms	Callous Mask Piece	N/A
First Piece of Time	Cloth Belt Piece	N/A
First Piece of the Arcane	Legion Sword Piece	N/A
Flamesight	Solaris Circlet	74
Flesh and Spirit	Ironscale Gauntlets	N/A
Elixir of the Unbroken Circle	Iron Flask	N/A
Cadigan's Crown	Runic Crown	N/A
Faithguard	Runic Helm	N/A
Crystallised Omniscience	Onyx Amulet	N/A
Ceaseless Feast	Spiked Gloves	N/A
Ashes of the Stars	Onyx Amulet	N/A
Dissolution of the Flesh	Crimson Jewel	N/A
Black Zenith	Fingerless Silk Gloves	N/A
Dawnbreaker	Colossal Tower Shield	N/A
Call of the Void	Sapphire Ring	N/A
Echoes of Creation	Royal Burgonet	N/A
Elevore	Wolf Pelt	N/A
Beauty	Vaal Aspect	82
Curiosity	Vaal Aspect	82
Cooperation	Vaal Aspect	N/A
Ambition	Vaal Aspect	82
Anathema	Moonstone Ring	N/A
Entropic Devastation	Assassin's Mitts	N/A
Eternal Damnation	Agate Amulet	N/A
Firesong	Crimson Jewel	N/A
Dawnstrider	Vaal Greaves	N/A
Annihilation's Approach	Dragonscale Boots	N/A
Echoforge	Infernal Sword	N/A
Doedre's Tongue	Lapis Amulet	N/A
Ancestral Vision	Viridian Jewel	N/A
Blood Price	Reaver Helmet	N/A
Bloodnotch	Crimson Jewel	N/A
Bloodsoaked Medallion	Amber Amulet	N/A
Ceinture of Benevolence	Cloth Belt	N/A
Chain of Endurance	Chain Belt	N/A
Bound Fate	Cloth Belt	N/A
Ahuana's Bite	Sharktooth Arrow Quiver	N/A
Akoya's Gaze	Regicide Mask	N/A
Defiance of Destiny	Paua Amulet	N/A
Circle of Ambition	Prismatic Ring	N/A
Curio of Decay	Primordial Fragment	85
Curio of Potential	Primordial Fragment	85
Curio of Absorption	Primordial Fragment	85
Curio of Consumption	Primordial Fragment	85

old stuff

{{#cargo_query:
  tables=items
  |where = items.rarity_id="unique"  AND items.drop_enabled!="False"
  |group by=items.base_item
  |format=table
  |fields=items.name,items.base_item, items.drop_level
  | no html
  |limit=25
  }}

{{Query unique items
|tables=items
|where=items.rarity_id="unique"  AND items.drop_enabled!="False"
|q_limit=800
|no_html
| no html
}}

{{Item table
|q_tables=item_stats
|q_join=items._pageID=item_stats._pageID
|q_where=items.rarity_id="unique"
|large=1
}}

yuvuyu

{{#cargo_query:
  tables=items
  |where = items.rarity_id="unique" 
  |group by=items.base_item
  |format=table
  |fields=items.name,items.base_item
  | no html
  |limit=25
  }}

items._pageID=maps._pageID, maps.area_id=areas.id,

{{#cargo_query:
  tables=items
  |where = items.class_id="DivinationCard" 
  |group by=items.name
  |format=table
  |fields=items.name,items.drop_areas
  |limit=25
  }}

                     
{{#cargo_query:
  tables=items, maps
  |join on=items._pageName=maps._pageName
  |where = items.class_id="Map" AND items.rarity_id!="unique"
  |group by = items.name 
  |format=table
  |fields=items.name, maps.area_id 
  | no html
  }}

   
{{#cargo_query:
  tables=items=divCards,items=mapItems, maps
  |where = mapItems.class_id="Map" AND mapItems.rarity_id!="unique"
  |join on=mapItems._pageName=maps._pageName, divCards.drop_areas HOLDS maps.area_id
  |format=table
  |fields=mapItems.name, divCards.name, maps.area_id 
  |limit=25
  | no html
  }}