User:Dreddie/sandbox: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==Mastery queries== {{#cargo_query: |tables=mastery_groups,mastery_effects |join on= mastery_groups.mastery_effects HOLDS mastery_effects.id |fields= mastery_groups._pageName=Mastery, GROUP_CONCAT( CONCAT('* ', mastery_effects.stat_text) SEPARATOR "\n")=Effects |where=mastery_groups._ID is not null |order by=mastery_groups._pageName |group by=mastery_groups._pageName }}") |
|||
| Line 1: | Line 1: | ||
==Mastery queries== | ==Mastery queries== | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables=mastery_groups,mastery_effects | |tables=mastery_groups,mastery_effects=e | ||
|join on= mastery_groups.mastery_effects HOLDS | |join on= mastery_groups.mastery_effects HOLDS e.id | ||
|fields= | |fields= | ||
mastery_groups._pageName=Mastery, | mastery_groups._pageName=Mastery, | ||
GROUP_CONCAT( CONCAT('* ', | GROUP_CONCAT( CONCAT('* ', e.stat_text) | ||
SEPARATOR "\n")=Effects | SEPARATOR "\n")=Effects | ||
|where=mastery_groups._ID is not null | |where=mastery_groups._ID is not null and e.stat_text like "%recoup%" | ||
|order by=mastery_groups._pageName | |order by=mastery_groups._pageName | ||
|group by=mastery_groups._pageName | |group by=mastery_groups._pageName | ||
}} | }} | ||
Revision as of 08:16, 14 August 2023
Mastery queries
| Mastery | Effects |
|---|---|
| Leech Mastery |
|
| Mana Mastery |
|
| Recovery Mastery |
|