View difference between Paste ID: dHH0xvv0 and eAsj2p1y

-select
+elect
  species.identifier as 'id',
  lang.name as 'language',
  coalesce((
   select species_flavor.flavor_text
   from pokemon_species_flavor_text as 'species_flavor'
   where
    species_flavor.species_id==species.id
   and
    species_flavor.language_id==lang.language_id
  ),
  (
   select 'EN:'||species_flavor.flavor_text
- on species_stat.pokemon_id==species.id
+  from pokemon_species_flavor_text as 'species_flavor'
   where
-/* Use with Veekun's database */
+   species_flavor.species_id==species.id
   and
    species_flavor.language_id==9
  )) as 'pkdx',
  coalesce((
   select species_names.name
   from pokemon_species_names as 'species_names'
   where
    species_names.local_language_id==lang.language_id
   and
    species_names.pokemon_species_id==species.id
   ),(
   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',
  (
   select stats.identifier
   from stats
   where stats.id==species_stat.stat_id
   and is_battle_only==0
  ) as 'stat',
  species_stat.base_stat as 'base'
  from
   pokemon_species as 'species'
  join
   pokemon_stats as 'species_stat'
  on
   species_stat.pokemon_id==species.id
  join
   language_names as 'lang'
  order by id asc
 /* Use with Veekun's database! */