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

SELECT COUNT( b.id )
FROM jos_categories AS a
LEFT JOIN jos_content AS b ON b.catid = a.id
WHERE a.parent_id = 1

$db = JFactory::getDbo();
$query = $db->getQuery(true);

$query->select('COUNT(b.id)');
$query->from('#__categories AS a');
$query->join('LEFT', '#__content AS b ON b.catid = a.id');
$query->where('a.parent_id = 1');
$db->setQuery($query);
$count = $db->loadResult();

$categories = JCategories::getInstance('Content');

		
$options['countItems'] = true;
$categories = JCategories::getInstance('Content', $options);

foreach ($list as $item) :
echo 'Это кол-во'. $item->numitems;

<?php
  echo 'Hello, world!'; 
?>

$db = JFactory::getDbo();
$query = $db->getQuery(true);
 
$query->select('COUNT(b.id)');
$query->from('#__categories AS a');
$query->join('LEFT', '#__content AS b ON b.catid = a.id');
$query->where('a.parent_id = 1');
$db->setQuery($query);
$count = $db->loadResult();