DELETE FROM ITEM
WHERE NOT ITEM_CODE IN(SELECT ITEM_CODE FROM STOCK) OR 
ITEM_CODE IN(SELECT ITEM_CODE FROM STOCK GROUP BY ITEM_CODE HAVING MIN(LAST_DELIVERY_DATE) <= '2022-12-01')
AND STOCK_MANAGEMENT_TYPE = 1;