DELETE FROM ITEM AS I
WHERE I.ITEM_CODE IN (
SELECT I.ITEM_CODE AS CODE
FROM ITEM AS I
LEFT JOIN STOCK AS S ON I.ITEM_CODE = S.ITEM_CODE
WHERE (S.ITEM_CODE IS NULL OR (DATE(S.LAST_DELIVERY_DATE) < DATE('2023-06-01', '-6 MONTH') AND S.LAST_DELIVERY_DATE IS NOT NULL AND S.ACTUAL_AMT = 0)) AND I.STOCK_MANAGEMENT_TYPE = 1
GROUP BY I.ITEM_CODE);