User:Aegonostic/Sandbox12

From Hearthstone Wiki
Jump to navigation Jump to search

Tavern-purchasable minions in Battlegrounds[edit | edit source]

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`.`type` AS `type`,`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`,CONCAT("") AS `show_tier` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","A","l","l","_","c","a","r","d","_","d","a","t","a","(\\||$)")) AND (`cargo__Cards`.`hiddentags__full` RLIKE CONCAT("(^|,)","B","a","t","t","l","e","g","r","o","u","n","d","s"," ","t","a","v","e","r","n"," ","m","i","n","i","o","n","(,|$)")) 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("(^|\\|)","A","l","l","_","c","a","r","d","_","d","a","t","a","(\\||$)")) AND (`cargo__Cards`.`hiddentags__full` RLIKE CONCAT("(^|,)","B","a","t","t","l","e","g","r","o","u","n","d","s"," ","t","a","v","e","r","n"," ","m","i","n","i","o","n","(,|$)")) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`tier`,`cargo__Cards`.`name` LIMIT 1000

Tavern-purchasable minions in Battlegrounds, golden[edit | edit source]

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`.`type` AS `type`,`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`,CONCAT("") AS `show_tier` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","A","l","l","_","c","a","r","d","_","d","a","t","a","(\\||$)")) AND (`cargo__Cards`.`hiddentags__full` RLIKE CONCAT("(^|,)","B","a","t","t","l","e","g","r","o","u","n","d","s"," ","g","o","l","d","e","n"," ","t","a","v","e","r","n"," ","m","i","n","i","o","n","(,|$)")) 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("(^|\\|)","A","l","l","_","c","a","r","d","_","d","a","t","a","(\\||$)")) AND (`cargo__Cards`.`hiddentags__full` RLIKE CONCAT("(^|,)","B","a","t","t","l","e","g","r","o","u","n","d","s"," ","g","o","l","d","e","n"," ","t","a","v","e","r","n"," ","m","i","n","i","o","n","(,|$)")) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`tier`,`cargo__Cards`.`name` LIMIT 1000


Beasts in Battlegrounds[edit | edit source]

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`.`type` AS `type`,`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`,CONCAT("") AS `show_tier` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE CONCAT("(^|\\|)","A","l","l","_","c","a","r","d","_","d","a","t","a","(\\||$)")) AND (`cargo__Cards`.`subtype`=CONCAT("B","e","a","s","t")) AND (`cargo__Cards`.`hiddentags__full` RLIKE CONCAT("(^|,)","B","a","t","t","l","e","g","r","o","u","n","d","s"," ","t","a","v","e","r","n"," ","m","i","n","i","o","n","(,|$)")) 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("(^|\\|)","A","l","l","_","c","a","r","d","_","d","a","t","a","(\\||$)")) AND (`cargo__Cards`.`subtype`=CONCAT("B","e","a","s","t")) AND (`cargo__Cards`.`hiddentags__full` RLIKE CONCAT("(^|,)","B","a","t","t","l","e","g","r","o","u","n","d","s"," ","t","a","v","e","r","n"," ","m","i","n","i","o","n","(,|$)")) GROUP BY `cargo__Cards`.`_pageName` ORDER BY `cargo__Cards`.`tier`,`cargo__Cards`.`name` LIMIT 1000


Retrieved from "https://hearthstone.wiki.gg/index.php?title=User:Aegonostic/Sandbox12&oldid=233071"