delete from
            item
        where
        STOCK_MANAGEMENT_TYPE = 1
        and(
                ITEM_CODE not in(
                    select
                        ITEM_CODE
                    from
                        STOCK
                )
            )
            or (
                ITEM_CODE = (
                    select
                        ITEM_CODE
                    from
                        STOCK
                    group by
                        STOCK.ITEM_CODE
                    having
                        max(coalesce(LAST_DELIVERY_DATE, '2023-06-01')) < date('2023-06-01', '-6 month')
                        and sum(ACTUAL_AMT) = 0
                )
            )