From 09b78473fba154c8749f6cc0eda7bd046a35716c Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Wed, 28 Nov 2018 09:30:25 +0100 Subject: [PATCH] 0004760: Rerun - new last_sales_order_detail function sql very slow. Optimized by @Braathwaate. --- sales/includes/db/sales_order_db.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sales/includes/db/sales_order_db.inc b/sales/includes/db/sales_order_db.inc index 97e188aa..c918890b 100644 --- a/sales/includes/db/sales_order_db.inc +++ b/sales/includes/db/sales_order_db.inc @@ -632,7 +632,7 @@ function last_sales_order_detail($order, $field) $sql = "SELECT $field FROM ".TB_PREF."sales_order_details d WHERE order_no = - (SELECT order_no FROM 1_sales_orders o + (SELECT order_no FROM ".TB_PREF."sales_orders o WHERE debtor_no=" . db_escape($order->customer_id) . " ORDER BY order_no DESC LIMIT 1) ORDER BY d.id DESC LIMIT 1"; -- 2.30.2