DELETE FROM ITEM
 WHERE ITEM_CODE IN (SELECT ITEM_CODE 
                       FROM ITEM IT
                      WHERE NOT EXISTS (SELECT ITEM_CODE
                                          FROM STOCK ST
                                         WHERE IT.ITEM_CODE = ST.ITEM_CODE
                                        )
                    )
   AND STOCK_MANAGEMENT_TYPE = 1
;



DELETE FROM ITEM
 WHERE ITEM_CODE IN (SELECT ST.ITEM_CODE
                       FROM STOCK ST INNER JOIN ITEM IT
                                        ON ST.ITEM_CODE =  IT.ITEM_CODE
                      WHERE IFNULL(LAST_DELIVERY_DATE,'2023-06-01') <= DATE('2023-06-01', '-6 months')
                        AND IT.STOCK_MANAGEMENT_TYPE = 1
                    )
   AND STOCK_MANAGEMENT_TYPE = 1
;