WITH DEST_ITEM AS (
    SELECT
        ITEM.ITEM_CODE AS ITEM_CODE
    FROM ITEM
    	LEFT JOIN STOCK
    		ON ITEM.ITEM_CODE = STOCK.ITEM_CODE
    WHERE
        1=1
        AND STOCK_MANAGEMENT_TYPE = 1
        AND (
            STOCK.ITEM_CODE IS NULL
            OR (
                STOCK.LAST_DELIVERY_DATE IS NOT NULL
                AND STOCK.LAST_DELIVERY_DATE <= datetime(date('2023-06-01'), '-6 months')
        		AND STOCK.ACTUAL_AMT > 0
            )
        )
)
DELETE
FROM
    ITEM
WHERE
    ITEM_CODE IN (SELECT ITEM_CODE FROM DEST_ITEM)
;