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
    where
        (S.wh_code is null
        or (S.last_delivery_date <= DATE('2023-06-01', '-6 month') and S.actual_amt = 0 and S.last_delivery_date is not null))
        and I.stock_management_type = 1
)