Difference between revisions of "Enemies"
Jump to navigation
Jump to search
>Eave (filter out missing page links in favor of using Dragalia_Lost_Wiki:Missing_Enemy_Pages to reference them instead) |
>Eave m (simplifying the null check condition by inner-joining w/ the EnemyPageLinks table as base instead) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{See|[[Class_Banes#Partial_List_of_High_HP_Enemies_by_Classes|Class Banes]], [[Conditions#Partial_List_of_High_HP_Enemies_Not_Immune_to_Afflictions|Conditions]], [[Damage_Formula#Partial_List_of_High_HP_Enemies_with_Unique_Break_Defense|Damage Formula]], [[Rare_Enemies#Rare_Enemy_Stats|Rare Enemies]] for a list of enemies sorted by class, affliction resistance, unique break defense and by rare enemies respectively.}} | {{See|[[Class_Banes#Partial_List_of_High_HP_Enemies_by_Classes|Class Banes]], [[Conditions#Partial_List_of_High_HP_Enemies_Not_Immune_to_Afflictions|Conditions]], [[Damage_Formula#Partial_List_of_High_HP_Enemies_with_Unique_Break_Defense|Damage Formula]], [[Rare_Enemies#Rare_Enemy_Stats|Rare Enemies]] for a list of enemies sorted by class, affliction resistance, unique break defense and by rare enemies respectively.}} | ||
{{#cargo_query:tables=EnemiesTest=et,EnemyPageLinks=ep | {{#cargo_query:tables=EnemiesTest=et,EnemyPageLinks=ep | ||
| − | |join on= | + | |join on=ep.Name=et.Name |
|fields=CONCAT('[[',ep._pageName,'|',et.Name,']]')=Name,et.ElementalType=Element,et.Tribe=Class | |fields=CONCAT('[[',ep._pageName,'|',et.Name,']]')=Name,et.ElementalType=Element,et.Tribe=Class | ||
| − | |where=et.Name IS NOT NULL AND et.Name != "" AND et.MissionType NOT LIKE "%debug%" AND et.HP != 9999999 AND et.Def!=100000 | + | |where=et.Name IS NOT NULL AND et.Name != "" AND et.MissionType NOT LIKE "%debug%" AND et.HP != 9999999 AND et.Def!=100000 |
|limit=99999 | |limit=99999 | ||
|group by=Name | |group by=Name | ||
Latest revision as of 20:08, 9 May 2020
See: Class Banes, Conditions, Damage Formula, Rare Enemies for a list of enemies sorted by class, affliction resistance, unique break defense and by rare enemies respectively.
Error: Table EnemiesTest not found.