Difference between revisions of "User:FabulousCupcake/Skill by SP"
Jump to navigation
Jump to search
>FabulousCupcake (Created page with "{{#cargo_query: tables=Skills=s |fields=_pageName=p, Name, Sp |order by=s.Sp DESC |limit=20 |format=dynamic table }}") |
>FabulousCupcake (thonk) |
||
| (17 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | __TOC__ | ||
| + | |||
| + | == Adventurer Skill 1 sorted by SP Cost == | ||
{{#cargo_query: | {{#cargo_query: | ||
| − | tables=Skills=s | + | tables=Skills=s,Adventurers=a |
| − | |fields=_pageName= | + | |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 | ||
|order by=s.Sp DESC | |order by=s.Sp DESC | ||
| − | |limit= | + | |limit=30 |
| + | |format=dynamic table | ||
| + | }} | ||
| + | |||
| + | <hr /> | ||
| + | |||
| + | == Adventurer Skill 2 sorted by SP Cost == | ||
| + | {{#cargo_query: | ||
| + | tables=Skills=s,Adventurers=a | ||
| + | |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 | ||
| + | |order by=s.Sp DESC | ||
| + | |limit=30 | ||
|format=dynamic table | |format=dynamic table | ||
}} | }} | ||
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.