User:Findar

Test Page

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

{{#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
  }}

User:Findar

Navigation menu