Difference between revisions of "User:Mornsta/Sandbox6"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Mornsta-gpuser
>Mornsta-gpuser
Line 11: Line 11:
 
|join on= EnemiesTest.Name=EnemyPageLinks.Name,EnemiesTest.MissionType=Quests.QuestViewName
 
|join on= EnemiesTest.Name=EnemyPageLinks.Name,EnemiesTest.MissionType=Quests.QuestViewName
 
|where=EventName LIKE "%Fortune from Afar%"
 
|where=EventName LIKE "%Fortune from Afar%"
|fields=CONCAT('[[', EnemyPageLinks._pageName, '|', EnemiesTest.Name, ']]')=Name,EnemiesTest.HP,EnemiesTest.Atk=Str,EnemiesTest.Def=Def,CONCAT('{{InlineIcon|Icon Element|', EnemiesTest.ElementalType, '}}')=Element,EnemiesTest.Tribe,CONCAT('[[', Quests._pageName, '|', EnemiesTest.MissionType, ']]')=Quest|group by=EnemiesTest.MonsterId
+
|fields=CONCAT('[[', EnemyPageLinks._pageName, '|', EnemiesTest.Name, ']]')=Name,EnemiesTest.HP=HP,EnemiesTest.Atk=Str,EnemiesTest.Def=Def,CONCAT('{{InlineIcon|Icon Element|', EnemiesTest.ElementalType, '}}')=Element,EnemiesTest.Tribe=Tribe,CONCAT('[[', Quests._pageName, '|', EnemiesTest.MissionType, ']]')=Quest
 +
|group by=EnemiesTest.MonsterId
 
|order by=EnemiesTest.HP DESC,EnemiesTest.Name
 
|order by=EnemiesTest.HP DESC,EnemiesTest.Name
 
|format=template
 
|format=template

Revision as of 08:10, 5 January 2019

Name HP Str Def Element Tribe Quest
Error: Table EnemyPageLinks not found.