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=HP,EnemiesTest.Atk=Str,EnemiesTest.Def=Def,EnemiesTest.Def=Element,EnemiesTest.Tribe=Tribe,CONCAT('[[', Quests._pageName, '|', EnemiesTest.MissionType, ']]')=Quest
+
|fields=CONCAT('[[', EnemyPageLinks._pageName, '|', EnemiesTest.Name, ']]')=Name,EnemiesTest.HP=HP,EnemiesTest.Atk=Str,EnemiesTest.Def=Def,EnemiesTest.ElementalType=Element,EnemiesTest.Tribe=Tribe,CONCAT('[[', Quests._pageName, '|', EnemiesTest.MissionType, ']]')=Quest
 
|group by=EnemiesTest.MonsterId
 
|group by=EnemiesTest.MonsterId
 
|order by=EnemiesTest.HP DESC,EnemiesTest.Name
 
|order by=EnemiesTest.HP DESC,EnemiesTest.Name
Line 18: Line 18:
 
|named args=yes}}
 
|named args=yes}}
 
|}
 
|}
CONCAT('{{InlineIcon|Icon Element|', EnemiesTest.ElementalType, '}}')
 

Revision as of 08:13, 5 January 2019

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