Path of Exile Wiki

Please consider helping keep the wiki up to date. Check the to-do list of updates needed for version 3.14.0.

Game data exports will becoming later as the technical changes in addition to regular changes take some more time.

READ MORE

Path of Exile Wiki
(create user page to hold some query examples)
 
m (expands yes please)
 
Line 2: Line 2:
   
 
=Query Examples=
 
=Query Examples=
  +
{{cot|Unique Items}}
 
==Unique Items==
 
==Unique Items==
 
===Unique Item Based on Name===
 
===Unique Item Based on Name===
Line 38: Line 39:
 
|q_limit=3
 
|q_limit=3
 
}}
 
}}
  +
{{cob}}
   
  +
{{cot|Base Items}}
 
==Base Items==
 
==Base Items==
 
<pre>{{Query base items
 
<pre>{{Query base items
Line 66: Line 69:
 
|stat_column1_stat4_id=additional_all_attributes
 
|stat_column1_stat4_id=additional_all_attributes
 
}}
 
}}
  +
{{cob}}
 
  +
{{cot|Query Gems}}
 
==Query Gems==
 
==Query Gems==
 
<pre>
 
<pre>
Line 139: Line 143:
 
|default=There are currently no support skill gems with related quality stats.
 
|default=There are currently no support skill gems with related quality stats.
 
}}
 
}}
  +
{{cob}}
 
 
 
==Threshold Jewels==
 
==Threshold Jewels==
 
<pre>
 
<pre>

Latest revision as of 22:01, 10 January 2018

CrimsonFalconer

Query Examples

Unique Items [Expand]

Unique Items

Unique Item Based on Name

{{Query unique items|where=items.name="Vessel of Vinktar"
|large=1
|stat=1
|level=1
}}

Yields:

ItemLvl.Stats
Vessel of VinktarVessel of Vinktar
Topaz Flask
Lasts 4.00 Seconds
Consumes (54-60) of 60 Charges on use
+50% to Lightning Resistance
20% less Lightning Damage taken
Requires Level 68(80-100)% increased Charges used
Shocks nearby Enemies during Flask effect, causing 10% increased Damage taken
You are Shocked during Flask effect, causing 50% increased Damage taken
20% of Lightning Damage Leeched as Life during Flask effect
<One of the five modifiers>
The great city of storms, washed away by Vinktar's thirst for power.Right click to drink. Can only hold charges while in belt. Refills as you kill monsters.
68(80-100)% increased Charges used
Shocks nearby Enemies during Flask effect, causing 10% increased Damage taken
You are Shocked during Flask effect, causing 50% increased Damage taken
20% of Lightning Damage Leeched as Life during Flask effect
<One of the five modifiers>
Adds (25-35) to (110-130) Lightning Damage to Attacks during Flask effect
Adds (15-25) to (70-90) Lightning Damage to Spells during Flask effect
Damage Penetrates 10% Lightning Resistance during Flask effect
20% of Physical Damage Converted to Lightning during Flask effect

Unique Items Based on Stats

{{Query unique items
|tables=item_stats
|join=items._pageID=item_stats._pageID
|where=(item_stats.id like "%gain_per_target%" OR item_stats.id like "%granted_when_hit%" OR item_stats.id like "%gained_on%hit%") AND item_stats.is_implicit=0
|large=1
|stat=1
|level=1
|q_limit=3
}}

Yields:

