DELETE FROM ITEM AS I WHERE NOT EXISTS (SELECT ITEM_CODE FROM STOCK AS S WHERE S.ITEM_CODE = I.ITEM_CODE);
DELETE FROM ITEM AS I INNER JOIN STOCK AS S ON S.ITEM_CODE = I.ITEM_CODE WHERE I.STOCK_MANAGEMENT_TYPE = 1 AND LAST_DELIVERY_DATE < date('2023-06-01', 'localtime', '-6 months') AND ACTUAL_AMT = 0;