DELETE
FROM ITEM
WHERE ITEM.ITEM_CODE IN (
	SELECT
		ITEM.ITEM_CODE
	FROM ITEM
	LEFT OUTER JOIN STOCK
		ON STOCK.ITEM_CODE = ITEM.ITEM_CODE
	WHERE ITEM.STOCK_MANAGEMENT_TYPE = 1
	GROUP BY
		ITEM.ITEM_CODE
		,ITEM.ITEM_NAME
		,STOCK.ITEM_CODE
	HAVING
		STOCK.ITEM_CODE IS NULL
		OR
		(
			MAX(IFNULL(STOCK.LAST_DELIVERY_DATE, '1900-01-01')) <= DATETIME('2023-06-01', '-6 month')
			AND SUM(IFNULL(ACTUAL_AMT, 0)) = 0
		)
)
;