DELETE
FROM ITEM AS t0
WHERE STOCK_MANAGEMENT_TYPE = 1
	AND ( NOT EXISTS(
		SELECT 1
		FROM STOCK AS t1
		WHERE t0.ITEM_CODE = t1.ITEM_CODE
		)
	OR EXISTS(
		SELECT 1
		FROM STOCK AS t2
		WHERE t2.ACTUAL_AMT = 0
			AND (t2.LAST_DELIVERY_DATE < '2022-12-01'
				OR t2.LAST_DELIVERY_DATE IS NULL)
			AND t0.ITEM_CODE = t2.ITEM_CODE
		)
	)