    select 5 union all select 6 union all select 7 union all select 8 union all 
    select 9 union all select 10 union all select 11 union all select 12 union all 
    select 13 union all select 14 union all select 15 union all select 16 union all select 17) n
-where allikas != 'Nimekujud' and isanimi != '' ;
+where allikas != 'Nimekujud' and isanimi != ''
+  and k.MR != '!';
 
 -- 6.
 insert ignore into x_nimekujud (id, tunnus, v, moonutatud)

   select 5 union all select 6 union all select 7 union all select 8 union all 
   select 9 union all select 10 union all select 11 union all select 12 union all 
   select 13 union all select 14 union all select 15 union all select 16 union all select 17) n
where allikas != 'Nimekujud' and surm != '' ;


-- 15.

   select 5 union all select 6 union all select 7 union all select 8 union all 
   select 9 union all select 10 union all select 11 union all select 12 union all 
   select 13 union all select 14 union all select 15 union all select 16 union all select 17) n
where allikas != 'Nimekujud' and perenimi != ''
  and k.MR != '!';

-- 10.
insert ignore into x_nimekujud (id, tunnus, v, moonutatud)
