Select Species Stats

SELECT
 species.identifier AS 'id',
 (
  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
 ORDER BY id ASC
/* Use with Veekun's database */