Difference between revisions of "User:FabulousCupcake/Skill by SP"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>FabulousCupcake
>FabulousCupcake
Line 3: Line 3:
 
|join on=s.Name=a.Skill1Name
 
|join on=s.Name=a.Skill1Name
 
|group by=a.Skill1Name
 
|group by=a.Skill1Name
|fields=s._pageName=p, s.Name, s.Sp
+
|fields=CONCAT('<center>[[File:', s.SkillLv1IconName, '.png|40px]]</center>')=Icon, s._pageName=Page, s.Sp
 
|order by=s.Sp DESC
 
|order by=s.Sp DESC
 
|limit=20
 
|limit=20
 
|format=dynamic table
 
|format=dynamic table
 
}}
 
}}
 +
 +
[[File:{{{SkillLv1IconName|}}}.png]]

Revision as of 06:30, 31 August 2019

Error: Table Skills not found.

File:.png