Hearthstone Wiki
Hearthstone Wiki
Hearthstone Wiki
25,040
pages
in: Dinosaurs, Pages with cargo query errors

King Krush

Sign in to edit

Cargo Query Error: Error: Table Card not found.

This article is using {{Card template v2}}.
See Help:Style guide/Card for how to edit this kind of article.
Edit this article
Error: Table Card not found.

is an uncollectible TYPEID card.Cargo Query Error: Error: Table Card not found.Cargo Query Error: 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 'AND `cargo__Achievements`.`id` IS NOT NULL AND `cargo__Achievements`.`descriptio' at line 1

Function: CargoSQLQuery::run Query: SELECT `cargo__RewardItem`.`cardPremiumLevel` AS `cardPremiumLevel`,`cargo__RewardItem`.`quantity` AS `quantity`,`cargo__Achievements`.`id` AS `achievementId`,`cargo__Achievements`.`name` AS `achievementName`,`cargo__Achievements`.`description` AS `achievementDescription`,`cargo__Achievements`.`quota` AS `achievementQuota`,CONCAT("Achievement") AS `type` FROM `cargo__RewardItem` LEFT OUTER JOIN `cargo__Achievements` ON ((`cargo__RewardItem`.`rewardListId`=`cargo__Achievements`.`rewardListId`)) WHERE AND `cargo__Achievements`.`id` IS NOT NULL AND `cargo__Achievements`.`description` IS NOT NULL AND NOT `cargo__RewardItem`.`rewardType`=10 ORDER BY `cargo__RewardItem`.`cardPremiumLevel`,`cargo__RewardItem`.`quantity`,`cargo__Achievements`.`id`,`cargo__Achievements`.`name`,`cargo__Achievements`.`description` LIMIT 100 Cargo Query Error: 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 'AND `cargo__Achievements`.`id` IS NOT NULL AND `cargo__Achievements`.`descriptio' at line 1 Function: CargoSQLQuery::run Query: SELECT CONCAT("Animated") AS `cardPremiumLevel`,`cargo__RewardItem`.`quantity` AS `quantity`,`cargo__Achievements`.`id` AS `achievementId`,`cargo__Achievements`.`name` AS `achievementName`,`cargo__Achievements`.`description` AS `achievementDescription`,`cargo__Achievements`.`quota` AS `achievementQuota`,CONCAT("Achievement") AS `type` FROM `cargo__RewardItem` LEFT OUTER JOIN `cargo__Achievements` ON ((`cargo__RewardItem`.`rewardListId`=`cargo__Achievements`.`rewardListId`)) WHERE AND `cargo__Achievements`.`id` IS NOT NULL AND `cargo__Achievements`.`description` IS NOT NULL AND `cargo__RewardItem`.`rewardType`=10 ORDER BY CONCAT("Animated"),`cargo__RewardItem`.`quantity`,`cargo__Achievements`.`id`,`cargo__Achievements`.`name`,`cargo__Achievements`.`description` LIMIT 100 Cargo Query Error: 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 'AND `cargo__RewardTrackLevel`.`id` IS NOT NULL AND (`cargo__EventTimingEvent`.`s' at line 1 Function: CargoSQLQuery::run Query: SELECT `cargo__RewardItem`.`cardPremiumLevel` AS `cardPremiumLevel`,`cargo__RewardItem`.`quantity` AS `quantity`,`cargo__RewardTrackLevel`.`rewardTrackId` AS `rewardTrackId`,`cargo__RewardTrackLevel`.`level` AS `level`,CONCAT("Free Track") AS `type`,`cargo__RewardTrack`.`name` AS `rewardTrackName`,`cargo__RewardTrack`.`rewardTrackType` AS `rewardTrackType`,DATE_FORMAT(`cargo__EventTimingEvent`.`startTimeUtc`,"%M %e, %Y") AS `startDate`,DATE_FORMAT(`cargo__EventTimingEvent`.`endTimeUtc`,"%H:%i %M %e, %Y") AS `endDate` FROM `cargo__RewardItem` LEFT OUTER JOIN `cargo__RewardTrackLevel` ON ((`cargo__RewardItem`.`rewardListId`=`cargo__RewardTrackLevel`.`freeRewardListId`)) LEFT OUTER JOIN `cargo__RewardTrack` ON ((`cargo__RewardTrackLevel`.`rewardTrackId`=`cargo__RewardTrack`.`id`)) LEFT OUTER JOIN `cargo__EventTimingEvent` ON ((`cargo__RewardTrack`.`event`=`cargo__EventTimingEvent`.`type`)) WHERE AND `cargo__RewardTrackLevel`.`id` IS NOT NULL AND (`cargo__EventTimingEvent`.`startTimeUtc`>="2023-08-01 17:00:00" OR `cargo__EventTimingEvent`.`startTimeUtc` IS NULL) AND `cargo__RewardTrack`.`rewardTrackType`="1" AND `cargo__EventTimingEvent`.`region`="Americas" ORDER BY `cargo__RewardItem`.`cardPremiumLevel`,`cargo__RewardItem`.`quantity`,`cargo__RewardTrackLevel`.`rewardTrackId`,`cargo__RewardTrackLevel`.`level`,CONCAT("Free Track") LIMIT 100 Cargo Query Error: 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 'AND `cargo__RewardTrackLevel`.`id` IS NOT NULL AND (`cargo__EventTimingEvent`.`s' at line 1 Function: CargoSQLQuery::run Query: SELECT `cargo__RewardItem`.`cardPremiumLevel` AS `cardPremiumLevel`,`cargo__RewardItem`.`quantity` AS `quantity`,`cargo__RewardTrackLevel`.`rewardTrackId` AS `rewardTrackId`,`cargo__RewardTrackLevel`.`level` AS `level`,CONCAT("Paid Track") AS `type`,`cargo__RewardTrack`.`name` AS `rewardTrackName`,`cargo__RewardTrack`.`rewardTrackType` AS `rewardTrackType`,DATE_FORMAT(`cargo__EventTimingEvent`.`startTimeUtc`,"%M %e, %Y") AS `startDate`,DATE_FORMAT(`cargo__EventTimingEvent`.`endTimeUtc`,"%H:%i %M %e, %Y") AS `endDate` FROM `cargo__RewardItem` LEFT OUTER JOIN `cargo__RewardTrackLevel` ON ((`cargo__RewardItem`.`rewardListId`=`cargo__RewardTrackLevel`.`paidRewardListId`)) LEFT OUTER JOIN `cargo__RewardTrack` ON ((`cargo__RewardTrackLevel`.`rewardTrackId`=`cargo__RewardTrack`.`id`)) LEFT OUTER JOIN `cargo__EventTimingEvent` ON ((`cargo__RewardTrack`.`event`=`cargo__EventTimingEvent`.`type`)) WHERE AND `cargo__RewardTrackLevel`.`id` IS NOT NULL AND (`cargo__EventTimingEvent`.`startTimeUtc`>="2023-08-01 17:00:00" OR `cargo__EventTimingEvent`.`startTimeUtc` IS NULL) AND `cargo__RewardTrack`.`rewardTrackType`="1" AND `cargo__EventTimingEvent`.`region`="Americas" ORDER BY `cargo__RewardItem`.`cardPremiumLevel`,`cargo__RewardItem`.`quantity`,`cargo__RewardTrackLevel`.`rewardTrackId`,`cargo__RewardTrackLevel`.`level`,CONCAT("Paid Track") LIMIT 100 Cargo Query Error: 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 'AND `cargo__RewardTrackLevel`.`id` IS NOT NULL AND (`cargo__EventTimingEvent`.`e' at line 1 Function: CargoSQLQuery::run Query: SELECT `cargo__RewardItem`.`cardPremiumLevel` AS `cardPremiumLevel`,`cargo__RewardItem`.`quantity` AS `quantity`,`cargo__RewardTrackLevel`.`rewardTrackId` AS `rewardTrackId`,`cargo__RewardTrackLevel`.`level` AS `level`,CONCAT("Free Track") AS `type`,`cargo__RewardTrack`.`name` AS `rewardTrackName`,`cargo__RewardTrack`.`rewardTrackType` AS `rewardTrackType`,DATE_FORMAT(`cargo__EventTimingEvent`.`startTimeUtc`,"%M %e, %Y") AS `startDate`,DATE_FORMAT(`cargo__EventTimingEvent`.`endTimeUtc`,"%H:%i %M %e, %Y") AS `endDate` FROM `cargo__RewardItem` LEFT OUTER JOIN `cargo__RewardTrackLevel` ON ((`cargo__RewardItem`.`rewardListId`=`cargo__RewardTrackLevel`.`freeRewardListId`)) LEFT OUTER JOIN `cargo__RewardTrack` ON ((`cargo__RewardTrackLevel`.`rewardTrackId`=`cargo__RewardTrack`.`id`)) LEFT OUTER JOIN `cargo__EventTimingEvent` ON ((`cargo__RewardTrack`.`event`=`cargo__EventTimingEvent`.`type`)) WHERE AND `cargo__RewardTrackLevel`.`id` IS NOT NULL AND (`cargo__EventTimingEvent`.`endTimeUtc`<NOW() OR `cargo__EventTimingEvent`.`endTimeUtc` IS NULL) AND NOT `cargo__RewardTrack`.`rewardTrackType`=1 AND NOT `cargo__RewardTrack`.`rewardTrackType`=2 AND `cargo__EventTimingEvent`.`region`="Americas" ORDER BY `cargo__RewardItem`.`cardPremiumLevel`,`cargo__RewardItem`.`quantity`,`cargo__RewardTrackLevel`.`rewardTrackId`,`cargo__RewardTrackLevel`.`level`,CONCAT("Free Track") LIMIT 100 Cargo Query Error: 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 'AND `cargo__Quest`.`id` IS NOT NULL AND (`cargo__EventTimingEvent`.`endTimeUtc`>' at line 1 Function: CargoSQLQuery::run Query: SELECT `cargo__RewardItem`.`cardPremiumLevel` AS `cardPremiumLevel`,`cargo__RewardItem`.`quantity` AS `quantity`,`cargo__Quest`.`name` AS `questName`,`cargo__Quest`.`description` AS `questDescription`,`cargo__Quest`.`quota` AS `questQuota`,CONCAT("Quest") AS `type`,DATE_FORMAT(`cargo__EventTimingEvent`.`startTimeUtc`,"%M %e, %Y") AS `startDate`,DATE_FORMAT(`cargo__EventTimingEvent`.`endTimeUtc`,"%H:%i %M %e, %Y") AS `endDate` FROM `cargo__RewardItem` LEFT OUTER JOIN `cargo__Quest` ON ((`cargo__RewardItem`.`rewardListId`=`cargo__Quest`.`rewardListId`)) LEFT OUTER JOIN `cargo__EventTimingEvent` ON ((`cargo__Quest`.`event`=`cargo__EventTimingEvent`.`type`)) WHERE AND `cargo__Quest`.`id` IS NOT NULL AND (`cargo__EventTimingEvent`.`endTimeUtc`>NOW() OR `cargo__EventTimingEvent`.`endTimeUtc` IS NULL) AND `cargo__EventTimingEvent`.`region`="Americas" ORDER BY `cargo__RewardItem`.`cardPremiumLevel`,`cargo__RewardItem`.`quantity`,`cargo__Quest`.`name`,`cargo__Quest`.`description`,`cargo__Quest`.`quota` LIMIT 100 Cargo Query Error: 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 'AND `cargo__RewardTrackLevel`.`id` IS NOT NULL AND `cargo__EventTimingEvent`.`st' at line 1 Function: CargoSQLQuery::run Query: SELECT `cargo__RewardItem`.`cardPremiumLevel` AS `cardPremiumLevel`,`cargo__RewardItem`.`quantity` AS `quantity`,`cargo__RewardTrackLevel`.`rewardTrackId` AS `rewardTrackId`,`cargo__RewardTrackLevel`.`level` AS `level`,CONCAT("Free Track") AS `type`,`cargo__RewardTrack`.`name` AS `rewardTrackName`,`cargo__RewardTrack`.`rewardTrackType` AS `rewardTrackType`,DATE_FORMAT(`cargo__EventTimingEvent`.`startTimeUtc`,"%M %e, %Y") AS `startDate`,DATE_FORMAT(`cargo__EventTimingEvent`.`endTimeUtc`,"%M %e, %Y") AS `endDate` FROM `cargo__RewardItem` LEFT OUTER JOIN `cargo__RewardTrackLevel` ON ((`cargo__RewardItem`.`rewardListId`=`cargo__RewardTrackLevel`.`freeRewardListId`)) LEFT OUTER JOIN `cargo__RewardTrack` ON ((`cargo__RewardTrackLevel`.`rewardTrackId`=`cargo__RewardTrack`.`id`)) LEFT OUTER JOIN `cargo__EventTimingEvent` ON ((`cargo__RewardTrack`.`event`=`cargo__EventTimingEvent`.`type`)) WHERE AND `cargo__RewardTrackLevel`.`id` IS NOT NULL AND `cargo__EventTimingEvent`.`startTimeUtc`<"2023-08-01 17:00:00" AND `cargo__RewardTrack`.`rewardTrackType`="1" AND `cargo__EventTimingEvent`.`region`="Americas" ORDER BY `cargo__RewardItem`.`cardPremiumLevel`,`cargo__RewardItem`.`quantity`,`cargo__RewardTrackLevel`.`rewardTrackId`,`cargo__RewardTrackLevel`.`level`,CONCAT("Free Track") LIMIT 100 Cargo Query Error: 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 'AND `cargo__RewardTrackLevel`.`id` IS NOT NULL AND `cargo__EventTimingEvent`.`st' at line 1 Function: CargoSQLQuery::run Query: SELECT `cargo__RewardItem`.`cardPremiumLevel` AS `cardPremiumLevel`,`cargo__RewardItem`.`quantity` AS `quantity`,`cargo__RewardTrackLevel`.`rewardTrackId` AS `rewardTrackId`,`cargo__RewardTrackLevel`.`level` AS `level`,CONCAT("Paid Track") AS `type`,`cargo__RewardTrack`.`name` AS `rewardTrackName`,`cargo__RewardTrack`.`rewardTrackType` AS `rewardTrackType`,DATE_FORMAT(`cargo__EventTimingEvent`.`startTimeUtc`,"%M %e, %Y") AS `startDate`,DATE_FORMAT(`cargo__EventTimingEvent`.`endTimeUtc`,"%M %e, %Y") AS `endDate` FROM `cargo__RewardItem` LEFT OUTER JOIN `cargo__RewardTrackLevel` ON ((`cargo__RewardItem`.`rewardListId`=`cargo__RewardTrackLevel`.`paidRewardListId`)) LEFT OUTER JOIN `cargo__RewardTrack` ON ((`cargo__RewardTrackLevel`.`rewardTrackId`=`cargo__RewardTrack`.`id`)) LEFT OUTER JOIN `cargo__EventTimingEvent` ON ((`cargo__RewardTrack`.`event`=`cargo__EventTimingEvent`.`type`)) WHERE AND `cargo__RewardTrackLevel`.`id` IS NOT NULL AND `cargo__EventTimingEvent`.`startTimeUtc`<"2023-08-01 17:00:00" AND `cargo__RewardTrack`.`rewardTrackType`="1" AND `cargo__EventTimingEvent`.`region`="Americas" ORDER BY `cargo__RewardItem`.`cardPremiumLevel`,`cargo__RewardItem`.`quantity`,`cargo__RewardTrackLevel`.`rewardTrackId`,`cargo__RewardTrackLevel`.`level`,CONCAT("Paid Track") LIMIT 100 Cargo Query Error: 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 'AND `cargo__RewardTrackLevel`.`id` IS NOT NULL AND `cargo__EventTimingEvent`.`en' at line 1 Function: CargoSQLQuery::run Query: SELECT `cargo__RewardItem`.`cardPremiumLevel` AS `cardPremiumLevel`,`cargo__RewardItem`.`quantity` AS `quantity`,`cargo__RewardTrackLevel`.`rewardTrackId` AS `rewardTrackId`,`cargo__RewardTrackLevel`.`level` AS `level`,CONCAT("Free Track") AS `type`,`cargo__RewardTrack`.`name` AS `rewardTrackName`,`cargo__RewardTrack`.`rewardTrackType` AS `rewardTrackType`,DATE_FORMAT(`cargo__EventTimingEvent`.`startTimeUtc`,"%M %e, %Y") AS `startDate`,DATE_FORMAT(`cargo__EventTimingEvent`.`endTimeUtc`,"%M %e, %Y") AS `endDate` FROM `cargo__RewardItem` LEFT OUTER JOIN `cargo__RewardTrackLevel` ON ((`cargo__RewardItem`.`rewardListId`=`cargo__RewardTrackLevel`.`freeRewardListId`)) LEFT OUTER JOIN `cargo__RewardTrack` ON ((`cargo__RewardTrackLevel`.`rewardTrackId`=`cargo__RewardTrack`.`id`)) LEFT OUTER JOIN `cargo__EventTimingEvent` ON ((`cargo__RewardTrack`.`event`=`cargo__EventTimingEvent`.`type`)) WHERE AND `cargo__RewardTrackLevel`.`id` IS NOT NULL AND `cargo__EventTimingEvent`.`endTimeUtc`>NOW() AND NOT `cargo__RewardTrack`.`rewardTrackType`=1 AND NOT `cargo__RewardTrack`.`rewardTrackType`=2 AND `cargo__EventTimingEvent`.`region`="Americas" ORDER BY `cargo__RewardItem`.`cardPremiumLevel`,`cargo__RewardItem`.`quantity`,`cargo__RewardTrackLevel`.`rewardTrackId`,`cargo__RewardTrackLevel`.`level`,CONCAT("Free Track") LIMIT 100 Cargo Query Error: 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 'AND `cargo__Quest`.`id` IS NOT NULL AND `cargo__EventTimingEvent`.`endTimeUtc`<N' at line 1 Function: CargoSQLQuery::run Query: SELECT `cargo__RewardItem`.`cardPremiumLevel` AS `cardPremiumLevel`,`cargo__RewardItem`.`quantity` AS `quantity`,`cargo__Quest`.`name` AS `questName`,`cargo__Quest`.`description` AS `questDescription`,`cargo__Quest`.`quota` AS `questQuota`,CONCAT("Quest") AS `type`,DATE_FORMAT(`cargo__EventTimingEvent`.`startTimeUtc`,"%M %e, %Y") AS `startDate`,DATE_FORMAT(`cargo__EventTimingEvent`.`endTimeUtc`,"%M %e, %Y") AS `endDate` FROM `cargo__RewardItem` LEFT OUTER JOIN `cargo__Quest` ON ((`cargo__RewardItem`.`rewardListId`=`cargo__Quest`.`rewardListId`)) LEFT OUTER JOIN `cargo__EventTimingEvent` ON ((`cargo__Quest`.`event`=`cargo__EventTimingEvent`.`type`)) WHERE AND `cargo__Quest`.`id` IS NOT NULL AND `cargo__EventTimingEvent`.`endTimeUtc`<NOW() AND `cargo__EventTimingEvent`.`region`="Americas" ORDER BY `cargo__RewardItem`.`cardPremiumLevel`,`cargo__RewardItem`.`quantity`,`cargo__Quest`.`name`,`cargo__Quest`.`description`,`cargo__Quest`.`quota` LIMIT 100

