Varian, King of Stormwind

Cargo Query Error: Error: Table Card not found.

Varian, King of Stormwind

Cargo Query Error: Error: Table Card not found.

Last updated:

August 30, 2023

Wiki mechanics
Battlecry, Put into hand

Wiki tags
Divine Shield-granting, Divine Shield-related, Random, Rush-granting, Rush-related, Taunt-granting, Taunt-related

Flavor

Voice actor:

Chris Metzen

Race:

Human

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.

Achievements

	Category	Name	Description	Rewards
	Gameplay - Stormwind - Neutral	Return of the King	Summon Varian, King of Stormwind with Taunt, Rush, and Divine Shield.	20

Lore

This card shows Varian Wrynn on the throne of Stormwind. He previously appeared in Hearthstone as Varian Wrynn during The Grand Tournament, which was also focused on card-draw and board impact. Varian, King of Stormwind's card art shows Varian using his sword Shalamayne in it's two-sword configuration, first shown in World of Warcraft: Legion.