List of shock related gems: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
>User-100119998
>User-100119998
Line 30: Line 30:
<section begin="support_skill_gems" />
<section begin="support_skill_gems" />
===Related base stats===
===Related base stats===
 
{{Item table/skill gems
{{SMW_skill_gem_query/stat_related
|q_tables = skill_stats_per_level
|conditions=[[Has name::!Sunder]]
|  q_join = skill_gems._pageID = skill_stats_per_level._pageID
|type=support
| q_where = items.class = "Support Skill Gems" AND skill_stats_per_level.id like "%shock%" AND skill_stats_per_level.is_quality_stat=0
|stat_id_query=~*shock*
            AND items.name != "sunder"
|stat_page=shock
|   level = yes
|     int = yes
|    dex = yes
|     str = yes
}}
}}


===Related quality stats===
===Related quality stats===
 
{{Item table/skill gems
{{SMW_skill_gem_query/stat_related
|q_tables = skill_stats_per_level
|conditions=[[Has name::!Sunder]]
|  q_join = skill_gems._pageID = skill_stats_per_level._pageID
|type=support
| q_where = items.class = "Support Skill Gems" AND skill_stats_per_level.id like "%shock%" AND skill_stats_per_level.is_quality_stat=1
|stat_id_query=~*shock*
            AND items.name != "sunder"
|stat_page=shock
|   level = yes
|quality=1
|     int = yes
}}  
|     dex = yes
|     str = yes
}}
<section end="support_skill_gems" />
<section end="support_skill_gems" />


[[Category:Skill lists based on stats]]
[[Category:Skill lists based on stats]]

Revision as of 22:50, 15 January 2018

A list of skill gems that have stats related to shock.

Active skill gems

Related base stats

Lua error: Error 1054: Unknown column 'cargo__skill_stats_per_level.is_quality_stat' 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`,`cargo__items`.`required_level_range_maximum` AS `items.required_level_range_maximum`,`cargo__items`.`required_level_range_text` AS `items.required_level_range_text`,`cargo__items`.`required_level_range_colour` AS `items.required_level_range_colour`,`cargo__skill_gems`.`strength_percent` AS `skill_gems.strength_percent`,`cargo__skill_gems`.`dexterity_percent` AS `skill_gems.dexterity_percent`,`cargo__skill_gems`.`intelligence_percent` AS `skill_gems.intelligence_percent` FROM `cargo__items` LEFT OUTER JOIN `cargo__skill_gems` ON ((`cargo__items`.`_pageID`=`cargo__skill_gems`.`_pageID`)) LEFT OUTER JOIN `cargo__skill_stats_per_level` ON ((`cargo__skill_gems`.`_pageID`=`cargo__skill_stats_per_level`.`_pageID`)) WHERE (`cargo__items`.`class` = "Active Skill Gems" AND `cargo__skill_stats_per_level`.`id` like "%shock%" AND `cargo__skill_stats_per_level`.`is_quality_stat`=0 

           AND `cargo__items`.`name` != "sunder") AND `cargo__items`.`_pageNamespace` IN (0,10016)  GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`_pageID`,`cargo__items`.`_pageName`,`cargo__items`.`name`,`cargo__items`.`inventory_icon`,`cargo__items`.`html` LIMIT 5000

.

Related quality stats

Lua error: Error 1054: Unknown column 'cargo__skill_stats_per_level.is_quality_stat' 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`,`cargo__items`.`required_level_range_maximum` AS `items.required_level_range_maximum`,`cargo__items`.`required_level_range_text` AS `items.required_level_range_text`,`cargo__items`.`required_level_range_colour` AS `items.required_level_range_colour`,`cargo__skill_gems`.`strength_percent` AS `skill_gems.strength_percent`,`cargo__skill_gems`.`dexterity_percent` AS `skill_gems.dexterity_percent`,`cargo__skill_gems`.`intelligence_percent` AS `skill_gems.intelligence_percent` FROM `cargo__items` LEFT OUTER JOIN `cargo__skill_gems` ON ((`cargo__items`.`_pageID`=`cargo__skill_gems`.`_pageID`)) LEFT OUTER JOIN `cargo__skill_stats_per_level` ON ((`cargo__skill_gems`.`_pageID`=`cargo__skill_stats_per_level`.`_pageID`)) WHERE (`cargo__items`.`class`="Active Skill Gems" AND `cargo__skill_stats_per_level`.`id` like "%shock%" AND `cargo__skill_stats_per_level`.`is_quality_stat`=1) AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`_pageID`,`cargo__items`.`_pageName`,`cargo__items`.`name`,`cargo__items`.`inventory_icon`,`cargo__items`.`html` LIMIT 5000 .