Cargo Query Error: Error: Table Card not found.Cargo Query Error: Error: Table Card not found.Cargo Query Error: Error: Table Card not found.

Lore

Wowpedia iconThis section uses content from Wowpedia.
King Krush is a huge, extremely dangerous and rare devilsaur that stalks Sholazar Basin. His unique appearance and elite status attract many hunters seeking the challenge of taming the great beast, while the prestige associated with slaying him attracts members of all classes and factions.

Trivia

  • The artwork for this card comes from the World of Warcraft Trading Card Game "Fires of Outland" series, for the card The Fare of Lar'korwi. However, the art mis-depicts the ravasaur as a devilsaur, making the final art closer to the World of Warcraft appearance of King Krush than that of Lar'korwi, albeit blue instead of King Krush's original green.
  • King Krush's "dinosauric appearance" summoning animation is likely a reference to the film Jurassic Park, in which a Tyrannosaurus Rex's approaching footsteps cause the earth to shake and tremble.
  • King Krush was a part of MRLGRL! It’s Time to Welcome Nerglish Players to the Inn!, an April Fools joke in 2018 where it was announced that Hearthstone would be fully localized in Nerglish.

    • Gallery

    External links

  • PlayHearthstone
  • HSReplay.net
  • Hearthpwn
  • OutOf.Cards
    • Community content is available under CC BY-NC-SA unless otherwise noted.
    More Fandoms