delete from ITEM
where STOCK_MANAGEMENT_TYPE = 1 and ITEM_CODE not in
(
select distinct ITEM_CODE
from STOCK
where LAST_DELIVERY_DATE >= "2023-01-02" or LAST_DELIVERY_DATE is null or ACTUAL_AMT > 0)