Cargo query

Jump to navigation Jump to search
Modify query

View wikitext
{{#cargo_query:
tables=Food, Food__CookEffect, GeneralData
|fields=CONCAT('[[File:', Image, '|20px]] [[',Food._pageName,']]') = Food, Food.Hunger, Food.Thirst, Food.Description, CONCAT('[[', Food__CookEffect._value, ']]') = Cooking Effect
|where=Food._pageNamespace='0'
|join on=Food._pageName = GeneralData._pageName, Food._ID = Food__CookEffect._rowID
|order by=CONCAT('[[File:', Image, '|20px]] [[',`Food`.`_pageName`,']]') , `Food`.`Hunger` , `Food`.`Thirst` , `Food`.`Description` , CONCAT('[[', `Food__CookEffect`.`_value`, ']]') 
|format=dynamic table
|offset=100
|limit=100
|rows per page=30
|details fields=Description
}}