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
  FROM pokemon_species_flavor_text AS 'species_flavor'
  WHERE
   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! */