Gather All Type Info.

SELECT
 TYPE.identifier AS 'id',
 lang.name AS 'language',
 COALESCE
 (
  (SELECT names.name
   FROM type_names AS 'names'
   WHERE
    names.local_language_id==lang.language_id
   AND
    names.type_id==TYPE.id
  ),
  (SELECT 'EN:'||names.name
  FROM type_names AS 'names'
   WHERE
    names.local_language_id==9
   AND
    names.type_id==TYPE.id
  )
 ) AS 'name',
 (
  SELECT types.identifier
  FROM types
  WHERE types.id==effective.target_type_id
 ) AS 'against',
 effective.damage_factor AS 'factor'
 FROM
  types AS 'type'
 JOIN language_names AS 'lang'
 JOIN type_efficacy AS 'effective'
 ON effective.damage_type_id==TYPE.id
 ORDER BY id ASC

/* Used with Veekun's databse */