EVE German type descriptions w/o linebreaks

USE EveStaticData
SELECT concat('[ #<a href=''javascript:CCPEVE.showInfo(',keyID,')''>',keyID,'</a>#,#'),
keyID,
  (SELECT typeName
   FROM EveStaticData.dbo.invTypes AS t
   WHERE t.typeID = tr.keyID) AS typeName,
       '#,#',
       languageID,
       '#,#',
       "text",
       '# ],'
FROM trnTranslations AS tr
WHERE tcID = 33
  AND languageID IN ('EN-US',
                     'DE'
                     --'FR'
                     --'RU'
                    )
  AND keyID IN
    (SELECT keyID
     FROM
       (SELECT languageID,
               keyID
        FROM trnTranslations
        WHERE "text" NOT LIKE '%' + CHAR(10) + '%'
          AND tcID = 33) AS SourceTable PIVOT (COUNT("text")
                                               FOR languageID IN (
                                                                    [EN-US],
                                                                    [DE]
                                                                    --[FR]
                                                                    --[RU]
                                                                 ))AS PivotTable
     WHERE
           [EN-US] = 0
        AND
           [DE] = 1
           --[FR] = 1
           --[RU] = 1
    )