DELETE FROM ITEM
WHERE ITEM_CODE not in (
    select ITEM_CODE
    from STOCK
)
and STOCK_MANAGEMENT_TYPE=1;

DELETE FROM ITEM
WHERE ITEM_CODE in (
    select 
    ITEM_CODE
    from STOCK
    where ACTUAL_AMT=0
    GROUP BY 
    ITEM_CODE
    HAVING
    MAX(LAST_DELIVERY_DATE) IS NOT NULL
    OR MAX(LAST_DELIVERY_DATE)<=date('2023-06-01', 'localtime', '-6 month')
)
and STOCK_MANAGEMENT_TYPE=1;