Selecting Ability Alias'

SELECT
 abilities.identifier AS 'id',
 language_names.name AS 'lang',
 COALESCE ((
  SELECT ability_names.name
  FROM ability_names
  WHERE ability_names.ability_id==abilities.id
   AND ability_names.local_language_id==language_names.language_id
  ),(
  SELECT ability_names.name
  FROM ability_names
  WHERE ability_names.ability_id==abilities.id
   AND ability_names.local_language_id==9
)) AS 'name'
 FROM abilities JOIN language_names