User:Aegonostic/Sandbox3
X-Cost minions are summoned by effects which summon minions of X mana.
This page is intended to help players pick out Standard format minions of a certain mana cost to add to their deck.
Standard format[edit | edit source]
1-Cost minions[edit | edit source]
The probability of summoning a specific 1-Cost minion is: Expression error: Unexpected < operator.% — (1/
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)" AND `cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Standard_format_cards(\\||$)") AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="1") AND (`cargo__Cards`.`collectible`=1) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
).
2-Cost minions[edit | edit source]
The probability of summoning a specific 2-Cost minion is: Expression error: Unexpected < operator.% — (1/
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)" AND `cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Standard_format_cards(\\||$)") AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="2") AND (`cargo__Cards`.`collectible`=1) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
).
3-Cost minions[edit | edit source]
The probability of summoning a specific 3-Cost minion is: Expression error: Unexpected < operator.% — (1/
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)" AND `cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Standard_format_cards(\\||$)") AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="3") AND (`cargo__Cards`.`collectible`=1) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
).
4-Cost minions[edit | edit source]
The probability of summoning a specific 4-Cost minion is: Expression error: Unexpected < operator.% — (1/
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)" AND `cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Standard_format_cards(\\||$)") AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="4") AND (`cargo__Cards`.`collectible`=1) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
).
Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT `cargo__Cards`.`targetpage` AS `targetpage`,`cargo__Cards`.`name` AS `name`,`cargo__Cards`.`raritySortOrder` AS `rarity_index`,`cargo__Cards`.`rarity` AS `rarity`,`cargo__Cards`.`subtype` AS `subtype`,`class__full` AS `class`,`cargo__Cards`.`is_multiclass` AS `is_multiclass`,`cargo__Cards`.`multiclass` AS `multiclass`,`cargo__Cards`.`cost` AS `cost`,`cargo__Cards`.`attack` AS `attack`,`cargo__Cards`.`hp` AS `hp`,`cargo__Cards`.`description` AS `description`,`cargo__Cards`.`flavor` AS `flavor` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="4") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000 Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT CONCAT(`cargo__Cards`.`targetpage`) AS `targetpage`,CONCAT(`cargo__Cards`.`name`) AS `name`,CONCAT(`cargo__Cards`.`image`) AS `image`,CONCAT(`cargo__Cards`.`gold_image`) AS `gold_image`,CONCAT("no") AS `gold` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="4") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000
5-Cost minions[edit | edit source]
The probability of summoning a specific 5-Cost minion is: Expression error: Unexpected < operator.% — (1/
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)" AND `cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Standard_format_cards(\\||$)") AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="5") AND (`cargo__Cards`.`collectible`=1) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
).
Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT `cargo__Cards`.`targetpage` AS `targetpage`,`cargo__Cards`.`name` AS `name`,`cargo__Cards`.`raritySortOrder` AS `rarity_index`,`cargo__Cards`.`rarity` AS `rarity`,`cargo__Cards`.`subtype` AS `subtype`,`class__full` AS `class`,`cargo__Cards`.`is_multiclass` AS `is_multiclass`,`cargo__Cards`.`multiclass` AS `multiclass`,`cargo__Cards`.`cost` AS `cost`,`cargo__Cards`.`attack` AS `attack`,`cargo__Cards`.`hp` AS `hp`,`cargo__Cards`.`description` AS `description`,`cargo__Cards`.`flavor` AS `flavor` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="5") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000 Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT CONCAT(`cargo__Cards`.`targetpage`) AS `targetpage`,CONCAT(`cargo__Cards`.`name`) AS `name`,CONCAT(`cargo__Cards`.`image`) AS `image`,CONCAT(`cargo__Cards`.`gold_image`) AS `gold_image`,CONCAT("no") AS `gold` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="5") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000
6-Cost minions[edit | edit source]
The probability of summoning a specific 6-Cost minion is: Expression error: Unexpected < operator.% — (1/
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)" AND `cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Standard_format_cards(\\||$)") AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="6") AND (`cargo__Cards`.`collectible`=1) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
).
Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT `cargo__Cards`.`targetpage` AS `targetpage`,`cargo__Cards`.`name` AS `name`,`cargo__Cards`.`raritySortOrder` AS `rarity_index`,`cargo__Cards`.`rarity` AS `rarity`,`cargo__Cards`.`subtype` AS `subtype`,`class__full` AS `class`,`cargo__Cards`.`is_multiclass` AS `is_multiclass`,`cargo__Cards`.`multiclass` AS `multiclass`,`cargo__Cards`.`cost` AS `cost`,`cargo__Cards`.`attack` AS `attack`,`cargo__Cards`.`hp` AS `hp`,`cargo__Cards`.`description` AS `description`,`cargo__Cards`.`flavor` AS `flavor` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="6") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000 Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT CONCAT(`cargo__Cards`.`targetpage`) AS `targetpage`,CONCAT(`cargo__Cards`.`name`) AS `name`,CONCAT(`cargo__Cards`.`image`) AS `image`,CONCAT(`cargo__Cards`.`gold_image`) AS `gold_image`,CONCAT("no") AS `gold` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="6") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000
7-Cost minions[edit | edit source]
The probability of summoning a specific 7-Cost minion is: Expression error: Unexpected < operator.% — (1/
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)" AND `cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Standard_format_cards(\\||$)") AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="7") AND (`cargo__Cards`.`collectible`=1) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
).
Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT `cargo__Cards`.`targetpage` AS `targetpage`,`cargo__Cards`.`name` AS `name`,`cargo__Cards`.`raritySortOrder` AS `rarity_index`,`cargo__Cards`.`rarity` AS `rarity`,`cargo__Cards`.`subtype` AS `subtype`,`class__full` AS `class`,`cargo__Cards`.`is_multiclass` AS `is_multiclass`,`cargo__Cards`.`multiclass` AS `multiclass`,`cargo__Cards`.`cost` AS `cost`,`cargo__Cards`.`attack` AS `attack`,`cargo__Cards`.`hp` AS `hp`,`cargo__Cards`.`description` AS `description`,`cargo__Cards`.`flavor` AS `flavor` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="7") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000 Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT CONCAT(`cargo__Cards`.`targetpage`) AS `targetpage`,CONCAT(`cargo__Cards`.`name`) AS `name`,CONCAT(`cargo__Cards`.`image`) AS `image`,CONCAT(`cargo__Cards`.`gold_image`) AS `gold_image`,CONCAT("no") AS `gold` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="7") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000
8-Cost minions[edit | edit source]
The probability of summoning a specific 8-Cost minion is: Expression error: Unexpected < operator.% — (1/
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)" AND `cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Standard_format_cards(\\||$)") AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="8") AND (`cargo__Cards`.`collectible`=1) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
).
Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT `cargo__Cards`.`targetpage` AS `targetpage`,`cargo__Cards`.`name` AS `name`,`cargo__Cards`.`raritySortOrder` AS `rarity_index`,`cargo__Cards`.`rarity` AS `rarity`,`cargo__Cards`.`subtype` AS `subtype`,`class__full` AS `class`,`cargo__Cards`.`is_multiclass` AS `is_multiclass`,`cargo__Cards`.`multiclass` AS `multiclass`,`cargo__Cards`.`cost` AS `cost`,`cargo__Cards`.`attack` AS `attack`,`cargo__Cards`.`hp` AS `hp`,`cargo__Cards`.`description` AS `description`,`cargo__Cards`.`flavor` AS `flavor` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="8") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000 Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT CONCAT(`cargo__Cards`.`targetpage`) AS `targetpage`,CONCAT(`cargo__Cards`.`name`) AS `name`,CONCAT(`cargo__Cards`.`image`) AS `image`,CONCAT(`cargo__Cards`.`gold_image`) AS `gold_image`,CONCAT("no") AS `gold` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="8") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000
9-Cost minions[edit | edit source]
The probability of summoning a specific 9-Cost minion is: Expression error: Unexpected < operator.% — (1/
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)" AND `cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Standard_format_cards(\\||$)") AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="9") AND (`cargo__Cards`.`collectible`=1) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
).
Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT `cargo__Cards`.`targetpage` AS `targetpage`,`cargo__Cards`.`name` AS `name`,`cargo__Cards`.`raritySortOrder` AS `rarity_index`,`cargo__Cards`.`rarity` AS `rarity`,`cargo__Cards`.`subtype` AS `subtype`,`class__full` AS `class`,`cargo__Cards`.`is_multiclass` AS `is_multiclass`,`cargo__Cards`.`multiclass` AS `multiclass`,`cargo__Cards`.`cost` AS `cost`,`cargo__Cards`.`attack` AS `attack`,`cargo__Cards`.`hp` AS `hp`,`cargo__Cards`.`description` AS `description`,`cargo__Cards`.`flavor` AS `flavor` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="9") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000 Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT CONCAT(`cargo__Cards`.`targetpage`) AS `targetpage`,CONCAT(`cargo__Cards`.`name`) AS `name`,CONCAT(`cargo__Cards`.`image`) AS `image`,CONCAT(`cargo__Cards`.`gold_image`) AS `gold_image`,CONCAT("no") AS `gold` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="9") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000
10-Cost minions[edit | edit source]
The probability of summoning a specific 10-Cost minion is: Expression error: Unexpected < operator.% — (1/
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)" AND `cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Standard_format_cards(\\||$)") AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="10") AND (`cargo__Cards`.`collectible`=1) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
).
Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT `cargo__Cards`.`targetpage` AS `targetpage`,`cargo__Cards`.`name` AS `name`,`cargo__Cards`.`raritySortOrder` AS `rarity_index`,`cargo__Cards`.`rarity` AS `rarity`,`cargo__Cards`.`subtype` AS `subtype`,`class__full` AS `class`,`cargo__Cards`.`is_multiclass` AS `is_multiclass`,`cargo__Cards`.`multiclass` AS `multiclass`,`cargo__Cards`.`cost` AS `cost`,`cargo__Cards`.`attack` AS `attack`,`cargo__Cards`.`hp` AS `hp`,`cargo__Cards`.`description` AS `description`,`cargo__Cards`.`flavor` AS `flavor` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="10") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000 Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT CONCAT(`cargo__Cards`.`targetpage`) AS `targetpage`,CONCAT(`cargo__Cards`.`name`) AS `name`,CONCAT(`cargo__Cards`.`image`) AS `image`,CONCAT(`cargo__Cards`.`gold_image`) AS `gold_image`,CONCAT("no") AS `gold` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="10") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000
11-Cost minions[edit | edit source]
The probability of summoning a specific 11-Cost minion is: Expression error: Unexpected < operator.% — (1/
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)" AND `cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Standard_format_cards(\\||$)") AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="11") AND (`cargo__Cards`.`collectible`=1) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
).
Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT `cargo__Cards`.`targetpage` AS `targetpage`,`cargo__Cards`.`name` AS `name`,`cargo__Cards`.`raritySortOrder` AS `rarity_index`,`cargo__Cards`.`rarity` AS `rarity`,`cargo__Cards`.`subtype` AS `subtype`,`class__full` AS `class`,`cargo__Cards`.`is_multiclass` AS `is_multiclass`,`cargo__Cards`.`multiclass` AS `multiclass`,`cargo__Cards`.`cost` AS `cost`,`cargo__Cards`.`attack` AS `attack`,`cargo__Cards`.`hp` AS `hp`,`cargo__Cards`.`description` AS `description`,`cargo__Cards`.`flavor` AS `flavor` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="11") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000 Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT CONCAT(`cargo__Cards`.`targetpage`) AS `targetpage`,CONCAT(`cargo__Cards`.`name`) AS `name`,CONCAT(`cargo__Cards`.`image`) AS `image`,CONCAT(`cargo__Cards`.`gold_image`) AS `gold_image`,CONCAT("no") AS `gold` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="11") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000
12-Cost minions[edit | edit source]
The probability of summoning a specific 12-Cost minion is: Expression error: Unexpected < operator.% — (1/
Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)" AND `cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Standard_format_cards(\\||$)") AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="12") AND (`cargo__Cards`.`collectible`=1) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000
).
Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT `cargo__Cards`.`targetpage` AS `targetpage`,`cargo__Cards`.`name` AS `name`,`cargo__Cards`.`raritySortOrder` AS `rarity_index`,`cargo__Cards`.`rarity` AS `rarity`,`cargo__Cards`.`subtype` AS `subtype`,`class__full` AS `class`,`cargo__Cards`.`is_multiclass` AS `is_multiclass`,`cargo__Cards`.`multiclass` AS `multiclass`,`cargo__Cards`.`cost` AS `cost`,`cargo__Cards`.`attack` AS `attack`,`cargo__Cards`.`hp` AS `hp`,`cargo__Cards`.`description` AS `description`,`cargo__Cards`.`flavor` AS `flavor` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="12") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000 Cargo Query Error: Error 3995: Character set 'utf8mb4_unicode_ci' cannot be used in conjunction with 'binary' in call to regexp_like. Function: CargoSQLQuery::run Query: SELECT CONCAT(`cargo__Cards`.`targetpage`) AS `targetpage`,CONCAT(`cargo__Cards`.`name`) AS `name`,CONCAT(`cargo__Cards`.`image`) AS `image`,CONCAT(`cargo__Cards`.`gold_image`) AS `gold_image`,CONCAT("no") AS `gold` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","C","a","r","d","_","d","a","t","a","(\\||$)") AND `cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","S","t","a","n","d","a","r","d","_","f","o","r","m","a","t","_","c","a","r","d","s","(\\||$)")) AND (`cargo__Cards`.`type`=CONCAT("M","i","n","i","o","n")) AND (`cargo__Cards`.`cost`="12") AND (`cargo__Cards`.`collectible`=1) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`cost`,`cargo__Cards`.`name` LIMIT 1000