Changeset 5252 for temp/trunk

Timestamp:

2006/09/20 14:33:34 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/conf/conf.php (modified) (1 diff)
• html/admin/contents/recommend_search.php (modified) (1 diff)
• html/admin/products/product_class.php (modified) (1 diff)

temp/trunk/data/conf/conf.php

@@ -765 +765 @@
         FROM (SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS classcategory_id1, T2.classcategory_id AS classcategory_id2, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2
         FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ) AS T1 LEFT JOIN dtb_products_class AS T2 
-        ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) vw_cross_products_class ',
+        ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) ',
 
     "vw_products_nonclass" => '

temp/trunk/html/admin/contents/recommend_search.php

@@ -72 +72 @@
     // Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê
     $col = "product_id, name, category_id, main_list_image, status, product_code, price01, stock, stock_unlimited";
-    $from = "vw_products_nonclass";
+    $from = "vw_products_nonclass AS noncls ";
         
     $objQuery = new SC_Query();

temp/trunk/html/admin/products/product_class.php

@@ -240 +240 @@
     $sql.= "SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS T1_classcategory_id, T2.classcategory_id AS T2_classcategory_id, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2 ";
     $sql.= "FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ";
-    $sql.= "WHERE T1.class_id IN (SELECT class_id1 FROM vw_cross_products_class WHERE product_id = ? GROUP BY class_id1, class_id2) AND T2.class_id IN (SELECT class_id2 FROM vw_cross_products_class WHERE product_id = ? GROUP BY class_id1, class_id2)";
+    $sql.= "WHERE T1.class_id IN (SELECT class_id1 FROM vw_cross_products_class AS crs_prd WHERE product_id = ? GROUP BY class_id1, class_id2) AND T2.class_id IN (SELECT class_id2 FROM vw_cross_products_class AS crs_prd WHERE product_id = ? GROUP BY class_id1, class_id2)";
     $sql.= ") AS T1 ";