DELETE FROM ITEM
WHERE
    ITEM.STOCK_MANAGEMENT_TYPE = 1
    AND (
        ITEM.ITEM_CODE NOT IN (SELECT ITEM_CODE FROM STOCK)
        OR ITEM.ITEM_CODE IN (
            SELECT
                IFNULL(c.ITEM_CODE, b.ITEM_CODE) AS ITEM_CODE
            FROM
                ITEM c
            FULL OUTER JOIN
                STOCK b
            ON
                c.ITEM_CODE = b.ITEM_CODE
            GROUP BY
                IFNULL(c.ITEM_CODE, b.ITEM_CODE)
            HAVING
                TRUE
                AND SUM(b.ACTUAL_AMT) = 0
                AND (MAX(b.LAST_DELIVERY_DATE) IS NULL OR MAX(b.LAST_DELIVERY_DATE) < "2023-01-01")
        )
    )