Template:Skills navbox: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
No edit summary
(Limit query to main namespace so that users' test pages don't get picked up. Special handling for Splitting Steel is no longer needed.)
Line 7: Line 7:
|q_tables = skill_gems, skill_gems__gem_tags
|q_tables = skill_gems, skill_gems__gem_tags
|q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID
|q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID
|q_where = (items.class="Active Skill Gems" AND skill_gems.dexterity_percent > 50 ) OR items.name = "Splitting Steel"
|q_where = items.class="Active Skill Gems"  
  AND skill_gems.dexterity_percent > 50  
  AND items._pageNamespace = 0
|q_groupBy = items.name
|q_groupBy = items.name
|q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0
|q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0
Line 17: Line 19:
|q_tables = skill_gems, skill_gems__gem_tags
|q_tables = skill_gems, skill_gems__gem_tags
|q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID
|q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID
|q_where = items.class="Active Skill Gems" AND skill_gems.intelligence_percent > 50  
|q_where = items.class_id="Active Skill Gem"  
  AND skill_gems.intelligence_percent > 50  
  AND items._pageNamespace = 0
|q_groupBy = items.name
|q_groupBy = items.name
|q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0
|q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0
Line 27: Line 31:
|q_tables = skill_gems, skill_gems__gem_tags
|q_tables = skill_gems, skill_gems__gem_tags
|q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID
|q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID
|q_where = items.class="Active Skill Gems" AND skill_gems.strength_percent > 50 AND items.name NOT LIKE "Splitting Steel"
|q_where = items.class_id="Active Skill Gem"  
  AND skill_gems.strength_percent > 50  
  AND items._pageNamespace = 0
|q_groupBy = items.name
|q_groupBy = items.name
|q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0
|q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0
Line 37: Line 43:
|q_tables = skill_gems, skill_gems__gem_tags
|q_tables = skill_gems, skill_gems__gem_tags
|q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID
|q_join = items._pageID=skill_gems._pageID, skill_gems._ID=skill_gems__gem_tags._rowID
|q_where = items.class="Active Skill Gems" AND skill_gems.dexterity_percent < 35 AND skill_gems.strength_percent < 35 AND skill_gems.intelligence_percent < 35  
|q_where = items.class_id="Active Skill Gem"  
  AND skill_gems.dexterity_percent < 35  
  AND skill_gems.strength_percent < 35  
  AND skill_gems.intelligence_percent < 35  
  AND items._pageNamespace = 0
|q_groupBy = items.name
|q_groupBy = items.name
|q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0
|q_having = SUM(CASE skill_gems__gem_tags._value WHEN "Vaal" THEN 1 ELSE 0 END) = 0

Revision as of 13:54, 16 October 2021


Template documentation[view] [edit] [history] [purge]
The above documentation is transcluded from Template:Skills navbox/doc. (edit | history)
Editors can experiment in this template's sandbox (edit | diff) and testcases (create) pages.
Please add categories to the /doc subpage. Subpages of this template.
Retrieved from "https://www.poewiki.net/index.php?title=Template:Skills_navbox&oldid=1100370"