Difference between revisions of "User:FabulousCupcake/Skill by SP"
Jump to navigation
Jump to search
>FabulousCupcake |
>FabulousCupcake |
||
| Line 1: | Line 1: | ||
| + | == Adventurer Skill 1 sorted by SP Cost == | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Skills=s,Adventurers=a | tables=Skills=s,Adventurers=a | ||
|join on=s.Name=a.Skill1Name | |join on=s.Name=a.Skill1Name | ||
|group by=a.Skill1Name | |group by=a.Skill1Name | ||
| − | |fields=CONCAT('<center>[[File:', s.SkillLv1IconName, '.png|40px]]</center>')=Icon, s._pageName=Page, s.Sp | + | |fields=CONCAT('<center>[[File:', s.SkillLv1IconName, '.png|40px]]</center>')=Icon, s._pageName=Page, s.Sp=SP |
|order by=s.Sp DESC | |order by=s.Sp DESC | ||
| − | |limit= | + | |limit=10 |
|format=dynamic table | |format=dynamic table | ||
}} | }} | ||
| − | [[File: | + | == Adventurer Skill 2 sorted by SP Cost == |
| + | {{#cargo_query: | ||
| + | tables=Skills=s,Adventurers=a | ||
| + | |join on=s.Name=a.Skill2Name | ||
| + | |group by=a.Skill2Name | ||
| + | |fields=CONCAT('<center>[[File:', s.SkillLv2IconName, '.png|40px]]</center>')=Icon, s._pageName=Page, s.Sp=SP | ||
| + | |order by=s.Sp DESC | ||
| + | |limit=10 | ||
| + | |format=dynamic table | ||
| + | }} | ||
Revision as of 06:33, 31 August 2019
Adventurer Skill 1 sorted by SP Cost
Error: Table Skills not found.
Adventurer Skill 2 sorted by SP Cost
Error: Table Skills not found.