Delete Uncompleted Orders Older Than 7 Days

DELETE wp_wpcoorders, wp_wpcoitems FROM wp_wpcoorders LEFT JOIN wp_wpcoitems ON wp_wpcoorders.id = wp_wpcoitems.order_id WHERE wp_wpcoorders.completed = 'N' AND wp_wpcoorders.modified < DATE_SUB(NOW(), INTERVAL 7 DAY) AND wp_wpcoitems.completed = 'N';

DELETE wp_wpcoorders FROM wp_wpcoorders WHERE wp_wpcoorders.completed = 'N' AND wp_wpcoorders.modified < DATE_SUB(NOW(), INTERVAL 7 DAY);