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

Boulderfist Ogre

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

How to get

is currently unavailable for obtaining.

Previous availability

used to be obtainable through these means.

TypeSourceQualityCount
Custom Level up warlock to 51 until March 30, 2021. Golden 1
Custom Level up warlock to 52 until March 30, 2021. Golden 1
Custom Unlock warlock until March 30, 2021. Regular 2

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

For general information on ogers, see Oger.

Wowpedia iconThis section uses content from Wowpedia.
The Boulderfist clan is a clan of ogers that live throughout the Arathi Highlands in Azeroth and Nagrand in Outland (hinting that it may have parted when the Dark Portal closed at the end of the Second War).
Their main bases on Azeroth include Boulder'gor and Boulderfist Hall; they also control a significant portion of present-day Stromgarde.
On Outland, a large contingent of Boulderfist ogers roam throughout Nagrand (clefts of Halaa, Burning Blade Ruins, and the hills northwest of Kil'sorrow Fortress) and parts of Terokkar Forest (Bleeding Hollow Ruins). Their leader is a half-orc half-draenei named Lantresor of the Blade.

Trivia

  • The artwork for this card comes from the World of Warcraft Trading Card Game "Crown of the Heavens" series, for the card Grug the Bonecrusher.
  • Boulderfist Oger has become a popular subject of Hearthstone community memes (particularly on the /r/hearthstonecirclejerk subreddit), many of which involve intentionally misspelling the card's name as "Bolderfist Ogre" or describing it as having "Good stats for the cost" in reference to its flavor text.
  • Boulderfist Oger was a part of Patch 22.6.1.1.1.1, an April Fools 2022 prank, with the announced named change to 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 GodsCoreFlamewreathed Faceless and new text "Ogerload: (2)", which is a reference to the subreddit and the 4 mana 7/7 meme.

    • Gallery

    External links

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