Template:BCS cosmetic item list by hero

This template adds rows to the table "bcs_rewards", which is declared by the template BCS rewards. View table.

Generates a table of cosmetic items in Bloons Card Storm that are equippable to a specific Hero using a Cargo query. This template also stores the IDs of the cosmetic items unlocked at levels 10 and 15 to "bcs_rewards".

Template parameters[Edit template data]
This template prefers inline formatting of parameters.
Parameter		Description	Type	Status
Hero	`1`	no description	String	required
Level 10 cosmetic item ID	`level 10`	no description	String	required
Level 15 cosmetic item ID	`level 15`	no description	String	required

Example usage

{{BCS cosmetic item list by hero|Quincy|level 10=CardBackQuincyMasterHero|level 15=AltQuincyHeroCard01}}

Error 1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bloonswiki.items.category' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT CONCAT("Icon of ", `items`.`name`, " ", `items`.`name`) AS `Item`,CONCAT("", `items`.`category`, "") AS `Category`,GROUP_CONCAT(`rewards`.`name` SEPARATOR ", ") AS `Unlock method(s)`,CONCAT(CASE WHEN `items`.`introduced` IS NULL THEN "Launch" ELSE CONCAT("Version ", `items`.`introduced`, "") END) AS `Introduced` FROM `cargo__bcs_cosmetic_items` `items` LEFT OUTER JOIN `cargo__bcs_rewards` `rewards` ON ((`items`.`id`=`rewards`.`item`)) WHERE `items`.`_ID` IN (SELECT `_rowID` FROM `cargo__bcs_cosmetic_items__applies_to` WHERE `_value`= "Quincy") GROUP BY `items`.`_pageName`, `items`.`name`, `items`.`image`, `items`.`introduced`, `rewards`.`item` ORDER BY `items`.`category` LIMIT 100