Changeset 17776
- Timestamp:
- 2009/02/13 22:10:04 (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_4/data/class/pages/admin/total/LC_Page_Admin_Total.php
r17213 r17776 684 684 $sql.= "SUM(quantity) AS products_count, "; 685 685 $sql.= "(price * sum(quantity)) AS total "; 686 $sql.= "FROM dtb_order_detail WHERE order_id IN (SELECT order_id FROM dtb_order WHERE$where ) ";686 $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 ) "; 687 687 $sql.= "GROUP BY product_id, product_name, product_code, price "; 688 688 $sql.= ") AS T1 ";
Note: See TracChangeset
for help on using the changeset viewer.