delete
from item
where item_code in (select item.item_code
                    from item
                             left join stock on item.item_code = stock.item_code
                    where stock.item_code is null and STOCK_MANAGEMENT_TYPE=1)
;
delete from item where item_code in (select item.item_code
                                     from item
                                              inner join
                                          (select item_code,
                                                  max(coalesce(LAST_DELIVERY_DATE, '2023-06-01')) dt,
                                                  sum(ACTUAL_AMT)                                 amt
                                           from stock
                                           group by item_code) a on a.item_code = item.item_code
                                     where DATE(dt, '+6 month') <= date('2023-06-01')
                                       and amt == 0
                                       and STOCK_MANAGEMENT_TYPE = 1)
;