DELETE FROM ITEM
WHERE STOCK_MANAGEMENT_TYPE = 1
AND NOT EXISTS(
  SELECT 1 FROM STOCK WHERE ITEM.ITEM_CODE = STOCK.ITEM_CODE AND (LAST_DELIVERY_DATE > '2023-01-01' OR ACTUAL_AMT > 0)
)