delete from ITEM
where ITEM_CODE in
(
select I.ITEM_CODE
from ITEM as I
LEFT OUTER JOIN STOCK as S
ON I.ITEM_CODE = S.ITEM_CODE
where
S.ITEM_CODE is null
);

delete from ITEM
where ITEM_CODE in
(
select I.ITEM_CODE
from ITEM as I, STOCK as S
where
I.ITEM_CODE = S.ITEM_CODE
and I.STOCK_MANAGEMENT_TYPE = '1'
and (
(S.LAST_DELIVERY_DATE <= date('2023-06-01','-6 months') and S.ACTUAL_AMT = 0)
or
(S.LAST_DELIVERY_DATE is null and S.ACTUAL_AMT = 0)
)
);