Пункт меню "Список элементов": отобразить автора и категорию - Joomla 3.x: Шаблоны, разметка и макеты вывода

<?php foreach ($items as $i => $item) : ?>

<?php $db = JFactory::getDbo();

$db->setQuery(
	$db->getQuery(true)
		->select('hits')
		->from('#__content')
		->where('id = ' . (int) $item->content_item_id)
);

$hits = $db->loadResult();

<?php echo $hits; ?>

$db = JFactory::getDbo();
$db->setQuery(
	$db->getQuery(true)
		->select('hits')
		->from('#__content')
		->where('id = ' . (int) $item->content_item_id));
$hits = $db->loadResult();
$item->hits = $hits;

<?php $db = JFactory::getDbo();
 
$db->setQuery(
	$db->getQuery(true)
		->select('tag_id')
		->from('#__contentitem_tag_map')
		->where('COUNT('tag_id') = ' . (int) $item->content_item_id)
);
 
$countelement = $db->loadResult();

<?php echo $item->author; ?>

		if ($params->get('show_author') && !empty($this->item->author )) :
			$output .='<dd class="createdby">';
				$author =  $this->item->author;
				$author = ($this->item->created_by_alias ? $this->item->created_by_alias : $author);
				if (!empty($this->item->contactid ) &&  $params->get('link_author') == true):
					$output .= JText::sprintf('COM_CONTENT_WRITTEN_BY', JHtml::_('link', JRoute::_('index.php?option=com_contact&view=contact&id='.$this->item->contactid), $author));
				else:
					$output .= JText::sprintf('COM_CONTENT_WRITTEN_BY', $author);
				endif;
			$output .='</dd>';
		endif;

stdClass Object
(
    [type_alias] => com_content.article
    [content_item_id] => 24
    [core_content_id] => 1
    [match_count] => 1
    [tag_date] => 2015-01-29 14:28:39
    [core_title] => Joomla! Testing
    [core_alias] => Joomla
    [core_body] => Thanks for helping us to test Joomla!
    [core_state] => 1
    [core_access] => 1
    [core_metadata] => {"robots":"","author":"","rights":"","xreference":""}
    [core_created_user_id] => 913
    [core_created_by_alias] => 
    [core_created_time] => 2011-01-01 00:00:01
    [core_images] => {"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}
    [core_modified_time] => 2015-01-29 12:28:39
    [core_language] => *
    [core_catid] => 19
    [core_publish_up] => 2011-01-01 00:00:01
    [core_publish_down] => 0000-00-00 00:00:00
    [content_type_title] => Article
    [router] => ContentHelperRoute::getArticleRoute
    [author] => Super User
    [author_email] => test@test
    [link] => index.php?option=com_content&view=article&id=24:joomla
    [displayDate] => 2011-01-01 00:00:01
    [event] => stdClass Object
        (
            [afterDisplayTitle] => 
            [beforeDisplayContent] => 
            [afterDisplayContent] => 
        )

    [text] => Thanks for helping us to test Joomla!
    [core_params] => 
)

<?php foreach ($this->items as $i => $item) : ?>

<?php $db = JFactory::getDbo();
 
$db->setQuery(
	$db->getQuery(true)
		->select(COUNT('tag_id'))
		->from('#__contentitem_tag_map')
		->where('tag_id = ' . (int) $item->id)
);

$elementsCount = $db->loadResult();