Вывести количество товаров в категории, VM 2.8 - [VM2&3] Модификации и хаки

<?php // no direct access
defined('_JEXEC') or die('Restricted access');
$db = JFactory::getDbo();
?>

<?php foreach ($categories as $category) {
	} ?>

<div class="categoriesView">
	<h4><?php echo JText::_('COM_VIRTUEMART_CATEGORIES')?></h4>
    <div class="categories">
    	<?php foreach ($this->categories as $category) {
        $query = $db->getQuery(true);
        $query->select(array('COUNT(a.virtuemart_product_id)'));
        $query->from('#__virtuemart_product_categories AS a');
        $query->join('INNER', '#__virtuemart_products AS b ON (a.virtuemart_product_id = b.virtuemart_product_id)');
        $query->where("a.virtuemart_category_id=$category->virtuemart_category_id AND b.published=1");
        $db->setQuery($query);
        $count_prod = $db->loadResult();
        $caturl = JRoute::_('index.php?option=com_virtuemart&view=category&virtuemart_category_id=' . $category->virtuemart_category_id);?>
        <h2>
           <a href="<?php echo $caturl ?>" class="linkBrow" title="<?php echo $category->category_name ?>"><?php echo $category->category_name ?></a><span><?php echo $count_prod ?></span>
       </h2>
        <?php }?>
    </div>
</div>