select r.* 
		,(select max(ksm.n_res) 
		  from nrmd 
		  inner join ksm 
			 on nrmd.kmat=ksm.kmat  
		  where nrmd.tipnrm='901' and nrmd.kmatgp=ttmz.kmatgp 
			and nrmd.ntechpr=ttmz.ntechpr
		  ) mat  

		 ,(select max(nrmd.tnrm) 
		 from nrmd 
		 where nrmd.tipnrm='901' and nrmd.kmatgp=ttmz.kmatgp 
			and nrmd.ntechpr=ttmz.ntechpr
		 ) norm_rash

		,isnull((select sum(kol)
			from kumk 
			inner join kum 
				on kumk.unkum = kum.unkum and kum.god = substring((select TOP 1 GMO.GODMEC_OTC from GMO where gmo.KOBJ='00001'), 1 ,4) 
			where ksm.kmat = kumk.kmat and ksm.kskl = kumk.ceh and kumk.ceh = '11103'
		),0) kol_kum

	 ,isnull((select sum(planzp_r.kol) 
	   from planzp_r 
	   inner join planzp 
			on planzp_r.kzap = r.kzap and planzp_r.kplt = r.kplt and planzp_r.kplv = r.kplv and planzp.status in( 'P', 'B')
				and planzp.kplt = r.kplt and planzp.kplv = r.kplv and planzp.unplanzp = planzp_r.unplanzp
	   ),0) nzp

from(
select  pp.kmat, ksm.n_res, pp.ntechpr, pp.KZAP, pp.KPLT, pp.KPLV, MIN( pp.date_in) date_in, SUM( pp.PL_M) pl_m 
from pla pp
inner join ksm 
	on pp.kmat = ksm.kmat 
where pp.kplt = '502' and pp.kplv = '1' and pp.PR_IZG_F = ''  and pp.date_in between @dateP and @dateK and pp.kttop = 'Л101' 
group by pp.kmat, ksm.n_res, pp.ntechpr, pp.KZAP, pp.KPLT, pp.kplv
 ) r
 inner join ttmz 
	on r.kmat = ttmz.kmatgp and r.ntechpr = ttmz.ntechpr 
 inner join ksm 
	on TTMZ.KMATGP = KSM.KMAT 
order by r.date_in