ItemLvl.Stats
Kaom's SignKaom's Sign
Coral Ring
+(20-30) to maximum Life+(10-20) to Strength
+(2-4) Life gained for each Enemy hit by your Attacks
+1 to Maximum Endurance Charges
A token from the sea
A sign for Kaom
to lead his Karui to Wraeclast.
1+(20-30) to maximum Life+(10-20) to Strength
+(2-4) Life gained for each Enemy hit by your Attacks
+1 to Maximum Endurance Charges
RedbeakRedbeak
Rusted Sword
One Handed Sword
Quality: +20%
Physical Damage: 10.2-25.5
Critical Strike Chance: 5.00%
Attacks per Second: 1.71
Weapon Range: 11
40% increased Global Accuracy Rating100% increased Damage when on Low Life
50% increased Physical Damage
Adds 2 to 6 Physical Damage
10% increased Attack Speed
+(20-30) to maximum Life
+2 Life gained for each Enemy hit by Attacks
As battle calms, blood turns to rust.
140% increased Global Accuracy Rating100% increased Damage when on Low Life
50% increased Physical Damage
Adds 2 to 6 Physical Damage
10% increased Attack Speed
+(20-30) to maximum Life
+2 Life gained for each Enemy hit by Attacks
Watcher's EyeWatcher's Eye
Prismatic Jewel
Limited to: 1(4-6)% increased maximum Energy Shield
(4-6)% increased maximum Life
(4-6)% increased maximum Mana
<Two or Three random aura modifiers>
One by one, they stood their ground against a creature
they had no hope of understanding, let alone defeating,
and one by one, they became a part of it.
Place into an allocated Jewel Socket on the Passive Skill Tree. Right click to remove from the Socket.
1(4-6)% increased maximum Energy Shield
(4-6)% increased maximum Life
(4-6)% increased maximum Mana
<Two or Three random aura modifiers>
(1-1.5)% of Fire Damage Leeched as Life while affected by Anger
Damage Penetrates (10-15)% Fire Resistance while affected by Anger
+(30-50)% to Critical Strike Multiplier while affected by Anger
(40-60)% increased Fire Damage while affected by Anger
Gain (15-25)% of Physical Damage as Extra Fire Damage while affected by Anger
(25-40)% of Physical Damage Converted to Fire Damage while affected by Anger
(6-10)% of Damage taken from Mana before Life while affected by Clarity
(15-20)% of Damage taken gained as Mana over 4 seconds when Hit while affected by Clarity
Gain (6-10)% of Maximum Mana as Extra Maximum Energy Shield while affected by Clarity
(10-15)% increased Mana Recovery Rate while affected by Clarity
(10-15)% chance to Recover 10% of Mana when you use a Skill while affected by Clarity
Non-Channelling Skills have -(10-5) to Total Mana Cost while affected by Clarity
+(600-1000) to Armour while affected by Determination
+(5-8)% Chance to Block Attack Damage while affected by Determination
(5-8)% additional Physical Damage Reduction while affected by Determination
You take (60-40)% reduced Extra Damage from Critical Strikes while affected by Determination
(50-40)% reduced Reflected Physical Damage taken while affected by Determination
Unaffected by Vulnerability while affected by Determination
+(5-8)% Chance to Block Spell Damage while affected by Discipline
+(20-30) Energy Shield gained for each Enemy Hit while affected by Discipline
(10-15)% increased Energy Shield Recovery Rate while affected by Discipline
Regenerate (1.5-2.5)% of Energy Shield per Second while affected by Discipline
(30-40)% faster start of Energy Shield Recharge while affected by Discipline
+(5-8)% chance to Evade Attack Hits while affected by Grace
(30-50)% chance to Blind Enemies which Hit you while affected by Grace
(6-10)% chance to Dodge Attack Hits while affected by Grace
(10-15)% increased Movement Speed while affected by Grace
Unaffected by Enfeeble while affected by Grace
(5-8)% chance to Dodge Spell Hits while affected by Haste
(30-50)% increased Cooldown Recovery Rate of Movement Skills used while affected by Haste
Debuffs on you expire (20-15)% faster while affected by Haste
You gain Onslaught for 4 seconds on Kill while affected by Haste
You have Phasing while affected by Haste
Unaffected by Temporal Chains while affected by Haste
Adds (58-70) to (88-104) Cold Damage while affected by Hatred
+(1.2-1.8)% to Critical Strike Chance while affected by Hatred
Damage Penetrates (10-15)% Cold Resistance while affected by Hatred
(40-60)% increased Cold Damage while affected by Hatred
(25-40)% of Physical Damage Converted to Cold Damage while affected by Hatred
+(18-22)% to Damage over Time Multiplier while affected by Malevolence
(8-12)% increased Recovery rate of Life and Energy Shield while affected by Malevolence
Unaffected by Bleeding while affected by Malevolence
Unaffected by Poison while affected by Malevolence
Damaging Ailments you inflict deal Damage (10-15)% faster while affected by Malevolence
Cannot be Blinded while affected by Precision
Gain a Flask Charge when you deal a Critical Strike while affected by Precision
(40-60)% increased Attack Damage while affected by Precision
(10-15)% increased Attack Speed while affected by Precision
+(20-30)% to Critical Strike Multiplier while affected by Precision
(8-12)% chance to deal Double Damage while using Pride
25% chance to Impale Enemies on Hit with Attacks while using Pride
Impales you inflict last 2 additional Hits while using Pride
(40-60)% increased Attack Physical Damage while using Pride
Your Hits Intimidate Enemies for 4 seconds while you are using Pride
+(30-50)% to Chaos Resistance while affected by Purity of Elements
(50-40)% reduced Reflected Elemental Damage taken while affected by Purity of Elements
(8-12)% of Physical Damage from Hits taken as Cold Damage while affected by Purity of Elements
(8-12)% of Physical Damage from Hits taken as Fire Damage while affected by Purity of Elements
(8-12)% of Physical Damage from Hits taken as Lightning Damage while affected by Purity of Elements
Unaffected by Elemental Weakness while affected by Purity of Elements
Immune to Ignite while affected by Purity of Fire
(6-10)% of Physical Damage from Hits taken as Fire Damage while affected by Purity of Fire
Unaffected by Burning Ground while affected by Purity of Fire
Unaffected by Flammability while affected by Purity of Fire
Immune to Freeze while affected by Purity of Ice
(6-10)% of Physical Damage from Hits taken as Cold Damage while affected by Purity of Ice
Unaffected by Chilled Ground while affected by Purity of Ice
Unaffected by Frostbite while affected by Purity of Ice
Immune to Shock while affected by Purity of Lightning
(6-10)% of Physical Damage from Hits taken as Lightning Damage while affected by Purity of Lightning
Unaffected by Conductivity while affected by Purity of Lightning
Unaffected by Shocked Ground while affected by Purity of Lightning
(0.8-1.2)% of Damage leeched as Life while affected by Vitality
+(20-30) Life gained for each Enemy Hit while affected by Vitality
(50-70)% increased Life Recovery from Flasks while affected by Vitality
(10-15)% increased Life Recovery Rate while affected by Vitality
Regenerate (1-1.5)% of Life per second while while affected by Vitality
(70-100)% increased Critical Strike Chance while affected by Wrath
(40-60)% increased Lightning Damage while affected by Wrath
(1-1.5)% of Lightning Damage is Leeched as Energy Shield while affected by Wrath
Damage Penetrates (10-15)% Lightning Resistance while affected by Wrath
Gain (15-25)% of Physical Damage as Extra Lightning Damage while affected by Wrath
(25-40)% of Physical Damage Converted to Lightning Damage while affected by Wrath
(10-15)% increased Cast Speed while affected by Zealotry
Effects of Consecrated Ground you create while affected by Zealotry Linger for 2 seconds
Consecrated Ground you create while affected by Zealotry causes enemies to take (8-10)% increased Damage
(100-120)% increased Critical Strike Chance against Enemies on Consecrated Ground while affected by Zealotry
Critical Strikes Penetrate (8-10)% of Enemy Elemental Resistances while affected by Zealotry
Gain Arcane Surge for 4 seconds when you create Consecrated Ground while affected by Zealotry
30% increased Maximum total Recovery per second from Energy Shield Leech while affected by Zealotry
Base Items [Expand]

