SELECT s.tvbv, count(s.tvbv), count(d.idform) as inshe, count(f.idform) as Ipoteka, count(g.idform) as Energo, count(h.idform) as Avto, count(j.idform) as Poruka
from
(
SELECT ff.tvbv from kr_dev.form ff 
group by ff.tvbv #type order by tvbv
) s
left join kr_dev.form d on (d.tvbv=s.tvbv and d.type='Інше' and d.date4='-')
left join kr_dev.form f on (f.tvbv=s.tvbv and f.type='Іпотека' and f.date4='-')
left join kr_dev.form g on (g.tvbv=s.tvbv and g.type='Енерго' and g.date4='-')
left join kr_dev.form h on (h.tvbv=s.tvbv and h.type='Авто' and h.date4='-')
left join kr_dev.form j on (j.tvbv=s.tvbv and j.type='Порука' and j.date4='-')
group by s.tvbv order by s.tvbv;

SELECT count(distinct idform) FROM kr_dev.form;