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

Rotface

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.

Possible summons

A list of collectible Legendary minions in Standard and Wild can be found here.Cargo Query Error: Error: Table Card not found.Cargo Query Error: Error: Table Card not found.

Lore

"WEEEEEE!"

Rotface is one of two flesh beasts created by Ashes of OutlandBasicBlackrock MountainClassicHero SkinsNaxxramasDemon Hunter InitiateDescent of DragonsFestival of LegendsForged in the BarrensFractured in Alterac ValleyGalakrond's AwakeningGoblins vs GnomesLegacyLegacyJourney to Un'GoroKnights of the Frozen ThroneKobolds & CatacombsThe League of ExplorersMadness at the Darkmoon FaireMarch of the Lich KingMean Streets of GadgetzanMercenariesMurder at Castle NathriaOne Night in KarazhanPath of ArthasRastakhan's RumblePromoRise of ShadowsSaviors of UldumScholomance AcademyThe Boomsday ProjectThe Grand TournamentThe WitchwoodTITANSUnited in StormwindVoyage to the Sunken CityWhispers of the Old GodsCoreProfessor Putricide, along with Ashes of OutlandBasicBlackrock MountainClassicHero SkinsNaxxramasDemon Hunter InitiateDescent of DragonsFestival of LegendsForged in the BarrensFractured in Alterac ValleyGalakrond's AwakeningGoblins vs GnomesLegacyLegacyJourney to Un'GoroKnights of the Frozen ThroneKobolds & CatacombsThe League of ExplorersMadness at the Darkmoon FaireMarch of the Lich KingMean Streets of GadgetzanMercenariesMurder at Castle NathriaOne Night in KarazhanPath of ArthasRastakhan's RumblePromoRise of ShadowsSaviors of UldumScholomance AcademyThe Boomsday ProjectThe Grand TournamentThe WitchwoodTITANSUnited in StormwindVoyage to the Sunken CityWhispers of the Old GodsCoreFestergut. Both of Putricide's creations are bosses in the Plagueworks wing of Icecrown Citadel that players need to destroy before they can challenge Putricide himself.

Trivia

  • Ashes of OutlandBasicBlackrock MountainClassicHero SkinsNaxxramasDemon Hunter InitiateDescent of DragonsFestival of LegendsForged in the BarrensFractured in Alterac ValleyGalakrond's AwakeningGoblins vs GnomesLegacyLegacyJourney to Un'GoroKnights of the Frozen ThroneKobolds & CatacombsThe League of ExplorersMadness at the Darkmoon FaireMarch of the Lich KingMean Streets of GadgetzanMercenariesMurder at Castle NathriaOne Night in KarazhanPath of ArthasRastakhan's RumblePromoRise of ShadowsSaviors of UldumScholomance AcademyThe Boomsday ProjectThe Grand TournamentThe WitchwoodTITANSUnited in StormwindVoyage to the Sunken CityWhispers of the Old GodsCoreFestergut and Rotface are both boss minions in the Professor Putricide encounter in the Knights of the Frozen Throne mission. They will be automatically summoned on Phase 2 and Phase 3 respectively.
  • Rotface's entry music comes from Pit of Saron. Another part of the soundtrack is also present in the Knights of the Frozen Throne mission's menu.

    • Gallery

    External links

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