User:Findar

Test Page

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

name	base item	drop level
Abberath's Horn	Goat's Horn
Abhorrent Interrogation	Ambush Mitts
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
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
Anathema	Moonstone Ring
Ancient Skull	Bone Helmet
Angler's Plait	Unset Ring
Annihilation's Approach	Dragonscale Boots
Apep's Rage	Omen Wand
Apep's Slumber	Vaal Spirit Shield

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