DELETE FROM ITEM
WHERE
	ITEM_CODE IN (
		SELECT
			ITEM.ITEM_CODE
		FROM
			ITEM
				LEFT OUTER JOIN STOCK
					ON	ITEM.ITEM_CODE = STOCK.ITEM_CODE
					AND	STOCK.ITEM_CODE IS NULL
		WHERE
			ITEM.STOCK_MANAGEMENT_TYPE = 1
	)
OR
	ITEM_CODE IN (
		SELECT
			ITEM.ITEM_CODE
		FROM
			ITEM
				INNER JOIN (
					SELECT
						ITEM_CODE
					FROM
						STOCK
					GROUP BY
						ITEM_CODE
					HAVING MAX(LAST_DELIVERY_DATE) <= '2022-12-31'
				) AS STOCK
		WHERE
			ITEM.ITEM_CODE = STOCK.ITEM_CODE
		AND ITEM.STOCK_MANAGEMENT_TYPE = 1
	)