List of poison related skill gems: Difference between revisions
>Duodecimus (→Related base stats: I'm not technically savvy enough to fix the automatically generated chart, so I just added the missing gem.) |
>Crimsonfalconer (update to cargo itemtable queries) |
||
Line 4: | Line 4: | ||
<section begin="active_skill_gems" /> | <section begin="active_skill_gems" /> | ||
===Related base stats=== | ===Related base stats=== | ||
{{ | {{Item table/skill gems | ||
| | |q_tables=skill_gems,skill_stats_per_level | ||
| | |q_join=items._pageID=skill_gems._pageID,skill_gems._pageID=skill_stats_per_level._pageID | ||
| | |q_where=items.class="Active Skill Gems" AND skill_stats_per_level.id like "%poison%" AND skill_stats_per_level.is_quality_stat=0 | ||
}} | }} | ||
===Related quality stats=== | ===Related quality stats=== | ||
{{ | {{Item table/skill gems | ||
| | |q_tables=skill_gems,skill_stats_per_level | ||
| | |q_join=items._pageID=skill_gems._pageID,skill_gems._pageID=skill_stats_per_level._pageID | ||
| | |q_where=items.class="Active Skill Gems" AND skill_stats_per_level.id like "%poison%" AND skill_stats_per_level.is_quality_stat=1 | ||
}}<section end="active_skill_gems" /> | }}<section end="active_skill_gems" /> | ||
==Support skill gems== | ==Support skill gems== | ||
<section begin="support_skill_gems" /> | <section begin="support_skill_gems" /> | ||
===Related base stats=== | ===Related base stats=== | ||
{{ | {{Item table/skill gems | ||
| | |q_tables=skill_gems,skill_stats_per_level | ||
| | |q_join=items._pageID=skill_gems._pageID,skill_gems._pageID=skill_stats_per_level._pageID | ||
| | |q_where=items.class="Support Skill Gems" AND skill_stats_per_level.id like "%poison%" AND skill_stats_per_level.is_quality_stat=0 | ||
}} | }} | ||
===Related quality stats=== | ===Related quality stats=== | ||
{{ | {{Item table/skill gems | ||
| | |q_tables=skill_gems,skill_stats_per_level | ||
| | |q_join=items._pageID=skill_gems._pageID,skill_gems._pageID=skill_stats_per_level._pageID | ||
| | |q_where=items.class="Support Skill Gems" AND skill_stats_per_level.id like "%poison%" AND skill_stats_per_level.is_quality_stat=1 | ||
}}<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 17:58, 3 January 2018
A list of skill gems that have stats related to poison.
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` 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 "%poison%" AND `cargo__skill_stats_per_level`.`is_quality_stat`=0) 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` 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 "%poison%" 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` 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 "%poison%" AND `cargo__skill_stats_per_level`.`is_quality_stat`=0) 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` 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 "%poison%" 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 .