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
No edit summary
No edit summary
Line 7: Line 7:
{{#cargo_query:
{{#cargo_query:
|tables = items
|tables = items
|where = release_version IS NULL AND items._pageNamespace = 0
|where = items._pageNamespace = 0 AND release_version IS NULL
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|format = table
|format = table
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 items._pageNamespace = 0
|where = items._pageNamespace = 0 AND items.class_id LIKE "%Skill Gem" and skill_gems.gem_tier IS NULL
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|format = table
|format = table
Line 28: Line 28:
{{#cargo_query:
{{#cargo_query:
|tables = items
|tables = items
|where = items.name != items._pageName AND items.class_id IN ("Active Skill Gem", "Support Skill Gem", "Meta Skill Gem") AND items._pageNamespace = 0
|where = items._pageNamespace = 0 AND items.name != items._pageName AND items.class_id IN ("Active Skill Gem", "Support Skill Gem", "Meta Skill Gem")
|fields = CONCAT('{{il{{!}}page=', _pageName, '}}') = Gem, _pageName = Page
|fields = CONCAT('{{il{{!}}page=', _pageName, '}}') = Gem, _pageName = Page
|format = table
|format = table
Line 46: Line 46:
{{#cargo_query:
{{#cargo_query:
|tables = items
|tables = items
|where = metadata_id IS NULL AND rarity_id = "normal" AND items._pageNamespace = 0
|where = items._pageNamespace = 0 AND metadata_id IS NULL AND rarity_id = "normal"
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|fields = CONCAT('{{il{{!}}', name, '}}') = Name
|format = table
|format = table

Revision as of 13:55, 8 April 2025

My bot MefistoBot.
My Sandbox.

Items without release_version

Table list [Expand]

Gems without gem_tier

Table list [Expand]

Gems with diffrent name and pageName

Table list [Expand]

Unique items without 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