delete from ITEM where
ITEM_CODE in (
select
    TBL1.ITEM_CODE
from
    STOCK as TBL1
INNER join
    ITEM as TBL2 on TBL1.ITEM_CODE = TBL2.ITEM_CODE
where
    STOCK_MANAGEMENT_TYPE = 1 and TBL1.ACTUAL_AMT = 0 and ifnull(LAST_DELIVERY_DATE,'2023-06-01') < date('2023-06-01', 'localtime', '-6 month'))