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
No edit summary |
|||
Line 1: | Line 1: | ||
=List of Off Hands= | |||
{{Query unique armours| | ==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= }}