Template:BTD6 cosmetic item list by introduced

Generates a table of cosmetic items in Bloons TD 6 according to the version they were introduced in using a Cargo query.

Template parameters[Edit template data]
This template prefers inline formatting of parameters.
Parameter		Description	Type	Status
Version	`1`	The version to list items from. Must be a number and cannot include the "v". Example 40.0	Number	required
XD only?	`xd only`	If enabled, shows items exclusive to the Chinese version. If not, Chinese version-exclusive items are excluded.	Boolean	optional

Example usage

{{BTD6 cosmetic item list by introduced|45.0}}

Error 1052: Column '_pageName' in field list is ambiguous

Function: CargoSQLQuery::run Query: SELECT CONCAT("<div class='gccl-flex'>Image of", `items`.`name`, "", "", `items`.`name`, "", "</div>") AS `Item`,CONCAT(`items`.`category`, " ― ", `items`.`subcategory`, "") AS `Category`,IF(GROUP_CONCAT(`sources`.`name`) LIKE "%Trophy Store%", "", "") AS `Trophy Store?` FROM `cargo__btd6_cosmetic_items` `items` LEFT OUTER JOIN `cargo__btd6_cosmetic_sources` `sources` ON ((`items`.`id`=`sources`.`item`)) WHERE `items`.`introduced` = "45.0" AND NOT xd_only GROUP BY `items`.`_pageName`, `items`.`name`, `items`.`image`, `items`.`category`, `items`.`subcategory`, `items`.`introduced` ORDER BY `Trophy Store?` DESC,`items`.`category`,`items`.`subcategory`,`items`.`name` LIMIT 100

</noinclude>