Just tested again without the products_ordered in admin and it did NOT delete the products_ordered this time so yes confirmed that is the issue.