select katos.datok, katpodr.name as podrName, katos.datv, katos.nameos, vidnorma.kod, katos.innum,convert(katos.nrec, SQL_CHAR) as katnrec,
substring(katos.innum, 1 , 3 ) as Schet,
a1.stoim as a1stoim, a1.sumizn as a1sumizn, a2.stoim as a2stoim, a2.sumizn as a2sumizn,
K.innum as highinnum, aa1.izn0, aa2.izn1,aa3.izn2
 from katos
left join spkatos on katos.nrec=spkatos.ckatos
left join vidnorma on spkatos.cnorma=vidnorma.nrec
left join katpodr on katos.cpodr=katpodr.nrec
left join arciznos a1 on a1.ckatos=katos.nrec
left join arciznos a2 on a2.ckatos=katos.nrec
left join katos K on K.nrec=katos.chigheros
left join (select s1.ckatos,sum(newsumizn) as izn0 from spmoveos s1
   left join moveos M on s1.cmoveos=M.nrec
   left join klassos K1 on M.cosnov=K1.nrec
   where (M.sysoper= 5 ) and (s1.datob between '2007-01-01' and '2007-05-01' )
   group by s1.ckatos
            ) aa1 on katos.nrec=aa1.ckatos
left join (select s1.ckatos,sum(newsumizn) as izn1 from spmoveos s1
   left join moveos M on s1.cmoveos=M.nrec
   left join klassos K1 on M.cosnov=K1.nrec
   where (M.sysoper= 5 ) and (s1.datob between '2007-01-01' and '2007-05-01'  )
   group by s1.ckatos
            ) aa2 on katos.nrec=aa2.ckatos
left join (select s1.ckatos,sum(newsumizn) as izn2 from spmoveos s1
   left join moveos M on s1.cmoveos=M.nrec
   left join klassos K1 on M.cosnov=K1.nrec
   where (M.sysoper= 5 ) and (s1.datob <= '2007-05-01')
   group by s1.ckatos
            ) aa3 on katos.nrec=aa3.ckatos

where (ifnull(katos.datv,'2200-01-01') > '2007-05-01' ) and (katos.datok <= '2007-01-01' )
  and a1.data=(select Max(data) from arciznos a3 where a3.data <= '2007-01-01')
  and a2.data=(select Max(data) from arciznos a4 where a4.data <= '2007-05-01')