Select Move Names

SELECT
moves.identifier AS 'id',
language_names.name AS 'lang',
COALESCE(
 (
  SELECT move_names.name
  FROM move_names
  WHERE
  move_names.local_language_id==language_names.language_id
  AND
  move_names.move_id==moves.id
 ),
(
  SELECT "EN:"||move_names.name
  FROM move_names
  WHERE
  move_names.local_language_id==9
  AND
  move_names.move_id==moves.id
 )
) AS 'alias'
FROM moves
JOIN language_names