Cargo query

Modify query

View wikitext
{{#cargo_query:
limit=500
|offset=100
|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
|format=dynamic table
|rows per page=30
|details fields=Description
}}