The wiki is currently a work in progress. If you'd like to help out, please check the Community Portal and our getting started guide. Also, check out our sister project on poewiki.net.

List of unique off hands: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
==List of Off Hands==
=List of Off Hands=


{{Query unique armours|item_class=Shield}}
==List of Shields==
===Armour ([[Strength]])===
 
{{Query unique items
|where=armours.armour_range_average > 0 AND armours.evasion_range_average = 0 AND armours.energy_shield_range_average = 0 AND items.class_id="Shield"}}
|large=1
|level=1
|str=1
|ar=1
|stat=1
|block=1
|no_html={{{no_html|}}}
}}
 
===Evasion ([[Dexterity]])===
 
{{Query unique items
|where=armours.armour_range_average = 0 AND armours.evasion_range_average > 0 AND armours.energy_shield_range_average = 0 AND items.class_id="Shield"}}
|large=1
|level=1
|dex=1
|ev=1
|stat=1
|block=1
|no_html={{{no_html|}}}
}}
 
===Armour/Evasion ([[Strength]]/[[Dexterity]])===
 
{{Query unique items
|where=armours.armour_range_average > 0 AND armours.evasion_range_average > 0 AND armours.energy_shield_range_average = 0 AND items.class_id="Shield"}}
|large=1
|level=1
|dex=1
|str=1
|ar=1
|ev=1
|stat=1
|block=1
|no_html={{{no_html|}}}
}}
 
===Armour/Energy Shield ([[Strength]]/[[Intelligence]])===
 
{{Query unique items
|where=armours.armour_range_average > 0 AND armours.evasion_range_average = 0 AND armours.energy_shield_range_average > 0 AND items.class_id="Shield"}}
|large=1
|level=1
|int=1
|str=1
|ar=1
|es=1
|stat=1
|block=1
|no_html={{{no_html|}}}
}}
 
==List of Foci==
===Energy Shield ([[Intelligence]])===
 
{{Query unique items
|where=armours.armour_range_average = 0 AND armours.evasion_range_average = 0 AND armours.energy_shield_range_average > 0 AND items.class_id="Shield"}}
|large=1
|level=1
|int=1
|es=1
|stat=1
|no_html={{{no_html|}}}
}}


{{Navbox Unique Items}}
{{Navbox Unique Items}}

Revision as of 09:39, 14 October 2024

List of Off Hands

List of Shields

Armour (Strength)

Lua error: Error 1054: Unknown column 'armours.armour_range_average' 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__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) WHERE (`cargo__items`.`drop_enabled` = true

 AND (`cargo__items`.`release_version` IS NULL 
   OR `cargo__items`.`release_version` IS NOT NULL
 ) AND `cargo__items`.`rarity_id` = "unique"
 AND (armours.armour_range_average > 0 AND armours.evasion_range_average = 0 AND armours.energy_shield_range_average = 0 AND `cargo__items`.`class_id`="Shield")) AND `cargo__items`.`_pageNamespace` IN (0,10016)  GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 5000  

. |large=1 |level=1 |str=1 |ar=1 |stat=1 |block=1 |no_html= }}

Evasion (Dexterity)

Lua error: Error 1054: Unknown column 'armours.armour_range_average' 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__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) WHERE (`cargo__items`.`drop_enabled` = true

 AND (`cargo__items`.`release_version` IS NULL 
   OR `cargo__items`.`release_version` IS NOT NULL
 ) AND `cargo__items`.`rarity_id` = "unique"
 AND (armours.armour_range_average = 0 AND armours.evasion_range_average > 0 AND armours.energy_shield_range_average = 0 AND `cargo__items`.`class_id`="Shield")) AND `cargo__items`.`_pageNamespace` IN (0,10016)  GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 5000  

. |large=1 |level=1 |dex=1 |ev=1 |stat=1 |block=1 |no_html= }}

Armour/Evasion (Strength/Dexterity)

Lua error: Error 1054: Unknown column 'armours.armour_range_average' 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__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) WHERE (`cargo__items`.`drop_enabled` = true

 AND (`cargo__items`.`release_version` IS NULL 
   OR `cargo__items`.`release_version` IS NOT NULL
 ) AND `cargo__items`.`rarity_id` = "unique"
 AND (armours.armour_range_average > 0 AND armours.evasion_range_average > 0 AND armours.energy_shield_range_average = 0 AND `cargo__items`.`class_id`="Shield")) AND `cargo__items`.`_pageNamespace` IN (0,10016)  GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 5000  

. |large=1 |level=1 |dex=1 |str=1 |ar=1 |ev=1 |stat=1 |block=1 |no_html= }}

Armour/Energy Shield (Strength/Intelligence)

Lua error: Error 1054: Unknown column 'armours.armour_range_average' 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__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) WHERE (`cargo__items`.`drop_enabled` = true

 AND (`cargo__items`.`release_version` IS NULL 
   OR `cargo__items`.`release_version` IS NOT NULL
 ) AND `cargo__items`.`rarity_id` = "unique"
 AND (armours.armour_range_average > 0 AND armours.evasion_range_average = 0 AND armours.energy_shield_range_average > 0 AND `cargo__items`.`class_id`="Shield")) AND `cargo__items`.`_pageNamespace` IN (0,10016)  GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 5000  

. |large=1 |level=1 |int=1 |str=1 |ar=1 |es=1 |stat=1 |block=1 |no_html= }}

List of Foci

Energy Shield (Intelligence)

Lua error: Error 1054: Unknown column 'armours.armour_range_average' 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__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) WHERE (`cargo__items`.`drop_enabled` = true

 AND (`cargo__items`.`release_version` IS NULL 
   OR `cargo__items`.`release_version` IS NOT NULL
 ) AND `cargo__items`.`rarity_id` = "unique"
 AND (armours.armour_range_average = 0 AND armours.evasion_range_average = 0 AND armours.energy_shield_range_average > 0 AND `cargo__items`.`class_id`="Shield")) AND `cargo__items`.`_pageNamespace` IN (0,10016)  GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 5000  

. |large=1 |level=1 |int=1 |es=1 |stat=1 |no_html= }}