Index: /temp/trunk/html/admin/products/product_class.php
===================================================================
--- /temp/trunk/html/admin/products/product_class.php	(revision 4794)
+++ /temp/trunk/html/admin/products/product_class.php	(revision 4795)
@@ -236,5 +236,5 @@
 	$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 || '|' || T2.class_id IN (SELECT class_id1 || '|' || 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 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.= ") AS T1 ";
 			
@@ -243,5 +243,5 @@
 	$sql.= "ORDER BY rank1 DESC, rank2 DESC";
 	
-	$arrList =  $objQuery->getAll($sql, array($product_id, $product_id));
+	$arrList =  $objQuery->getAll($sql, array($product_id, $product_id, $product_id));
 	
 	$objQuery->getlastquery();