DELETE FROM ITEM 
WHERE
	(
		NOT EXISTS(SELECT 1 FROM STOCK WHERE ITEM_CODE  = ITEM.ITEM_CODE)
		OR
		EXISTS(
			SELECT 1 
			FROM 
				(
					SELECT
						ITEM_CODE,
						MAX(ifnull(LAST_DELIVERY_DATE,'2023-06-01')) maxday,
						SUM(ACTUAL_AMT) sumamt
					FROM
						STOCK
					GROUP BY 
						ITEM_CODE
				)wk
			WHERE
				wk.ITEM_CODE  = ITEM.ITEM_CODE AND
				DATE(maxday) <= DATE('2023-06-01','-6 months') AND
				sumamt= 0
		)
	) AND
	STOCK_MANAGEMENT_TYPE = 1
;