Select Stat Attributes

SELECT
 COALESCE(
 (
  SELECT quirks.message
  FROM stat_hint_names AS 'quirks'
  WHERE
  quirks.local_language_id==lang.language_id
   AND
  quirks.stat_hint_id==quirk_index.id
  ),
  (
  SELECT 'EN:'||quirks.message
  FROM stat_hint_names AS 'quirks'
  WHERE
  quirks.local_language_id==9
   AND
  quirks.stat_hint_id==quirk_index.id
   )) AS 'desc',
   lang.name AS 'lang',
   stat.identifier AS 'id'
   FROM
    stats AS 'stat'
   JOIN
    language_names AS 'lang'
   JOIN
    stat_hints AS 'quirk_index'
   ON quirk_index.stat_id==stat.id
   WHERE stat.is_battle_only!=1
  ORDER BY id ASC

/* Used with Veekun's database! */