Index: include/process_product.php
diff -u include/process_product.php:1.46.2.4 include/process_product.php:1.46.2.5
--- include/process_product.php:1.46.2.4	Fri Jun 20 16:33:51 2008
+++ include/process_product.php	Mon Oct  6 16:52:18 2008
@@ -199,7 +199,7 @@
 		if (is_array($products)) {
 			foreach ($products as $k=>$v) {
 				$products[$k]["price"] = func_query_first_cell("SELECT MIN(price) FROM $sql_tbl[pricing] WHERE productid='$v[productid]' AND quantity='1' AND membershipid = '0' AND $sql_tbl[pricing].variantid = '0'");
-				$products[$k]["category"] = func_query_first_cell("SELECT IF($sql_tbl[categories_lng].category != '', $sql_tbl[categories_lng].category, $sql_tbl[categories].category) as category FROM $sql_tbl[categories], $sql_tbl[products_categories] LEFT JOIN $sql_tbl[categories_lng] ON $sql_tbl[categories].categoryid = $sql_tbl[categories_lng].categoryid AND $sql_tbl[categories_lng].code = '".$current_language."' WHERE $sql_tbl[products_categories].productid = '".$v["productid"]."' AND $sql_tbl[products_categories].categoryid = $sql_tbl[categories].categoryid AND $sql_tbl[products_categories].main = 'Y'");
+				$products[$k]["category"] = func_query_first_cell("SELECT IF($sql_tbl[categories_lng].category != '', $sql_tbl[categories_lng].category, $sql_tbl[categories].category) as category FROM ($sql_tbl[categories], $sql_tbl[products_categories]) LEFT JOIN $sql_tbl[categories_lng] ON $sql_tbl[categories].categoryid = $sql_tbl[categories_lng].categoryid AND $sql_tbl[categories_lng].code = '".$current_language."' WHERE $sql_tbl[products_categories].productid = '".$v["productid"]."' AND $sql_tbl[products_categories].categoryid = $sql_tbl[categories].categoryid AND $sql_tbl[products_categories].main = 'Y'");
 			}
 
 			$smarty->assign("products", $products);