Query stat related skill gems

Template documentation[view] [edit] [history] [purge]

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
BarrageBarrageAttack, Projectile, Bow Level: (1-20) Cost: (7-11) Mana Attack Damage: (47-54)% of base Effectiveness of Added Damage: (47-55)%Requires Level 12After a short preparation time, you attack repeatedly with a ranged weapon. These attacks have a small randomised spread. Only works with Bows and Wands.Per 1% Quality:1Superior2Anomalous3Divergent4Phantasmal0.5% increased Projectile Damage1% chance to Knock Enemies Back on hit0.5% increased Attack SpeedInflict non-Damaging Ailments as though dealing 5% more DamageDeals (47-55)% of Base Attack Damage Fires 4 additional Projectiles Fires Projectiles sequentiallyPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A		N/A	12
Blade FlurryBlade FlurryAttack, AoE, Channelling, Physical, Melee Level: (1-20) Cost: 4 Mana Attack Speed: 160% of base Attack Damage: (32-45)% of base Effectiveness of Added Damage: (32-45)% Radius: 14 / 17 / 19Requires 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:1Superior2Anomalous3Divergent0.5% increased Attack SpeedFinal Flurry has 1% increased Area of Effect2% increased Elemental Damage while ChannellingDeals (32-45)% of Base Attack 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 Level: (1-20) Cost: (12-29) Life Cooldown Time: 1.00 sec Can Store 1 Use(s) Cast Time: InstantRequires 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:1Superior2Anomalous3Divergent0.25% increased Attack SpeedBuff grants 0.1% chance to gain a Frenzy Charge when you Hit a Unique EnemyBuff grants 0.02% of Elemental Attack Damage leeched as Life(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 Level: (1-20) Cost: 4 Mana Attack Speed: 160% of base Attack Damage: (95-110)% of base 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:1Superior2Anomalous3Divergent0.5% increased Attack Speed0.5% more Movement Speed1% increased travel distanceDeals (95-110)% of Base Attack 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 Level: (1-20) Cost: 5 Mana Attack Speed: 80% of base Attack Damage: (91-112)% of base Effectiveness of Added Damage: (91-112)%Performs two fast strikes with a melee weapon.Per 1% Quality:1Superior2Anomalous3Divergent0.5% increased Attack Speed2% increased Elemental Damage1% chance to Maim on HitDeals (91.3-112)% of Base Attack Damage Adds (3-113) to (5-169) Physical Damage against Bleeding Enemies 25% chance to cause Bleeding +(0-2) to Melee Strike 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
Ensnaring ArrowEnsnaring ArrowAttack, Projectile, AoE, Bow Level: (1-20) Cost: (8-10) Mana Attack Damage: (140-175)% of base Effectiveness of Added Damage: (140-175)%Requires Level 16Fires an arrow that remains in the ground behind its final target, tethering that enemy to it. Ensnared enemies always count as moving, and have less movement speed while trying to break the snare. The snare will break if they leave the area of effect.Per 1% Quality:1Superior2Anomalous3Divergent0.5% increased Attack Speed1% increased Area of EffectEnsnared Enemies take 0.5% increased Spell DamageDeals (140-175)% of Base Attack Damage Each Snare applies 40% less Movement Speed to Normal or Magic Enemies Each Snare applies 30% less Movement Speed to Rare Enemies Each Snare applies 25% less Movement Speed to Unique Enemies Ensnared Enemies take (15-20)% increased Projectile Damage from Attack Hits Maximum 3 Snares per EnemyPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A		N/A	16
FrenzyFrenzyAttack, Projectile, Melee, Strike, Bow Level: (1-20) Cost: 10 Mana Attack Damage: (115-135)% of base 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:1Superior2Anomalous3Divergent4Phantasmal0.5% increased Attack SpeedFires an additional ProjectileMelee Strikes target 0.05 additional nearby Enemy0.25% increased Damage with Ailments per Frenzy ChargeDeals (115-135)% of Base Attack Damage 5% more Attack Damage per Frenzy Charge 5% more Attack Speed per Frenzy Charge +(0-2) to Melee Strike 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 Level: (1-20) Cost: 6 Mana Attack Damage: (150-180)% of base Effectiveness of Added Damage: (150-180)% Radius: 20Requires 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:1Superior2Anomalous3Divergent4Phantasmal0.5% increased Attack SpeedConverts 5% of Physical Damage to a random Element1% chance to cause Bleeding+0.1 to maximum StagesDeals (150-180)% of Base Attack 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
Shrapnel BallistaShrapnel BallistaAttack, Projectile, Totem, Physical, Bow Level: (1-20) Cost: (5-11) Mana Attack Speed: 50% of base Attack Damage: (38-44)% of base Effectiveness of Added Damage: (38-44)%Summons a ballista totem that fires multiple arrows with extreme force, breaking them apart into shrapnel. Enemies can be hit by multiple arrows from the same attack.Per 1% Quality:1Superior2Anomalous3Divergent4Phantasmal1% increased Projectile SpeedChains +0.1 TimesProjectiles Pierce 0.1 additional Targets0.5% increased Attack SpeedDeals (38-44)% of Base Attack Damage Totem lasts 8 seconds Fires 2 additional Arrows +(2-3) to maximum number of Summoned Ballista Totems (2-56) to (3-85) 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		N/A	1
Siege BallistaSiege BallistaAttack, Projectile, Totem, Bow Level: (1-20) Cost: (6-11) Mana Attack Speed: 50% of base Projectile Speed: 3260Requires Level 12Summons a ballista totem that attacks with piercing arrows.Per 1% Quality:1Superior2Anomalous3Divergent4Phantasmal1% increased Projectile DamageFires 0.1 additional Projectiles 1% reduced Attack Speed1% increased Projectile Speed1% chance to Impale Enemies on HitDeals (100-145)% of Base Attack Damage Totem lasts 8 seconds +(2-3) to maximum number of Summoned Totems Arrows Pierce (6-9) additional TargetsPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A		N/A	12
Spectral Shield ThrowSpectral Shield ThrowAttack, Projectile, Physical Level: (1-20) Cost: (7-10) Mana Critical Strike Chance: 5.00%Requires Level 28Throws a spectral copy of your shield as a projectile which cannot pierce, and deals off-hand damage augmented by the defences of the shield. When it collides with something it will shatter, launching a number of smaller shards as projectiles in all directions. Modifiers that cause additional projectiles to be fired will add more shards, not more copies of the shield.Per 1% Quality:1Superior2Anomalous3Divergent4Phantasmal2% increased Projectile Speed1% increased Damage0.5% increased Attack Speed+1% to Critical Strike Multiplier per 100 Maximum Energy Shield on Shield(58-399) to (86-599) Base Off Hand Physical Damage (4-6) to (5-8) Added Physical Damage per 15 Armour or Evasion Rating on Shield Fires 3 additional Projectiles Shard Projectiles Deal 50% less Damage Base Off Hand Attack time is (0.7-0.6) seconds Primary Projectile chains +3 timesPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.			N/A	28
Spectral ThrowSpectral ThrowAttack, Projectile Level: (1-20) Cost: (7-9) Mana Attack Speed: 110% of base 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:1Superior2Anomalous3Divergent0.5% increased Attack Speed1% increased Projectile Speed0.5% reduced Projectile Speed Fires an additional ProjectileDeals (80-100)% of Base Attack 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, Physical, Bow Level: (1-20) Cost: (6-10) Mana Attack Speed: 110% of base Projectile Speed: 3260Fires multiple arrows at different targets.Per 1% Quality:1Superior2Anomalous3Divergent0.5% increased Attack SpeedFires an additional Arrow1% increased DamageDeals (100-119)% of Base Attack Damage Fires (4-8) additional Arrows (1-56) to (2-85) 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		N/A	1
Tornado ShotTornado ShotAttack, Projectile, Bow Level: (1-20) Cost: (8-10) ManaRequires Level 28Fires a piercing shot that travels until it reaches the targeted location. It will then fire projectiles out in all directions from that point, which will travel for a short time before disappearing.Per 1% Quality:1Superior2Anomalous3Divergent1% increased Projectile DamageConverts 3% of Physical Damage to a random Element0.5% increased Attack SpeedDeals (100-120)% of Base Attack Damage Fires 3 secondary ProjectilesPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A		N/A	28
Vaal Double StrikeVaal Double StrikeVaal, Attack, Melee, Strike, Duration, Physical Level: (1-20) Souls Per Use: 30 Can Store 2 Use(s) Attack Damage: (28-33)% of base 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:1Superior0.5% increased Attack SpeedDeals (28-33)% of Base Attack 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 Strike 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 Level: (1-20) Souls Per Use: 35 Can Store 2 Use(s) Attack Speed: 250% of base Attack Damage: (150-180)% of base Effectiveness of Added Damage: (150-180)% Radius: 12Requires 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:1Superior0.5% increased Attack SpeedDeals (150-180)% of Base Attack Damage 50% more Area of Effect for each stage +4 to maximum Stages 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 Level: (1-20) Souls Per Use: 10 Can Store 3 Use(s) Attack Speed: 110% of base Attack Damage: (91-135)% of base 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:1Superior0.5% increased Attack SpeedDeals (91-135.46)% of Base Attack Damage Fires 4 additional Projectiles Fires Projectiles in a circle 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 Level: (1-20) Cost: 5 Mana Attack Damage: (90-135)% of base Effectiveness of Added Damage: (90-135)%Hits enemies, adding some of your physical damage as chaos damage and inflicting poison which will be affected by modifiers to skill duration. If dual wielding, will strike with both weapons. Requires a claw, dagger or sword.Per 1% Quality:1Superior2Anomalous3Divergent4Phantasmal0.5% increased Attack Speed 0.5% increased Poison Duration1% of Physical Damage Converted to Chaos Damage1% increased Chaos Damage0.5% chance to also Poison a nearby Enemy when you inflict PoisonDeals (90-135)% of Base Attack Damage 60% of Physical Damage Converted to Chaos Damage 60% chance to Poison on Hit Base duration is 4 seconds (5-169) to (7-254) Added Chaos Damage Each Weapon Hits separately if Dual Wielding, dealing 20% less Damage 30% Less Attack Speed if Dual Wielding +(0-2) to Melee Strike 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 Level: (1-20) Cost: 10 ManaRequires Level 10Dive through enemies, dealing weapon damage. Only works with daggers, claws and one handed swords. Cannot be supported by Multistrike.Per 1% Quality:1Superior2Anomalous3Divergent0.5% increased Attack Speed3% increased Damage10% increased Evasion Rating while MovingDeals (100-120)% of Base Attack 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
Flesh OfferingFlesh OfferingMinion, Spell, Duration Level: (1-20) Cost: (16-33) Mana Cast Time: 1.00 secRequires Level 12Consumes a corpse, which temporarily empowers your minions with swiftness. The skill consumes other nearby corpses, increasing the duration for each corpse consumed.Per 1% Quality:1Superior2Anomalous3Divergent0.5% increased Skill Effect DurationGrants Minions 0.02% of Damage Leeched as LifeGrants Minions 0.5% increased Attack SpeedBase duration is 5 seconds Grants Minions (20-30)% increased Attack Speed Grants Minions (20-29)% increased Movement Speed Grants Minions (20-30)% increased Cast Speed Additional 1 seconds Base Duration per extra corpse ConsumedPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A	N/A		12
Kinetic BoltKinetic BoltAttack, Projectile Level: (1-20) Cost: (6-10) Mana Attack Damage: (140-175)% of base Effectiveness of Added Damage: (140-175)%Fire a projectile from your wand that changes direction in a zig-zag pattern at regular intervals or when hitting enemies. Each time it changes direction, a secondary projectile breaks off, flying in the direction it changed away from.Per 1% Quality:1Superior2Anomalous3Divergent1% increased Projectile SpeedIncreases and Reductions to Cast Speed apply to Attack Speed at 2.5% of their value+0.1 Mana gained for each Enemy hitDeals (140-175)% of Base Attack Damage Projectile changes direction (5-8) times Increases and Reductions to Spell Damage also apply to Attack Damage from this Skill at 200% of their value Modifiers which would cause projectiles to Fork instead cause them to change direction additional timesPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.	N/A	N/A		1
CleaveCleaveAttack, AoE, Physical, Melee Level: (1-20) Cost: 6 Mana Attack Speed: 80% of base Attack Damage: (125-170)% of base Effectiveness of Added Damage: (125-170)% Radius: 20The 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:1Superior2Anomalous3Divergent4Phantasmal0.5% increased Attack Speed+1 Life gained for each Enemy hit by your Attacks2% increased Area of Effect while not Dual Wielding5% chance to Destroy Corpses on KillDeals (125-170)% of Base Attack 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
Consecrated PathConsecrated PathFire, Attack, AoE, Movement, Duration, Slam, Melee Level: (1-20) Cost: 8 Mana Attack Speed: 80% of base Attack Damage: (150-184)% of base Effectiveness of Added Damage: (150-184)%Requires Level 28Slams the ground at a targeted location. If an enemy is near where you target, you'll teleport to it from a short distance away, slam, and create an area of consecrated ground. Can't be supported by Multistrike, and requires a Sword, Axe, Mace, Sceptre, Staff or Unarmed.Per 1% Quality:1Superior2Anomalous3Divergent4Phantasmal0.5% increased Area of Effect0.5% increased Attack Speed0.5% increased teleport range2% increased Consecrated Ground AreaDeals (150-184.25)% of Base Attack Damage 50% of Physical Damage Converted to Fire Damage Base duration is 4 seconds Deals up to 20% more Damage to closer targetsPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.		N/A		28
Glacial HammerGlacial HammerAttack, Melee, Strike, Cold Level: (1-20) Cost: 5 Mana Attack Damage: (165-215)% of base Effectiveness of Added Damage: (165-215)%Hits enemies, converting some of your physical damage to cold damage. If an enemy is frozen and is on less than one third life, they will shatter when hit by Glacial Hammer. If striking three times in a row, the third strike will freeze enemies more easily. Requires a Mace, Sceptre or Staff.Per 1% Quality:1Superior2Anomalous3Divergent2% increased Duration of Cold Ailments0.5% increased Attack Speed1% increased Area of EffectDeals (165-269)% of Base Attack Damage 60% of Physical Damage Converted to Cold Damage 25% chance to Freeze enemies 35% increased Duration of Cold Ailments (10-29)% increased Effect of Cold Ailments +(2-4) to Melee Strike Range Every third successive strike Freezes enemies as though dealing (200-390)% more Damage Adds (2-75) to (3-113) Cold Damage against Chilled EnemiesPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.		N/A	N/A	1
Ground SlamGround SlamAttack, AoE, Slam, Melee Level: (1-20) Cost: 6 Mana Attack Speed: 90% of base Attack Damage: (115-150)% of base Effectiveness of Added Damage: (115-150)% Radius: 35Slams the ground in front of you, creating a wave that travels forward and damages enemies with an increased chance to stun. The wave deals more damage to closer enemies. Requires an Axe, Mace, Sceptre, Staff or Unarmed.Per 1% Quality:1Superior2Anomalous3Divergent1% increased Stun Duration on enemies 0.5% increased Area of Effect0.5% increased Attack Speed3% increased Area of Effect 2% reduced angleDeals (115-188)% of Base Attack Damage 25% reduced Enemy Stun Threshold Deals up to (40-49)% more Damage to closer targets +(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	N/A	1
Leap SlamLeap SlamAttack, AoE, Movement, Travel, Slam, Melee Level: (1-20) Cost: 10 Mana Radius: 15Requires Level 10Jump into the air, damaging and knocking back enemies with your weapon where you land. Enemies you would land on are pushed out of the way. Requires an Axe, Mace, Sceptre, Sword or Staff. Cannot be supported by Multistrike.Per 1% Quality:1Superior2Anomalous3Divergent4Phantasmal1% increased Stun Duration on enemies1% increased Area of Effect1% increased Damage0.5% increased Attack SpeedDeals (100-150)% of Base Attack Damage +0.55 seconds to Attack Time (20-39)% increased Stun Duration against Enemies that are on Full Life Damaging Hits always Stun Enemies that are on Full LifePlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.		N/A	N/A	10
SweepSweepAttack, AoE, Physical, Melee Level: (1-20) Cost: 8 Mana Attack Speed: 70% of base Attack Damage: (170-225)% of base Effectiveness of Added Damage: (170-225)% Radius: 26Requires Level 12Swings a two handed melee weapon in a circle, knocking back monsters around the character.Per 1% Quality:1Superior2Anomalous3Divergent4Phantasmal0.5% increased Area of Effect0.5% increased Attack Speed0.1% chance to deal Triple Damage1% increased Knockback DistanceDeals (170-225)% of Base Attack Damage (5-75) to (8-113) Added Attack Physical Damage Knocks Enemies Back on Hit +(0-4) to radiusPlace into an item socket of the right colour to gain this skill. Right click to remove from a socket.		N/A	N/A	12

The above documentation is transcluded from Template:Query stat related skill gems/doc. (edit | history)
Editors can experiment in this template's sandbox (create | mirror) and testcases (create) pages.
Please add categories to the /doc subpage. Subpages of this template.