User:Findar

Test Page

{{#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=600
|no_html
| no html
}}

Template:Item table

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