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) |
||
| (123 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | {{#cargo_query:tables=EnemiesTest| | + | {{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 | ||
| + | |join on=ep.Name=et.Name | ||
| + | |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 | ||
| + | |limit=99999 | ||
| + | |group by=Name | ||
| + | |order by=Name | ||
| + | |format=dynamic table | ||
| + | |group by=et.Name | ||
| + | |rows per page=20 | ||
| + | }} | ||
| + | <!--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.