Support skill gems

Related base stats

Lua error: Error 1054: Unknown column 'cargo__skill_stats_per_level.is_quality_stat' 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`,`cargo__items`.`required_level_range_maximum` AS `items.required_level_range_maximum`,`cargo__items`.`required_level_range_text` AS `items.required_level_range_text`,`cargo__items`.`required_level_range_colour` AS `items.required_level_range_colour`,`cargo__skill_gems`.`strength_percent` AS `skill_gems.strength_percent`,`cargo__skill_gems`.`dexterity_percent` AS `skill_gems.dexterity_percent`,`cargo__skill_gems`.`intelligence_percent` AS `skill_gems.intelligence_percent` FROM `cargo__items` LEFT OUTER JOIN `cargo__skill_gems` ON ((`cargo__items`.`_pageID`=`cargo__skill_gems`.`_pageID`)) LEFT OUTER JOIN `cargo__skill_stats_per_level` ON ((`cargo__skill_gems`.`_pageID`=`cargo__skill_stats_per_level`.`_pageID`)) WHERE (`cargo__items`.`class` = "Support Skill Gems" AND `cargo__skill_stats_per_level`.`id` like "%shock%" AND `cargo__skill_stats_per_level`.`is_quality_stat`=0 

           AND `cargo__items`.`name` != "sunder") AND `cargo__items`.`_pageNamespace` IN (0,10016)  GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`_pageID`,`cargo__items`.`_pageName`,`cargo__items`.`name`,`cargo__items`.`inventory_icon`,`cargo__items`.`html` LIMIT 5000

.

Related quality stats

Lua error: Error 1054: Unknown column 'cargo__skill_stats_per_level.is_quality_stat' 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`,`cargo__items`.`required_level_range_maximum` AS `items.required_level_range_maximum`,`cargo__items`.`required_level_range_text` AS `items.required_level_range_text`,`cargo__items`.`required_level_range_colour` AS `items.required_level_range_colour`,`cargo__skill_gems`.`strength_percent` AS `skill_gems.strength_percent`,`cargo__skill_gems`.`dexterity_percent` AS `skill_gems.dexterity_percent`,`cargo__skill_gems`.`intelligence_percent` AS `skill_gems.intelligence_percent` FROM `cargo__items` LEFT OUTER JOIN `cargo__skill_gems` ON ((`cargo__items`.`_pageID`=`cargo__skill_gems`.`_pageID`)) LEFT OUTER JOIN `cargo__skill_stats_per_level` ON ((`cargo__skill_gems`.`_pageID`=`cargo__skill_stats_per_level`.`_pageID`)) WHERE (`cargo__items`.`class` = "Support Skill Gems" AND `cargo__skill_stats_per_level`.`id` like "%shock%" AND `cargo__skill_stats_per_level`.`is_quality_stat`=1 

           AND `cargo__items`.`name` != "sunder") AND `cargo__items`.`_pageNamespace` IN (0,10016)  GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`_pageID`,`cargo__items`.`_pageName`,`cargo__items`.`name`,`cargo__items`.`inventory_icon`,`cargo__items`.`html` LIMIT 5000

.

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