YAZILIM / WEB

select s.id,s.name,s.contract_time ,s.price,s.is_finish,s.price - SUM(p.price) AS taking from s LEFT JOIN p ON s.id=p.parentid WHERE isfinish != 3 and type=