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
    AND LAST_DELIVERY_DATE IS NOT NULL
    AND LAST_DELIVERY_DATE<=date('2023-06-01', 'localtime', '-6 month');
)
and STOCK_MANAGEMENT_TYPE=1;