SET @date_A = '2018-09-01';
SET @date_B = '2018-09-01';


SELECT DATE(ot.in_go_np), cp.*,
IFNULL(SUM(ttn.delivery_in_out), 0) AS 'sum'
FROM orders_time ot
LEFT JOIN order_ttn_log l ON l.order_id = ot.order_id
LEFT JOIN order_ttn_contact_persons cp ON l.spd_contact_id = cp.id
LEFT JOIN order_ttn ttn ON ot.order_id = ttn.order_id
WHERE DATE(ot.in_go_np) BETWEEN @date_A AND @date_B
AND cp.active = 1
AND ttn.redelivery_type = 1
AND ttn.delivery_in_out > 1
GROUP BY cp.id
ORDER BY sum ASC