Вывод количествова товаров в Phoca VirtueMart Category Module - [VM2&3] Модификации и хаки

$db =& JFactory::getDBO();
$cat_id = $c->virtuemart_category_id; 
$q = 'SELECT count(j_virtuemart_products.virtuemart_product_id) AS total
FROM `j_virtuemart_products`, `j_virtuemart_product_categories`
WHERE `j_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `j_virtuemart_product_categories`.`virtuemart_category_id` = '.(int)$cat_id.'
AND `j_virtuemart_products`.`virtuemart_product_id` = `j_virtuemart_product_categories`.`virtuemart_product_id`
AND `j_virtuemart_products`.`published` = "1" ';
$db->setQuery($q);
$count = $db->loadResult();

echo  '<li class="level'.$level.''.$parent.'" style="'.strip_tags($columnstyle).'"><a href="'.$url.'" >'.$c->category_name.' ('. $count.')</a>' . "\n";