Как возле названия категории выводить количество товаров? - страница 2 - JoomShopping

    function getCatCountProducts($categiryID){
		$countProds=0;
		$db = JFactory::getDBO();    
        $query = "	SELECT 
						count(product_id) as countProd
					FROM `#__jshopping_products_to_categories` AS prod 
						LEFT JOIN `#__jshopping_products` AS pr_cat 
					USING (product_id) 
					WHERE product_publish = 1 AND category_id = ".$categiryID;
        $db->setQuery($query);
        $countProd = $db->loadResult();
        
		$cats = jShopCategoriesHelper::getSubCategories($categiryID);
		if(!empty($cats)){
			foreach($cats as $cat){
				$countProd=$countProd+jShopCategoriesHelper::getCatCountProducts($cat->category_id);
			}
		}
        return $countProd;
    }
		
    function getSubCategories($parentId) {
        $db = JFactory::getDBO();        
        $query = "SELECT category_id FROM `#__jshopping_categories`
                   WHERE category_parent_id = '".$db->escape($parentId)."'";
        $db->setQuery($query);        
        return $db->loadObjectList();
    }

(<?php echo(jShopCategoriesHelper::getCatCountProducts($curr->category_id));?>)