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 IS NOT NULL AND (LAST_DELIVERY_DATE >= '2023-01-01' OR ACTUAL_AMT > 0)
)