Changeset 20959 for branches/version-2_11-dev/data/class/helper/SC_Helper_Purchase.php

Timestamp:

2011/05/26 16:44:29 (12 years ago)

Author:

Seasoft

Message:

#1294 (ソースを読みやすくする)

• 無意を持たない定数値を抽象記述  http://dev.mysql.com/doc/refman/5.1/ja/exists-and-not-exists-subqueries.html

File:

• branches/version-2_11-dev/data/class/helper/SC_Helper_Purchase.php (modified) (1 diff)

branches/version-2_11-dev/data/class/helper/SC_Helper_Purchase.php

@@ -911 +911 @@
 
             CASE WHEN EXISTS(
-                    SELECT 1 FROM dtb_products
+                    SELECT * FROM dtb_products
                      WHERE product_id = T3.product_id
                        AND del_flg = 0