hearthstone

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 `Achievements`.`id` IS NOT NULL AND `Achievements`.`description` IS NOT NULL' at line 1

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

In World of Warcraft, "Defile" is an iconic ability used 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 GodsCoreThe Lich King during his boss encounter in the Icecrown Citadel raid. The spell defiles the area under a random target. Anyone who enters the area takes Shadow damage and causes the defiled zone to grow.

In the World of Warcraft: Legion expansion, Defile was added as a level 100 talent for Unholy death knights. It works similarly to the Lich King version and replaces the similar death knight ability Death and Decay.

Trivia

  • With the release of Knights of the Frozen Throne, 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 GodsCoreDreadsteed's Deathrattle was changed to summon the new Dreadsteed at the end of the turn instead of right after the Deathrattle triggered; the original behavior would've caused Defile to recast infinitely. This marked the first time a card in Wild format was changed due to interactions with newly released cards.
    • Despite Dreadsteed being changed specifically to prevent infinite loops, Defile stops recasting after 13 recasts as noted above.

    • Gallery

    External links

  • PlayHearthstone
  • HSReplay.net
  • Hearthpwn

    • References