delete from tmp_a;

insert into tmp_a
select bizal.kod, bizal.mennyiseg, bizal.ertek, bizal.hmennyiseg,
bizal.hertek, bizal.id, bizfo.datum, mozgas.keszletmod, mozgas.nev
from bizal
left join bizfo on (bizal.kod = bizfo.kod)
left join mozgas on (mozgas.kod = bizfo.mozgas)
where cikk = 1722
order by
cikk, bizfo.datum desc, mozgas.keszletmod desc, bizfo.kod desc;

select * from tmp_a;