Template:Query stat related skill gems

50px 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.				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.				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.				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.				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.				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.				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.				16
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.				12
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.				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.				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.				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.				1