SELECT
  i.itemid,
  CONCAT(l.languagetype, '-', l.languagename) AS language
FROM
  masterdb.iteminfo i
  LEFT JOIN masterdb.languagetypeinfo l ON i.languagetype = l.languagetype
WHERE
  i.itemid IN (32179576)