User:Mefisto1029: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
(Created page with "Poe 1 Mefisto1029 page")
 
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
[[poewiki:User:Mefisto1029|Poe 1 Mefisto1029 page]]
{{Sister|poewiki=User:Mefisto1029}}
 
==Big def values==
{| class = "wikitable plainlist"
|+ Biggest defense values
|-
! Type
! Armour
! Evasion
! Energy Shield
|-
! Body Armour
|<!--Armour-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Body Armour"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum > 0
|q_orderBy = armours.armour_range_maximum DESC
|q_limit = 1
}}
|<!--Evasion-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Body Armour"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum > 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.evasion_range_maximum  DESC
|q_limit = 1
}}
|<!--Energy shield-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Body Armour"
  AND armours.energy_shield_range_maximum > 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.energy_shield_range_maximum DESC
|q_limit = 1
}}
 
|-
! Helmets
|<!--Armour-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Helmet"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum > 0
|q_orderBy = armours.armour_range_maximum DESC
|q_limit = 1
}}
|<!--Evasion-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Helmet"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum > 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.evasion_range_maximum  DESC
|q_limit = 1
}}
|<!--Energy shield-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Helmet"
  AND armours.energy_shield_range_maximum > 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.energy_shield_range_maximum DESC
|q_limit = 1
}}
 
|-
! Gloves
|<!--Armour-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Gloves"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum > 0
|q_orderBy = armours.armour_range_maximum DESC
|q_limit = 1
}}
|<!--Evasion-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Gloves"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum > 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.evasion_range_maximum  DESC
|q_limit = 1
}}
|<!--Energy shield-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Gloves"
  AND armours.energy_shield_range_maximum > 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.energy_shield_range_maximum DESC
|q_limit = 1
}}
 
|-
! Boots
|<!--Armour-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Boots"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum > 0
|q_orderBy = armours.armour_range_maximum DESC
|q_limit = 1
}}
|<!--Evasion-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Boots"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum > 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.evasion_range_maximum  DESC
|q_limit = 1
}}
|<!--Energy shield-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Boots"
  AND armours.energy_shield_range_maximum > 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.energy_shield_range_maximum DESC
|q_limit = 1
}}
 
|-
! Shields
|<!--Armour-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Shield"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum > 0
|q_orderBy = armours.armour_range_maximum DESC
|q_limit = 1
}}
|<!--Evasion-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Shield"
  AND armours.energy_shield_range_maximum = 0
  AND armours.evasion_range_maximum > 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.evasion_range_maximum  DESC
|q_limit = 1
}}
|<!--Energy shield-->
{{Simple item list
|q_tables = armours
|q_join = items._PageID = armours._PageID
|q_where = items.rarity_id = "normal"
  AND items.drop_enabled = 1
  AND items.class_id = "Shield"
  AND armours.energy_shield_range_maximum > 0
  AND armours.evasion_range_maximum = 0
  AND armours.armour_range_maximum = 0
|q_orderBy = armours.energy_shield_range_maximum DESC
|q_limit = 1
}}
 
|}

Latest revision as of 07:19, 12 October 2024