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 IT.STOCK_MANAGEMENT_TYPE = 1
  GROUP BY ST.ITEM_CODE
                        HAVING MAX(IFNULL(LAST_DELIVERY_DATE,'2023-06-01')) <= DATE('2023-06-01', '-6 months')
                               AND SUM(ACTUAL_AMT) = 0
                    )
   AND STOCK_MANAGEMENT_TYPE = 1
;