select a.a1, Sum(b.b1 * c.Q) [V_QTY], c.c1, a.a2 , b.b2,d.d1, d.d3, e.e1, c.c2, c.c3
from a
join (select id, a as c1,b as c2, count(num) Q, c as c3, d as c4
        from abc
        where a=1 and id=3723 
        group by a, b, c, d) c on a.id= h.id
left join b on b.id = c.id
left join d  on d.id= d.id
where c.a= 1 
group by select a.a1,  c.c1, a.a2 , b.b2,d.d1, d.d3 , c.c2, c.c3
order by c.c1, c.c2, b.b2