Index: branches/version-2_4/data/class/pages/admin/total/LC_Page_Admin_Total.php
===================================================================
--- branches/version-2_4/data/class/pages/admin/total/LC_Page_Admin_Total.php	(revision 17213)
+++ branches/version-2_4/data/class/pages/admin/total/LC_Page_Admin_Total.php	(revision 17776)
@@ -684,5 +684,5 @@
         $sql.= "SUM(quantity) AS products_count, ";
         $sql.= "(price * sum(quantity)) AS total ";
-        $sql.= "FROM dtb_order_detail WHERE order_id IN (SELECT order_id FROM dtb_order WHERE $where ) ";
+        $sql.= "FROM dtb_order_detail AS T2 WHERE EXISTS (SELECT 1 FROM dtb_order AS T3 WHERE T2.order_id = T3.order_id AND $where ) ";
         $sql.= "GROUP BY product_id, product_name, product_code, price ";
         $sql.= ") AS T1 ";