Difference between revisions of "User:FabulousCupcake/Skill by SP"
Jump to navigation
Jump to search
>FabulousCupcake |
>FabulousCupcake (thonk) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
tables=Skills=s,Adventurers=a | tables=Skills=s,Adventurers=a | ||
|join on=s.Name=a.Skill1Name | |join on=s.Name=a.Skill1Name | ||
| − | | | + | |where=s.Name=a.Skill1Name |
|fields=CONCAT('<center>[[File:', s.SkillLv1IconName, '.png|40px]]</center>')=Icon, s._pageName=Page, s.Sp=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 | ||
| Line 18: | Line 18: | ||
tables=Skills=s,Adventurers=a | tables=Skills=s,Adventurers=a | ||
|join on=s.Name=a.Skill2Name | |join on=s.Name=a.Skill2Name | ||
| − | | | + | |where=s.Name=a.Skill2Name |
|fields=CONCAT('<center>[[File:', s.SkillLv2IconName, '.png|40px]]</center>')=Icon, s._pageName=Page, s.Sp=SP | |fields=CONCAT('<center>[[File:', s.SkillLv2IconName, '.png|40px]]</center>')=Icon, s._pageName=Page, s.Sp=SP | ||
|order by=s.Sp DESC | |order by=s.Sp DESC | ||
Latest revision as of 06:45, 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.