Select Stat Attributes

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

/* Again, use with Veekun's Database! */