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__versions`.`release_date` < 20241128074200
 ) 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__versions`.`release_date` < 20241128074200
 ) 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__versions`.`release_date` < 20241128074200
 ) 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__versions`.`release_date` < 20241128074200
 ) 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__versions`.`release_date` < 20241128074200
 ) 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= }}

Retrieved from "https://www.poe2wiki.net/index.php?title=List_of_unique_off_hands&oldid=8597"