DELETE 
    I
FROM 
    ITEM AS I
INNER JOIN
    STOCK AS S
ON
    I.ITEM_CODE = S.ITEM_CODE
WHERE
    S.ITEM_CODE IS NULL
OR
    (
    TIMESTAMPDIFT(
        MONTH
        , '2023-06-01'
        , S.LAST_DELIVERY_DATE
        )
    
    AND
        S.ACTUAL_AMT = 0
    )
AND
    I.STOCK_MANAGEMENT_TYPE = 1;

SELECT * FROM ITEM;