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.

User:Mefisto1029: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
(exclude sandbox)
Line 18: Line 18:
|tables = items, skill_gems
|tables = items, skill_gems
|join on = items._pageName=skill_gems._pageName
|join on = items._pageName=skill_gems._pageName
|where = items.class_id LIKE "%Skill Gem%" and skill_gems.gem_tier IS NULL AND _pageName NOT LIKE "%sandbox%"
|where = items.class_id LIKE "%Skill Gem%" and skill_gems.gem_tier IS NULL AND items._pageName NOT LIKE "%sandbox%"
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|format = table
|format = table

Revision as of 18:55, 30 March 2025

My bot MefistoBot.
My Sandbox.

Items without release_version

Table list [Expand]

Gems without gem_tier

Table list [Expand]

Unique flavuor

Table list [Expand]

Items without metadata_id

Files to fix

Big def values

Biggest defense values
Type Armour Evasion Energy Shield
Body Armour
Helmets
Gloves
Boots
Shields