select r.rep_d, 
		count(r.nl) as raz, 
		count(d.nl) as dva, 
	 	count(l.nl) as tri, 
		count(p.nl) as chetire 
from raz r left outer join pdp d on d.nl = r.nl 
                  left outer join ppl l on ( l.nl = r.nl and isnull(l.dto,  0 ) >  0  ) 
                  left outer join ppc p on ( p.nl = r.nl and isnull(p.pp,  0 ) >  0  ) 
where ( date(r.rep_d) between :dt1 and :dt2 ) 
group by r.rep_d;