Difference between revisions of "Template:SkillSimpleTableEntry"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Mornsta-gpuser
>Mornsta-gpuser
Line 23: Line 23:
 
     END ASC,
 
     END ASC,
 
     Rarity DESC, Id DESC}}
 
     Rarity DESC, Id DESC}}
| {{#cargo_query:tables=Dragons|fields=CONCAT('[[File:',BaseId,' 0',VariationId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=SkillName="{{{Name|{{PAGENAME}}}}}"|format=ul|group by=_pageName|default=-|order by=  
+
| {{#cargo_query:tables=Dragons|fields=CONCAT('[[File:',BaseId,' 0',VariationId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=SkillName="{{{Name|{{PAGENAME}}}}}"|format=ul|group by=_pageName|default=-|order by= ElementalTypeId ASC, Rarity DESC, Id DESC, FullName ASC}}
    CASE ElementalType
 
    WHEN 'Flame' THEN 1
 
    WHEN 'Water' THEN 2
 
    WHEN 'Wind' THEN 3
 
    WHEN 'Light' THEN 4
 
    WHEN 'Shadow' THEN 5
 
    ELSE 0
 
    END ASC,  
 
    Rarity DESC, Id DESC}}
 
 
|-
 
|-
 
</includeonly><noinclude>[[Category:Templates]]</noinclude>
 
</includeonly><noinclude>[[Category:Templates]]</noinclude>

Revision as of 13:11, 16 March 2019