View difference between Paste ID: i2WK6XGy and M053hqs5

 select
  species.identifier as 'id',
  lang.name as 'language',
  (
   select species_entry.flavor_text
   from pokemon_species_flavor_text as 'species_entry'
   where species_entry.language_id==lang.language_id
   or species_entry.language_id==9
   group by species_entry.species_id
   having species_entry.version_id==max(species_entry.version_id)
  ) 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',
  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'
  from
   pokemon_species as 'species'
  join stats
  join
   language_names as 'lang'
  order by id asc
 /* Use with Veekun's database! */