Index: temp/trunk/data/conf/conf.php
===================================================================
--- temp/trunk/data/conf/conf.php	(revision 4874)
+++ temp/trunk/data/conf/conf.php	(revision 4876)
@@ -838,6 +838,6 @@
 		MIN(stock_unlimited) AS stock_unlimited_min,
 		MAX(stock_unlimited) AS stock_unlimited_max
-		FROM dtb_products_class GROUP BY product_id) AS T2
-		ON T1.product_id = T2.product_id_sub) AS T3 LEFT JOIN (SELECT rank AS category_rank, category_id AS sub_category_id FROM dtb_category) AS T4
+		FROM (SELECT * FROM (dtb_products_class GROUP BY product_id) AS T2
+		ON T1.product_id = T2.product_id_sub)) AS T3 LEFT JOIN (SELECT rank AS category_rank, category_id AS sub_category_id FROM dtb_category) AS T4
 		ON T3.category_id = T4.sub_category_id) vw_products_allclass_detail ',