Delete old OpenCart orders

oc_delete_orders.sql

DELETE `or`, ort FROM `order_recurring` `or`, `order_recurring_transaction` `ort` WHERE order_id IN (SELECT order_id FROM `order` where order_id < 14000) AND ort.order_recurring_id = `or`.order_recurring_id;
DELETE FROM `order_product` WHERE order_id IN (SELECT order_id FROM `order` where order_id < 14000);
DELETE FROM `order_option` WHERE order_id IN (SELECT order_id FROM `order` where order_id < 14000);
DELETE FROM `order_voucher` WHERE order_id IN (SELECT order_id FROM `order` where order_id < 14000);
DELETE FROM `order_total` WHERE order_id IN (SELECT order_id FROM `order` where order_id < 14000);
DELETE FROM `order_history` WHERE order_id IN (SELECT order_id FROM `order` where order_id < 14000);
DELETE FROM `affiliate_transaction` WHERE order_id IN (SELECT order_id FROM `order` where order_id < 14000);
DELETE FROM `order` WHERE order_id < 14000;
DELETE FROM `sbacquiring` WHERE num_order < 14000; -- optional

OPTIMIZE TABLE `order`;
OPTIMIZE TABLE `order_product`;
OPTIMIZE TABLE `order_option`;
OPTIMIZE TABLE `order_history`;