SELECT * FROM admitad_logs WHERE order_id IN ( SELECT o.id
     , md5(o.id) AS admitad_id
     , os.what   AS status
     , op.name
     , main.total_sum
     , o.date_create
     , o.comment
     , o.customer_id
     , od.name   AS delivery
     , o.source
FROM orders o
       LEFT JOIN order_status os ON o.order_status_id = os.id
       LEFT JOIN order_delivery od ON o.order_delivery_id = od.id
       LEFT JOIN order_payment op ON op.id = o.payment
       LEFT JOIN (
  SELECT
    -- Сумма доставки
      o.delivery_cost
      -- Сумма товаров (присутствующих в момент оформления)
      + IFNULL((
                 SELECT SUM(-- retail_price - сумма товара на момент оформления заказа (без скидки)
                          -- count - штук, на "сейчас"
                              inner_op.retail_price * inner_op.count)
                 FROM order_cars inner_oc
                        LEFT JOIN order_product inner_op ON inner_oc.id = inner_op.car_id
                   -- Косвенный признак, что товар присутствовал в момент оформления заказа
                   AND inner_op.manager_id IS NULL
                 WHERE inner_oc.order_id = o.id
               ), 0) AS total_sum, o.id
  FROM orders o
) main ON main.id = o.id
WHERE 1 = 1
  #   AND o.source = 'admitad'
  #   AND o.comment = 'тест'
  #   AND o.date_create BETWEEN '2019-03-01' AND '2019-05-17 16:00:00'
  AND md5(o.id) IN (
                   '80873425c6b082c2f20099754c13327b'
                  ,'024573ab06684d65c2abec1a0ed8a3e9'
                  ,'53a29de162c866eb366455b05df58dbd'
                  ,'0265ce474ec25542986bc06de14e6c05'
                  ,'1485c42956167af2907a3c195556e340'
                  ,'3162c16784d36b4fda4b42fc1591851e'
                  ,'3670b4be74932a7e8dc190503de93cf7'
                  ,'0e578817d7260edc7a73ed4e5f4bfa56'
                  ,'27f79cb2f72c8ba4d4853708522aa811'
                  ,'530a1c7a1cf4d2a624d8931ad3089863'
                  ,'61884deb916d8ada9fa2600d3584513d'
                  ,'46a086e06492e897f6cb26b1b2c02ab1'
                  ,'ae7aaa12c2fb597d844331811a51c3d3'
                  ,'949c7e6fc4bb40ba6dbf8367fc1af2af'
  ))