Select All Move Information

SELECT
 moves.identifier AS 'id',
 (
  SELECT types.identifier
  FROM types
  WHERE types.id==moves.type_id
 ) AS 'type',
 moves.POWER AS 'power',
 moves.accuracy AS 'accuracy',
 moves.pp AS 'pp',
 (
  SELECT move_damage_classes.identifier
  FROM move_damage_classes
  WHERE move_damage_classes.id==moves.damage_class_id
 )
 AS 'stat_type',
 (
  SELECT move_targets.identifier
  FROM move_targets
  WHERE move_targets.id==moves.target_id
 )
 AS 'target',
 (
  SELECT stats.identifier
  FROM stats
  JOIN move_meta_stat_changes
  ON move_meta_stat_changes.stat_id==stats.id
  WHERE move_meta_stat_changes.move_id==moves.id
 )
 AS 'change_stat',
 (
  SELECT move_meta_stat_changes.CHANGE
  FROM move_meta_stat_changes
  WHERE move_meta_stat_changes.move_id==moves.id
 )
 AS 'change_level',
 CASE WHEN meta.stat_chance > 0 THEN meta.stat_chance ELSE 100 END AS 'change_chance',
 (
  SELECT
   CASE
   WHEN move_meta_ailments.identifier!='none'
    THEN move_meta_ailments.identifier
   ELSE NULL
  END
  FROM move_meta_ailments
  WHERE move_meta_ailments.id==meta.meta_ailment_id
 )
 AS 'ailment',
 COALESCE((
  SELECT move_flavor_text.flavor_text
  FROM move_flavor_text
  WHERE move_flavor_text.move_id==moves.id
  AND move_flavor_text.language_id==lang.language_id
 ),(
  SELECT 'EN:'||move_flavor_text.flavor_text
  FROM move_flavor_text
  WHERE move_flavor_text.move_id==moves.id
  AND move_flavor_text.language_id==9
 ),(
  SELECT 'JAP:'||move_flavor_text.flavor_text
  FROM move_flavor_text
  WHERE move_flavor_text.move_id==moves.id
  AND move_flavor_text.language_id==1
 ))
 AS 'description',
 COALESCE(meta.min_hits,1) AS 'min_hits',
 COALESCE(meta.max_hits,1) AS 'min_hits',
 COALESCE(meta.min_turns,1) AS 'min_turns',
 COALESCE(meta.max_turns,1) AS 'max_turns',
 meta.recoil AS 'recoil_rate',
 meta.healing AS 'restore_rate',
 meta.flinch_chance AS 'flinch_rate',
 lang.name AS 'language'
FROM moves
JOIN language_names AS 'lang'
JOIN move_meta AS 'meta' ON meta.move_id==moves.id
ORDER BY id ASC,LANGUAGE ASC