delete from item
where item_code in (
select i.item_code
from item i
left join stock s on i.item_code = s.item_code and i.STOCK_MANAGEMENT_TYPE = 1
where
  s.item_code is null
  or
  (
    DATE(s.last_delivery_date,  '+6 month') >= '2023-06-01'
    and
    s.actual_amt = 0
  )
 )