Team: Difference between revisions

Line 73: Line 73:
|image field=items.image|name field=items.name|link field=items._pageName
|image field=items.image|name field=items.name|link field=items._pageName


|extra col 1=GROUP_CONCAT(rewards.name SEPARATOR "<br>") = Unlock method(s)
|extra col 1=items.category=Category
|extra col 2=GROUP_CONCAT(rewards.name SEPARATOR "<br>") = Unlock method(s)
|col 1 name=Item
|col 1 name=Item
|introduced col game name=Bloons TD 6
|introduced col game name=Bloons TD 6
|join on =items.id = rewards.item
|join on =items.id = rewards.item
|group by=items._pageName, items.name, items.image, items.introduced, rewards.item
|group by=items._pageName, items.name, items.image, items.category, items.introduced, rewards.item
|order by=items.introduced, items.name
|order by=items.name
|center extra cols=y
|center extra cols=y
|link to sections=y
|link to sections=y