Delete Uncompleted Orders Older Than 14 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 14 DAY) AND wp_wpcoitems.completed = 'N';