local stat names

SELECT
 COALESCE(
 (
  SELECT stat_names.name
  FROM stat_names
  WHERE
  stat_names.local_language_id==lang.language_id
   AND
  stat_names.stat_id==stat.id
  ),
  (
   SELECT 'EN:'||stat_names.name
   FROM stat_names
   WHERE
    stat_names.local_language_id==9
   AND
    stat_names.stat_id==stat.id
  )
 ) AS 'name',
 lang.name AS 'lang',
 stat.identifier AS 'id',
 stat.is_battle_only AS 'temp'
FROM
 stats AS 'stat'
JOIN
 language_names AS 'lang'

/* Use this with Veekun's database! */