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

Lua error: Error 1054: Unknown column 'cargo__item_stats.rarity_id' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y`,`cargo__items`.`base_item` AS `items.base_item`,`cargo__items`.`base_item_page` AS `items.base_item_page`,`cargo__items`.`drop_level` AS `items.drop_level` FROM `cargo__items` LEFT OUTER JOIN `cargo__item_stats` ON ((`cargo__items`.`_pageID`=`cargo__item_stats`.`_pageID`)) WHERE (`cargo__item_stats`.`rarity_id`="unique" AND `cargo__item_stats`.`drop_enabled`!="False") AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`_pageID`,`cargo__items`.`_pageName`,`cargo__items`.`name`,`cargo__items`.`inventory_icon`,`cargo__items`.`html` LIMIT 5000 .

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