SELECT pcp.cargo_zone_id,

	(SELECT SUM(tons_processed_plan)
	  FROM contract_cargo_head cch 
	  INNER JOIN shift_day_plan_vessels_cargo sdpvc ON sdpvc.contract_cargo_head_id = cch.id
	  INNER JOIN shift_day_plan_vessels sdpv ON sdpv.id = sdpvc.shift_day_plan_vessel_id
	  INNER JOIN shift_day_plan sdp ON sdp.id = sdpv.shift_day_plan_id
	  INNER JOIN plan_vessel pv ON pv.id = sdpv.plan_vessel_id AND pv.cargo_zone_id = pcp.cargo_zone_id
	 WHERE cch.cargo_id = pcp.cargo_id AND sdp.plan_date = '2016-10-05') AS day_plan 
  
FROM plan_cargo_processing pcp
INNER JOIN cargo_nomenclature cn ON cn.id = pcp.cargo_id
INNER JOIN cargo_zone cz ON cz.id = pcp.cargo_zone_id 
WHERE 1