Changeset 17776


Ignore:
Timestamp:
2009/02/13 22:10:04 (12 years ago)
Author:
zeniya
Message:

EC-CUBE2.4改修 #408

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_4/data/class/pages/admin/total/LC_Page_Admin_Total.php

    r17213 r17776  
    684684        $sql.= "SUM(quantity) AS products_count, "; 
    685685        $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 ) "; 
    687687        $sql.= "GROUP BY product_id, product_name, product_code, price "; 
    688688        $sql.= ") AS T1 "; 
Note: See TracChangeset for help on using the changeset viewer.