List of awakened support gems: Difference between revisions
Jump to navigation
Jump to search
Neokowloon (talk | contribs) No edit summary |
Neokowloon (talk | contribs) (→List: better use item name as query instead of internal use metadata id that GGG could change their own internal naming pattern) |
||
Line 18: | Line 18: | ||
|tables=skill, skill_gems | |tables=skill, skill_gems | ||
|join=items._pageID=skill._pageID, items._pageID=skill_gems._pageID | |join=items._pageID=skill._pageID, items._pageID=skill_gems._pageID | ||
|where=items.class="Support Skill Gems" AND | |where=items.class="Support Skill Gems" AND items.name LIKE "Awakened%" AND skill_gems.strength_percent > 50 | ||
|q_orderBy=items.name | |q_orderBy=items.name | ||
|level=yes | |level=yes | ||
Line 29: | Line 29: | ||
|tables=skill, skill_gems | |tables=skill, skill_gems | ||
|join=items._pageID=skill._pageID, items._pageID=skill_gems._pageID | |join=items._pageID=skill._pageID, items._pageID=skill_gems._pageID | ||
|where=items.class="Support Skill Gems" AND | |where=items.class="Support Skill Gems" AND items.name LIKE "Awakened%" AND skill_gems.intelligence_percent > 50 | ||
|q_orderBy=items.name | |q_orderBy=items.name | ||
|level=yes | |level=yes |