User:Findar

Test Page

<thead></thead> <tbody> </tbody>

name	base item	drop level
Abberath's Hooves	Goathide Boots
Abberath's Horn	Goat's Horn
Abhorrent Interrogation	Ambush Mitts
Abyssus	Ezomyte Burgonet
Acton's Nightmare	Overgrown Shrine Map
Actum	Butcher Axe
Advancing Fortress	Gut Ripper
Aegis Aurora	Champion Kite Shield	73
Agnerod East	Imperial Staff
Ahkeli's Meadow	Ruby Ring
Ahn's Contempt	Praetor Crown
Ahn's Heritage	Colossal Tower Shield
Ahn's Might	Midnight Blade
Al Dhih	Timeworn Claw
Alberon's Warpath	Soldier Boots
Algor Mortis	Carnal Mitts	75
Allelopathy	Satin Gloves
Allure	Vaal Claw
Alpha's Howl	Sinner Tricorne
Altered Distant Memory	Synthesised Map
Amanamu's Gaze	Ghastly Eye Jewel
Ambu's Charge	Crusader Chainmail
Ancient Skull	Bone Helmet
Andvarius	Gold Ring	71
Angler's Plait	Unset Ring

More...

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