Enemies - Revision history

>Eave: simplifying the null check condition by inner-joining w/ the EnemyPageLinks table as base instead

2020-05-10T01:08:46Z

simplifying the null check condition by inner-joining w/ the EnemyPageLinks table as base instead

2020-05-10T01:08:46Z

simplifying the null check condition by inner-joining w/ the EnemyPageLinks table as base instead

2020-05-10T01:08:46Z

simplifying the null check condition by inner-joining w/ the EnemyPageLinks table as base instead

2020-05-07T19:37:01Z

filter out missing page links in favor of using Dragalia_Lost_Wiki:Missing_Enemy_Pages to reference them instead

2020-05-07T19:37:01Z

filter out missing page links in favor of using Dragalia_Lost_Wiki:Missing_Enemy_Pages to reference them instead

2020-05-07T19:37:01Z

filter out missing page links in favor of using Dragalia_Lost_Wiki:Missing_Enemy_Pages to reference them instead

2020-04-07T01:08:48Z

2020-04-07T01:08:48Z

2020-04-07T01:08:48Z

2020-04-07T01:03:54Z

simplify the table to unique enemy names

@@ 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.}}
 {{#cargo_query:tables=EnemiesTest=et,EnemyPageLinks=ep
-|join on=et.Name=ep.Name
+|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 AND ep.Name IS NOT NULL
+|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

@@ Line 3: / Line 3: @@
 |join on=et.Name=ep.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
+|where=et.Name IS NOT NULL AND et.Name != "" AND et.MissionType NOT LIKE "%debug%" AND et.HP != 9999999 AND et.Def!=100000 AND ep.Name IS NOT NULL
 |limit=99999
 |group by=Name

@@ Line 5: / Line 5: @@
 |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
-|order by=MonsterId
+|group by=Name
 |format=dynamic table
 |group by=et.Name

← Older revision	Revision as of 01:08, 10 May 2020
(No difference)

← Older revision	Revision as of 19:37, 7 May 2020
(No difference)

← Older revision	Revision as of 01:08, 7 April 2020
(No difference)

← Older revision	Revision as of 01:03, 7 April 2020
(No difference)