Как вывести количество материалов в блоге категорий? - Joomla 2.5: Общие вопросы

$count = '';
if ($item->query['view'] == 'category') {
	$db = JFactory::getDbo();
	$query = $db->getQuery(true);
	
	$query->select('COUNT(*)');
	$query->from('#__content');
	$query->where("`catid`= '".$item->query['id']."' AND `state` = '1'");

	$db->setQuery($query);			
	$count = ' ( '.$db->loadResult().' )';
}

switch ($item->browserNav) :
	default:
	case 0:
?><a <?php echo $class; ?>href="<?php echo $item->flink; ?>" <?php echo $title; ?>><?php echo $linktype; echo $count; ?></a>

$db = JFactory::getDbo();

$query = $db->getQuery(true);
$query->select('`id`, `parent_id`, `lft`, `rgt`');
$query->from('#__categories');
$query->where('`extension` = "com_content" AND `published` = 1 ');
$db->setQuery($query);
$cat_tmp = $db->loadAssocList() ; 

foreach($cat_tmp as $v){
	$cat[$v['id']]['id'] = $v['id'];
	$cat[$v['id']]['parent_id'] = $v['parent_id'];
	$cat[$v['id']]['lft'] = $v['lft'];
	$cat[$v['id']]['rgt'] = $v['rgt'];  
}

$db = JFactory::getDbo();
	
$count = '';

if($item->query['view'] == 'category'){
		
		$query = $db->getQuery(TRUE);  
		$query->select('`id`, `title` ');
		$query->from('#__categories as c');
		$query->where('`published` = 1 and `extension` = "com_content" and `lft` BETWEEN '.$cat[$item->query['id']]['lft'].' AND '.$cat[$item->query['id']]['rgt'].' ');	
		$db->setQuery($query);
		$res = $db->loadAssocList(); //jbdump($res);
		
		$in_value = '';
		$count_res = count($res);
		$i = 1;
		foreach($res as $v){
			if($i!=$count_res){
				$in_value .= $v['id'].',';
			}
			else{
				$in_value .= $v['id'].'';
			}
			$i++;
			
		}
			
		$where = "`state` = '1' AND `catid` IN(".$in_value.")" ;
		
	 	$query = $db->getQuery(true);
		$query->select('COUNT(`id`)');
		$query->from('#__content');
		$query->where( $where );
		$db->setQuery($query);			
		$count = ' ( '.$db->loadResult().' )';

}

$count = '';

if($item->query['view'] == 'category'){
	
	$count = JCategories::getInstance('Content', array('countItems'=>true))->get($item->query['id'])->getNumItems(true);

}

defined('_JEXEC') or die;