delete from
    ITEM
where
    item_code in(
        select
            item_code
        from
            stock
        where
            ACTUAL_AMT = 0
        group by
            item_code
        having
            max(ifnull(LAST_DELIVERY_DATE, '2023-06-30')) < date('2023-06-01', '-6 months')
    )
    and STOCK_MANAGEMENT_TYPE = 1;

delete from
    item
where
    item_code not in(
        select
            distinct item_code
        from
            stock
    )
    and STOCK_MANAGEMENT_TYPE = 1;