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 stock where last_delivery_date is not null and last_delivery_date < "2023-01-01" and actual_amt=0)
)