delete from ITEM
where STOCK_MANAGEMENT_TYPE = 1 and ITEM_CODE not in (
  select ITEM_CODE
  from STOCK
  where LAST_DELIVERY_DATE > DATE('2023-06-01', '-6 month') or LAST_DELIVERY_DATE is null
  group by ITEM_CODE

  union all

  select ITEM_CODE
  from STOCK
  where (
    select ACTUAL_AMT from STOCK as S where s.ITEM_CODE = STOCK.ITEM_CODE
    order by LAST_DELIVERY_DATE desc limit 1
  ) = 0
)