Template:Query stat related skill gems

Template documentation

Overview

This template will perform a query based on Template:Item table with some fields already filled out based on the parameters.

Sub templates

• Template:Query stat related skill gems/page to create entire wiki pages in regards to stat related queries

Parameters

Parameter	Description	Optional
type	Type of the stat/gem to query for. Can be either active or passives	✗
stat_id_query	Id(s) to query for. This is the portion inside the " " in the Cargo where clause.	✗
where	Can be specified alternatively to stat_id_query to provide your own where clause (i.e. for multiple stat ids)	✓
join	Override the default joins (items, skill_stats_per_level)	✓
where	Override the default tables (items, skill_stats_per_level)	✓
stat_page	Wiki page to link against in the intro and default descriptions	✗
quality	If set, perform the query for quality stats instead of regular stats	✓

Examples

{{Query stat related skill gems
|type=active
|stat_id_query=%attack_speed%
|stat_page=attack speed
|quality=1
}}

yields:

The following active skill gems have quality stats related to attack speed:

Skill gem
Blade FlurryBlade FlurryAttack, AoE, Channelling, Physical, Melee Radius: 14 / 17 / 19 Mana Cost: 4 Attack Speed: 160% of Base Effectiveness of Added Damage: (32%-45%)Requires Level 28Repeatedly hit enemies in a circle in front of you while channelling, dealing damage to and around the enemy. The damage is continually boosted while channelling. You unleash an additional hit for each stage reached once the channelling ends. Requires a Dagger, Claw or One-Handed Sword.Per 1% Quality: 0.5% increased Attack SpeedDeals (32-45)% of Base Damage 20% more Damage with Hits and Ailments for each stage (14-75) to (20-113) Added Attack Physical DamagePlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A			28
Blood RageBlood RageSpell, Duration, Physical Mana Cost: (7-16) Can Store 1 Use(s) Cooldown Time: 1.00 sec Cast Time: 0.00 secRequires Level 16Adds a buff that deals Physical Damage over time, while increasing Attack Speed and Life Leech. Killing an enemy while this buff is active refreshes the buff duration, and can grant a Frenzy Charge.Per 1% Quality: 0.25% increased Attack Speed(5-15)% increased Attack Speed 1.2% of Attack Physical Damage Leeched as Life You take 4% of your Maximum Life per second as Physical Damage You take 4% of your Maximum Energy Shield per second as Physical Damage 25% chance to gain a Frenzy Charge on Kill Base duration is (7-10.8) secondsPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A		N/A	16
Charged DashCharged DashMovement, AoE, Channelling, Attack, Lightning, Melee Mana Cost: 4 Effectiveness of Added Damage: (95%-110%)Requires Level 28Channel to project an illusion which you steer. You gain stages while it moves, until it stops at a maximum total distance. Waves of area damage frequently pulse along its path, based on your attack speed. Stop channelling to teleport to the illusion, dealing a final wave of damage.Per 1% Quality: 0.5% increased Attack SpeedDeals (95-110)% of Base Damage 50% of Physical Damage Converted to Lightning Damage Final wave deals 75% of Damage per stage Deals 150% more Damage while Channelling if Illusion has finished moving Illusion moves at 130% of your Movement SpeedPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A		N/A	28
Double StrikeDouble StrikeAttack, Melee, Strike, Physical Mana Cost: 5 Effectiveness of Added Damage: (91%-112%)Performs two fast strikes with a melee weapon.Per 1% Quality: 0.5% increased Attack SpeedDeals (91.3-112)% of Base Damage Adds (3-113) to (5-169) Physical Damage against Bleeding Enemies 25% chance to cause Bleeding +(0-2) to Melee rangePlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A		N/A	1
FrenzyFrenzyAttack, Projectile, Melee, Strike, Bow Mana Cost: 10 Effectiveness of Added Damage: (115%-135%)Requires Level 16Performs an attack that gives the character a frenzy charge if it hits. Frenzy charges increase your attack speed.Per 1% Quality: 0.5% increased Attack SpeedDeals (115-135)% of Base Damage 5% more Attack Damage per Frenzy Charge 5% more Attack Speed per Frenzy Charge +(0-2) to Melee rangePlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A		N/A	16
ReaveReaveAttack, AoE, Melee Radius: 20 Mana Cost: 6 Effectiveness of Added Damage: (135%-155%)Requires Level 12Attacks a small area in front of you. Each Reave that hits an enemy grants stages, which you will begin to lose after a short period without hitting anything. Only works with Daggers, Claws, and One-Handed Swords.Per 1% Quality: 0.5% increased Attack SpeedDeals (135-155)% of Base Damage 50% more Area of Effect for each stage +(0-2) to radiusPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A			12
Spectral ThrowSpectral ThrowAttack, Projectile Mana Cost: (7-9) Projectile Speed: 1000Throws a spectral copy of your melee weapon. It flies out and then returns to you, in a spinning attack that damages enemies in its path.Per 1% Quality: 0.5% increased Attack SpeedDeals (80-100)% of Base DamagePlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.			N/A	1
Split ArrowSplit ArrowAttack, Projectile, Bow Mana Cost: (6-10) Effectiveness of Added Damage: (90%-109%) Projectile Speed: 3260Fires multiple arrows at different targets.Per 1% Quality: 0.5% increased Attack SpeedDeals (90-109)% of Base Damage Fires (4-6) additional ArrowsPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A		N/A	1
Vaal Double StrikeVaal Double StrikeVaal, Attack, Melee, Strike, Duration, Physical Souls Per Use: 30 (N) / Can Store 2 Use(s) Soul Gain Prevention: 8.000 sec Effectiveness of Added Damage: (28%-33%)Performs two fast strikes with a melee weapon, each of which summons a double of you for a duration to continuously attack monsters in this fashion.Per 1% Quality: 0.5% increased Attack SpeedDeals (28-33)% of Base Damage Base duration is 6 seconds Adds (3-113) to (5-169) Physical Damage against Bleeding Enemies 25% chance to cause Bleeding Can't be Evaded Modifiers to Skill Effect Duration also apply to this Skill's Soul Gain Prevention Doubles have (0-57)% increased Movement Speed +(0-2) to Melee range CorruptedPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A		N/A	1
Vaal ReaveVaal ReaveVaal, Attack, AoE, Melee Radius: 12 Souls Per Use: 35 (N) / Can Store 2 Use(s) Soul Gain Prevention: 4.000 sec Attack Speed: 250% of BaseRequires Level 12Repeatedly attacks a large area in different directions. Each Vaal Reave that hits an enemy grants stages, which you will begin to lose after a short period without hitting anything. Only works with Daggers, Claws, and One-Handed Swords.Per 1% Quality: 0.5% increased Attack SpeedDeals (100-122.8)% of Base Damage 50% more Area of Effect for each stage Can't be Evaded +(0-2) to radius CorruptedPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A			12
Vaal Spectral ThrowVaal Spectral ThrowVaal, Attack, Projectile Souls Per Use: 10 (N) / Can Store 3 Use(s) Soul Gain Prevention: 6.000 sec Effectiveness of Added Damage: (91%-135%)Throws a spectral copy of your melee weapon. It spirals out in a spinning attack that strikes enemies in its path.Per 1% Quality: 0.5% increased Attack SpeedDeals (91-135.46)% of Base Damage Fires 4 additional Projectiles Fires 0 Projectiles in a Nova Can't be Evaded CorruptedPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.			N/A	1
Viper StrikeViper StrikeAttack, Duration, Melee, Strike, Chaos Mana Cost: 5 Effectiveness of Added Damage: (80%-130%)Hits enemies, adding some of your physical damage as chaos damage and inflicting poison which will be affected by modifiers to skill duration. Requires a claw, dagger or sword.Per 1% Quality: 0.5% increased Attack Speed 0.5% increased Poison DurationDeals (80-130)% of Base Damage 50% of Physical Damage Converted to Chaos Damage 60% chance to Poison on Hit Base duration is 4 seconds (5-169) to (7-254) Added Attack Chaos Damage +(0-2) to Melee rangePlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A		N/A	1
Whirling BladesWhirling BladesAttack, Movement, Travel, Melee Mana Cost: 10 Cast Time: 2.60 secRequires Level 10Dive through enemies, dealing weapon damage. Only works with daggers, claws and one handed swords. Cannot be supported by Multistrike.Per 1% Quality: 0.5% increased Attack SpeedDeals (100-120)% of Base Damage +0.6 seconds to Attack TimePlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A			10
CleaveCleaveAttack, AoE, Physical, Melee Radius: 20 Mana Cost: 6 Effectiveness of Added Damage: (125%-170%)The character swings their weapon (or both weapons if dual wielding) in an arc, damaging monsters in an area in front of them. Only works with Axes and Swords.Per 1% Quality: 0.5% increased Attack SpeedDeals (125-170)% of Base Damage When Dual Wielding, Deals 60% Damage from each Weapon combined (2-75) to (3-113) Added Attack Physical Damage +(0-6) to radiusPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.			N/A	1
PunishmentPunishmentSpell, AoE, Duration, Curse, Physical Radius: 22 Mana Cost: (16-33) Cast Time: 0.50 secRequires Level 24Curses all targets in an area, causing them to grant a buff to anyone they hit with melee attacks. The buff grants more Melee Damage and increased Attack Speed.Per 1% Quality: Cursed enemies grant 0.25% increased Attack Speed on Melee hitBase duration is (9-10.9) seconds Cursed enemies grant (25-35)% more Melee Physical Damage on Melee hit Cursed enemies grant (10-19)% increased Attack Speed on Melee hit Buff is applied for a Base Duration of 4 seconds +(0-10) to radiusPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.		N/A		24