List of gems rewarded from quests

From Path of Exile Wiki
Revision as of 08:43, 18 April 2020 by >Techhead7890 (rewrite intro and avoid too many hatnotes)
Jump to navigation Jump to search

This is a list of every gem in the game related to a quest and the related quests when they become available. Once the required quest is cleared, it shows which classes are initially offered the gem as a quest reward.

Players can also purchase the gem from vendors afterwards for a small amount of currency. Initially only those classes who could choose it as a reward, along with a slightly larger variety of classes depending on the gem can buy it. However after completing a quest for a certain vendor all classes will be able to buy gems: Siosa will also sell all gems from Acts 1-3, and Lilly Roth will sell all gems in the game (Acts 1-10). There are a few gems in the game that are not quest-related, and all these exceptions are listed at Drop Only Gems.

Gems

Lua error: Error 1054: Unknown column 'cargo__vendor_rewards.reward' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y` FROM `cargo__items` LEFT OUTER JOIN `cargo__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) LEFT OUTER JOIN `cargo__vendor_rewards` ON ((`cargo__items`.`_pageName`=`cargo__vendor_rewards`.`reward`)) LEFT OUTER JOIN `cargo__quest_rewards` ON ((`cargo__items`.`_pageName`=`cargo__quest_rewards`.`reward`)) LEFT OUTER JOIN `cargo__skill_gems` ON ((`cargo__items`.`_pageName`=`cargo__skill_gems`.`_pageName`)) WHERE (`cargo__items`.`drop_enabled` = true 

 AND (`cargo__items`.`release_version` IS NULL 
   OR `cargo__items`.`release_version` IS NOT NULL
   AND `cargo__versions`.`release_date` < 20240517143813
 ) AND `cargo__items`.`base_item` IS NULL
 AND `cargo__items`.`base_item_id` IS NULL
 AND `cargo__items`.`base_item_page` IS NULL
 AND ((`cargo__vendor_rewards`.`reward` IS NOT NULL OR `cargo__quest_rewards`.`reward` IS NOT NULL) 
   AND (`cargo__items`.`class`="Active Skill Gems" OR `cargo__items`.`class` = "Support Skill Gems"))) AND `cargo__items`.`_pageNamespace` IN (0,10016)  GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 5000

.

Retrieved from "https://www.poewiki.net/index.php?title=List_of_gems_rewarded_from_quests&oldid=694967"