delete from item where item.item_code in(
select
  a.item_code as a
from
 item a
 left join stock b
   on a.ITEM_CODE = b.ITEM_CODE
group by
  a.item_code
having  datetime('2023-06-01', '-6 months') >= MAX(LAST_DELIVERY_DATE)
and STOCK_MANAGEMENT_TYPE = '1'
and ACTUAL_AMT = 0
union all
select
  a.item_code as a
from
 item a
 left join stock b
   on a.ITEM_CODE = b.ITEM_CODE
where
  not exists(select * from stock s where s.item_code = a.item_code)
and
  STOCK_MANAGEMENT_TYPE = '1'
);