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