SELECT s.sku_id AS sku_id,
      SUM(ma.qty) AS qty,
      ma.status AS status,
      ma.lot AS lot,
      ma.marker AS mrk
    FROM activity_log ma,
    (SELECT
        MAX(op_time) AS op_time,
        to_load,
        inc_id
    FROM
    (SELECT ma.op_time,
      ma.op_type_name,
      ma.to_load,
      ma.inc_id
    FROM activity_log ma,

    (SELECT
      i.id AS inc_id,
      ma.to_load,
      ma.op_type_name
    FROM activity_log ma,
      orders o,
      incomings i,
      sku s
    WHERE  ma.order_id = o.id
     AND ma.inc_id = i.id
     AND ma.sku_id = s.id
     AND ma.op_type_name IN (
        'mls_receive_carton',
        'mls_change_load_status',
        'mls_receive_pallet',
        'mls_counting_load_lost',
        'mls_load_shipped',
        'mls_counting_load_lost',
        'mls_counting_load_found',
        'mls_load_correct',
        'mls_load_delete',
        'mls_counting_load_changed')
    AND o.sdid = '%ДокРасход%') tbl_Temp1
    WHERE
        ma.inc_id = tbl_Temp1.inc_id
        AND ma.to_load = tbl_Temp1.to_load
        AND ma.order_id = 0)
    WHERE NOT op_type_name = 'mls_load_change_category'
    GROUP BY  to_load, inc_id) tbl_Temp2,
    sku s
    WHERE
        ma.op_time = tbl_Temp2.op_time
        AND ma.to_load = tbl_Temp2.to_load
        AND ma.inc_id = tbl_Temp2.inc_id
        AND ma.sku_id = s.id
    GROUP BY
        s.sku_id,
        ma.status,
        ma.lot,
        ma.marker