Base Items

{{Query base items
|tables=item_stats
|join=items._pageID=item_stats._pageID
|where=(item_stats.id like "additional_%dexterity%" or item_stats.id="additional_all_attributes") AND item_stats.is_implicit=1
|level=1
|stat_column1_header=Dexterity
|stat_column1_stat_format=add
|stat_column1_stat1_id=additional_dexterity
|stat_column1_stat2_id=additional_strength_and_dexterity
|stat_column1_stat3_id=additional_dexterity_and_intelligence
|stat_column1_stat4_id=additional_all_attributes
}}

Yields:

ItemLvl.Dexterity
Jade AmuletJade AmuletRequires Level 5+(20-30) to Dexterity5(20-30)
Citrine AmuletCitrine AmuletRequires Level 16+(16-24) to Strength and Dexterity16(16-24)
Turquoise AmuletTurquoise AmuletRequires Level 16+(16-24) to Dexterity and Intelligence16(16-24)
Onyx AmuletOnyx AmuletRequires Level 20+(10-16) to all Attributes20(10-16)
Lion SwordLion SwordTwo Hand Sword
Physical Damage: 69-115
Critical Strike Chance: 5.00%
Attacks per Second: 1.45
Weapon Range: 13
Requires Level 65, 104 Str, 122 Dex+50 to Strength and Dexterity
6550
Query Gems [Expand]

