SET @date_A = '2018-11-01';
SET @date_B = '2018-11-25';

SELECT o.id, o.date_create,os.what, od.`name`, SUM(kp.amount), bu.`name` manager_name
FROM orders o
LEFT JOIN order_delivery od on o.order_delivery_id = od.id
LEFT JOIN order_status os on o.order_status_id = os.id
LEFT JOIN fin.kassa_prihod kp on o.id = kp.order_id
LEFT JOIN backend_users bu ON o.manager_id = bu.id
WHERE o.date_create BETWEEN @date_A AND @date_B
GROUP BY o.id
ORDER BY o.id DESC
-- AND 'name'='самовывоз'