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
WHERE STOCK_MANAGEMENT_TYPE = 1
AND ITEM_CODE IN
(SELECT ITEM_CODE FROM STOCK
 GROUP BY ITEM_CODE
 HAVING MAX(LAST_DELIVERY_DATE) < date('2023-06-01', 'localtime', '-6 months')
 AND MAX(ACTUAL_AMT) = 0
);