Query Gems

{{Item table/skill gems
|q_tables=skill_stats_per_level
|q_join=skill_gems._pageID=skill_stats_per_level._pageID
|q_where=skill_stats_per_level.id like "%gain_per_target%" OR skill_stats_per_level.id like "%granted_when_hit%"
|level=yes
|int=yes
|dex=yes
|str=yes
|q_sort=Has primary attribute, Has name
}}

Yields:

Skill gemStr.Dex.Int.Lvl.
Life Gain on Hit SupportLife Gain on Hit SupportAttack, Support
Icon: h
Level: (1-20)
Cost & Reservation Multiplier: 130%
Requires Level 8Supports attack skills.Per 1% Quality:1Superior2Anomalous3Divergent+0.5 Life gained for each Enemy hit by Attacks from Supported SkillsSupported Skills deal 2% increased Damage when on Full Life+0.1 Mana gained for each Enemy hit by Attacks from Supported Skills+(6-44) Life gained for each Enemy hit by Attacks from Supported SkillsThis is a Support Gem. It does not grant a bonus to your character, but to skills in sockets connected to it. Place into an item socket connected to a socket containing the Active Skill Gem you wish to augment. Right click to remove from a socket.
yesN/AN/A8
Poacher's MarkPoacher's MarkSpell, Duration, Curse, Mark
Level: (1-20)
Cost: (16-33) Mana
Cast Time: 0.50 sec
Requires Level 24Curses a single enemy, lowering their physical damage reduction, and adding physical damage to all hits against them. Attacking the cursed enemy will grant life and mana, and killing them will grant a frenzy charge. You can only have one Mark at a time.Per 1% Quality:1Superior2Anomalous3DivergentCursed Enemies have a 0.25% chance to grant a Frenzy Charge when HitCursed enemies take 0.2% increased DamageCursed enemies have -0.25% to Physical Damage ReductionBase duration is (6-9.8) seconds
Adds (6-30) to (9-45) Physical Damage to Hits against Cursed Enemies
Cursed enemies have -20% to Physical Damage Reduction
Cursed enemies grant (15-50) Life when Hit by Attacks
Cursed enemies grant (8-25) Mana when Hit by Attacks
Cursed enemies have a 100% chance to grant a Frenzy Charge when slain
Place into an item socket of the right colour to gain this skill. Right click to remove from a socket.
Poacher's Mark skill icon.png
N/AyesN/A24

Base Stats

{{Item table/skill gems
|q_tables=skill_stats_per_level
|q_join=skill_gems._pageID=skill_stats_per_level._pageID
|q_where=items.class="Support Skill Gems" AND skill_stats_per_level.id like "%nslaught%" AND skill_stats_per_level.is_quality_stat=0
|level=yes
|int=yes
|dex=yes
|str=yes
|default=There are currently no support skill gems with related base stats.
}}

Yields: Lua error: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 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__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`,`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` 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 "%nslaught%" AND `cargo__skill_stats_per_level`.`is_quality_stat`=0 AND `cargo__items`.`_pageNamespace` = 0 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 Function: CargoSQLQuery::run Error: 1054 Unknown column 'cargo__skill_stats_per_level.is_quality_stat' in 'where clause' (geo-db-i-master.query.consul.) .

Quality Stats

{{Item table/skill gems
|q_tables=skill_stats_per_level
|q_join=skill_gems._pageID=skill_stats_per_level._pageID
|q_where=items.class="Support Skill Gems" AND skill_stats_per_level.id like "%nslaught%" AND skill_stats_per_level.is_quality_stat=1
|level=yes
|int=yes
|dex=yes
|str=yes
|default=There are currently no support skill gems with related quality stats.
}}

Yields: Lua error: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 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__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`,`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` 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 "%nslaught%" AND `cargo__skill_stats_per_level`.`is_quality_stat`=1 AND `cargo__items`.`_pageNamespace` = 0 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 Function: CargoSQLQuery::run Error: 1054 Unknown column 'cargo__skill_stats_per_level.is_quality_stat' in 'where clause' (geo-db-i-master.query.consul.) .

Threshold Jewels

{{Skill threshold jewel list|stat_id=jewel_fireball}}