DELETE FROM ITEM
WHERE
    STOCK_MANAGEMENT_TYPE = 1
    AND (
        NOT EXISTS (
            SELECT
                ITEM_CODE
            FROM
                STOCK
            WHERE
                ITEM.ITEM_CODE = STOCK.ITEM_CODE
        )
        OR EXISTS (
            SELECT
                ITEM_CODE
            FROM
                STOCK
            WHERE
                ITEM.ITEM_CODE = STOCK.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
        )
    );