UPDATE torrents SET language='nb' WHERE language='nb-no';
UPDATE torrents SET language='nl' WHERE language='nl-nl';
UPDATE torrents SET language='en' WHERE language='en-us';
UPDATE torrents SET language='fr' WHERE language='fr-fr';
UPDATE torrents SET language='pt' WHERE language='pt-pt';
UPDATE torrents SET language='ro' WHERE language='ro-ro';
UPDATE torrents SET language='hu' WHERE language='hu-hu';
UPDATE torrents SET language='is' WHERE language='is-is';
UPDATE torrents SET language='ru' WHERE language='ru-ru';
UPDATE torrents SET language='th' WHERE language='th-th';
UPDATE torrents SET language='zh-Hant' WHERE language='zh-tw';
UPDATE torrents SET language='it' WHERE language='it-it';
UPDATE torrents SET language='pt' WHERE language='pt-br';
UPDATE torrents SET language='es' WHERE language='es-es';
UPDATE torrents SET language='ja' WHERE language='ja-jp';
UPDATE torrents SET language='ko' WHERE language='ko-kr';
UPDATE torrents SET language='sv' WHERE language='sv-se';
UPDATE torrents SET language='zh' WHERE language='zh-cn';
UPDATE torrents SET language='ca' WHERE language='ca-es';
UPDATE torrents SET language='de' WHERE language='de-de';