问SQL查询-匹配sum结果的第一个值

EN

select product_id,
       minimum_qty,
       pop_order_num,
       cumul_qty
from  (
      select @newqty := if(@p = product_id, @qty, 0) + qty,
             (@qty < minimum_qty and @newqty >= minimum_qty) filter,
             @p := product_id as product_id,
             minimum_qty,
             pop_order_num,
             @qty := @newqty as cumul_qty
      from  (
            select   pop.product_id,
                     pop.pop_order_num,
                     pop.pop_qty - pop.pop_supplied_qty as qty,
                     p.minimum_qty
            from     pre_order_dt pop
            inner join product p on p.product_id = pop.product_id 
            order by product_id,
                     pop_order_num
            limit    10000000000
            ) as base,
            (select @qty := 0) as init
      ) as extend
 where filter