List of gems rewarded from quests
This is a list of every gem in the game showing which class is offered it as a quest reward or purchasable from vendors and when. (Note that vendors will sell the gem once the required quest is cleared)
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` < 20240517225819 ) 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
.