with t as (
    select item_code, max(coalesce(last_delivery_date, "2023-12-01")) as z
    from stock
    where actual_amt=0
    group by item_code
)
delete 
from item 
where stock_management_type=1 
and (item_code not in (select item_code from stock) or
item_code not in (select item_code from t where z < "2023-01-01")
)