SET @date_A = '2018-12-01';
SET @date_B = '2018-12-15';

    SELECT
        o.id orderId,
        opr.amount sumZakaz,
        ot.in_courier,
        os.what,
        kp.sumPrihod,
        SUM(op.count * op.out_price_for_1) sumProduct
    --  ed.courier_id,
    --  bu.lastname
    FROM orders o
    LEFT JOIN orders_price opr ON opr.order_id = o.id
    LEFT JOIN orders_time ot ON ot.order_id = o.id
    LEFT JOIN order_status os ON o.order_status_id = os.id
    LEFT JOIN (SELECT order_id, SUM(amount) sumPrihod FROM fin.kassa_prihod GROUP BY 1) kp ON o.id = kp.order_id
    LEFT JOIN order_cars oc ON o.id = oc.order_id
    LEFT JOIN order_product op ON oc.id = op.car_id
    -- LEFT JOIN express_delivery ed USING(order_id)
    -- LEFT JOIN backend_users bu ON ed.courier_id = bu.id
    WHERE ot.in_courier BETWEEN @date_A AND @date_B
    AND op.active = 1
		-- AND os.what='курьер выехал'
    GROUP BY o.id