View difference between Paste ID: M053hqs5 and dHH0xvv0

-elect
+select
  species.identifier as 'id',
  lang.name as 'language',
  (
-  select species_flavor.flavor_text
+  select species_entry.flavor_text
-  from pokemon_species_flavor_text as 'species_flavor'
+  from pokemon_species_flavor_text as 'species_entry'
   where species_entry.language_id==lang.language_id
-   species_flavor.species_id==species.id
+  or species_entry.language_id==9
   group by species_entry.species_id
-   species_flavor.language_id==lang.language_id
+  having species_entry.version_id==max(species_entry.version_id)
- ),
+ ) as 'pkdx',
  coalesce((
-  select 'EN:'||species_flavor.flavor_text
+
-  from pokemon_species_flavor_text as 'species_flavor'
+
   where
-   species_flavor.species_id==species.id
+
   and
-   species_flavor.language_id==9
+
- )) as 'pkdx',
+
   select 'EN:'||species_names.name
   from pokemon_species_names as 'species_names'
   where
    species_names.local_language_id==9
   and
    species_names.pokemon_species_id==species.id
  )) as 'name',
  stats.identifier as 'base',
  (
   select pokemon_stats.base_stat
   from pokemon_stats
   where
    pokemon_stats.pokemon_id==species.id
   and
    pokemon_stats.stat_id==stats.id
  ) as 'stat'
-  select stats.identifier
+
-  from stats
+
-  where stats.id==species_stat.stat_id
+ join stats
-  and is_battle_only==0
+
- ) as 'stat',
+
- species_stat.base_stat as 'base'
+
 /* Use with Veekun's database! */