Переопределение вывода списка материалов по меткам в com_tags - Joomla 3.x: Установка, обновление и настройка

com_tags в Joomla 3.x

. ', ' . 'tags.title AS tag_title'

->join('LEFT', '#__tags AS tags ON tags.id = m.tag_id')

$limit = $params->get('display_num', $app->get('list_limit', 20));

$limit = $app->getUserStateFromRequest('global.list.limit', 'limit', $limit, 'uint');

SELECT 
m.type_alias, 
m.content_item_id, 
m.core_content_id, 
count(m.tag_id) AS match_count, 
MAX(m.tag_date) as tag_date, 
MAX(c.core_title) AS core_title, 
MAX(c.core_params) AS core_params, 
tags.title AS tag_title, 
MAX(c.core_alias) AS core_alias, 
MAX(c.core_body) AS core_body, 
MAX(c.core_state) AS core_state, 
MAX(c.core_access) AS core_access,
MAX(c.core_metadata) AS core_metadata, 
MAX(c.core_created_user_id) AS core_created_user_id, 
MAX(c.core_created_by_alias) AS core_created_by_alias,
MAX(c.core_created_time) as core_created_time, 
MAX(c.core_images) as core_images,
CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,
MAX(c.core_language) AS core_language, 
MAX(c.core_catid) AS core_catid,
MAX(c.core_publish_up) AS core_publish_up, 
MAX(c.core_publish_down) as core_publish_down,
MAX(ct.type_title) AS content_type_title, 
MAX(ct.router) AS router,
CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,
ua.email AS author_email 
FROM 
#__contentitem_tag_map AS m INNER JOIN #__ucm_content AS c ON 
m.type_alias = c.core_type_alias AND 
m.core_content_id = c.core_content_id AND 
c.core_state IN (1) AND 
(c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2016-05-12 09:05:34') AND 
(c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2016-05-12 09:05:34') 
INNER JOIN #__content_types AS ct ON 
ct.type_alias = m.type_alias 
LEFT JOIN #__users AS ua ON 
ua.id = c.core_created_user_id 
LEFT JOIN #__tags AS tags ON 
tags.id = m.tag_id 
WHERE m.tag_id IN (3,4,5,6) AND 
`c`.`core_language` IN ('ru-RU', '*') AND 
m.type_alias IN ('com_content.article') AND 
c.core_access IN (0,1,5) 
GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, name, author_email ORDER BY MAX(`c`.`core_title`) ASC

->group('m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, name, author_email')
. ', ' . 'count(m.tag_id) AS match_count'

->group('m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, name, author_email')
. ', ' . 'count(m.tag_id) AS match_count'

<?php $sort_by_tag = array();
	foreach ($items as $item) {
	$sort_by_tag[$item->tag_title][] = $item;
	}
?>

<?php foreach ($sort_by_tag as $tag => $items_by_tag): ?> 
<div class="h2dev"><h2>Мероприятия на <?php echo $tag; ?></h2></div>
<ul class="category list-striped">
<?php foreach ($items_by_tag as $item): ?>

				</li> <!-- завершает вывод позиции списка в оригинальном варианте -->
		<?php endforeach; ?>
	</ul>
	<?php endforeach; ?>