Difference between revisions of "Enemies"
Jump to navigation
Jump to search
imported>Elaeagnifolia |
>Eave m (simplifying the null check condition by inner-joining w/ the EnemyPageLinks table as base instead) |
||
| (14 intermediate revisions by 4 users 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= | + | |limit=99999 |
| − | |order by= | + | |group by=Name |
| + | |order by=Name | ||
|format=dynamic table | |format=dynamic table | ||
| − | |group by= | + | |group by=et.Name |
| − | |rows per page= | + | |rows per page=20 |
}} | }} | ||
<!--This page does not use elemental icons as it causes undue page load on low spec devices.--> | <!--This page does not use elemental icons as it causes undue page load on low spec devices.--> | ||
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.