Template:Generic cargo count

This template displays the number of rows in a specified cargo table.

Template parameters[Edit template data]
This template prefers inline formatting of parameters.
Parameter		Description	Type	Status
Cargo table	`1`	no description Example bcs_cards	String	required
Where	`where`	Corresponds to the "where" field in a cargo query.	String	optional
Count	`count`	Overrides the count field. Default COUNT(*) Example COUNT(description_common)+COUNT(description_rare)+COUNT(description_legendary)	String	optional

Example usage

Bloons Card Storm has {{generic cargo count|bcs_cards}} cards.

Bloons Card Storm has

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{{where}}} ORDER BY COUNT(*) LIMIT 100' at line 1

Function: CargoSQLQuery::run Query: SELECT COUNT(*) AS `text` FROM `cargo__bcs_cards` `bcs_cards` WHERE {{{where}}} ORDER BY COUNT(*) LIMIT 100

cards.

Rogue Legends has {{generic cargo count|btd6_artifacts|where=type != "Boost"}} Artifacts, or {{generic cargo count|btd6_artifacts|where=type != "Boost"|count=COUNT(description_common)+COUNT(description_rare)+COUNT(description_legendary)}} if different rarities of an Artifact are counted separately.

Rogue Legends has 116 Artifacts, or 116 Artifacts if all rarities of each Artifact are counted separately.