DELETE 
FROM ITEM
where 
    STOCK_MANAGEMENT_TYPE = 1
AND (
    NOT EXISTS (
        SELECT
            ITEM_CODE
        FROM 
            STOCK
        WHERE
            STOCK.ITEM_CODE = ITEM.ITEM_CODE
    )
    OR EXISTS (
        SELECT
            ITEM_CODE
        FROM
            STOCK
        WHERE
            STOCK.ITEM_CODE = ITEM.ITEM_CODE
        GROUP BY
            ITEM_CODE
        HAVING
            MAX(IFNULL(LAST_DELIVERY_DATE, '2999-12-31')) <= DATE('2023-06-01', '-6 months')
            AND SUM(ACTUAL_AMT) = 0
    )
);