ON(a.id=b.id and b.alias like '%.%' and length(b.alias)<length(a.alias) and b.type!='homonyme')
set a.flags=CONCAT(a.flags,',bestalias')
where a.alias LIKE '%.%' and b.alias IS NULL and a.type!='homonyme';
ON(a.id=b.id and b.alias like '%.%' and length(b.alias)<length(a.alias) and b.type!='homonyme')
set a.flags=CONCAT(a.flags,',bestalias')
where a.alias LIKE '%.%' and b.alias IS NULL and a.type!='homonyme';