UPDATE mennyisegi_egyseg SET nav_code = 'PIECE' WHERE (lower(lang_0000040e) = 'db') AND (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'KILOGRAM' WHERE (lower(lang_0000040e) = 'kg') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'TON' WHERE (lower(lang_0000040e) = 't') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'KWH' WHERE (lower(lang_0000040e) = 'kwh') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'DAY' WHERE (lower(lang_0000040e) = 'nap') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'HOUR' WHERE (lower(lang_0000040e) = 'h') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'HOUR' WHERE (lower(lang_0000040e) = 'óra') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'MINUTE' WHERE (lower(lang_0000040e) = 'perc') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'MINUTE' WHERE (lower(lang_0000040e) = 'min') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'MONTH' WHERE (lower(lang_0000040e) = 'hó') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'LITER' WHERE (lower(lang_0000040e) = 'l') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'KILOMETER' WHERE (lower(lang_0000040e) = 'km') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'CUBIC_METER' WHERE (lower(lang_0000040e) = 'm3') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'METER' WHERE (lower(lang_0000040e) = 'm') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'LINEAR_METER' WHERE (lower(lang_0000040e) = 'fm') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'CARTON' WHERE (lower(lang_0000040e) = 'dob') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'PACK' WHERE (lower(lang_0000040e) = 'cs') and (nav_code is null);
UPDATE mennyisegi_egyseg SET nav_code = 'OWN' WHERE (nav_code is null);