DELETE FROM ITEM AS I 
WHERE STOCK_MANAGEMENT_TYPE=1 AND 
(NOT EXISTS 
    (SELECT
        ITEM_CODE
    FROM
        STOCK AS S
    WHERE
        I.ITEM_CODE = S.ITEM_CODE)
OR EXISTS
    (SELECT
        ITEM_CODE
    FROM
        STOCK AS S
    WHERE
        I.ITEM_CODE = S.ITEM_CODE
    GROUP BY 
        ITEM_CODE
    HAVING
        MAX(IFNULL(LAST_DELIVERY_DATE,'2999-12-31')) <= '2022-12-01' AND SUM(ACTUAL_AMT)=0));