SELECT TOP(6)
    company.name,
    company.description,
    company.address
WHERE
    langid=1
ORDER BY
    company.id DESC

SELECT TOP(6)
  COALESCE(lng2.name, lng1.name)               [name],
  COALESCE(lng2.description, lng1.description) description,
  COALESCE(lng2.address , lng1.address )       address
FROM
  company lng1
  LEFT JOIN company lng2 ON
    lng1.id     = lng2.id AND
    lng1.langid = 1 AND
    lng2.langid = 2  /* your "foreign language" id, e.g. a parameter */
WHERE
  lng1.id IN (1,2,3,4,5,6)  /* or whatever */
ORDER BY
  lng1.id DESC