SQL=SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
FROM `#__contentitem_tag_map` AS `m`
INNER JOIN `#__tags` AS `t` ON `tag_id` = t.id
INNER JOIN `#__ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id`
WHERE `t`.`access` IN (1,1) AND `t`.`published` = 1 AND `tag_date` > DATE_ADD('2024-10-05 05:25:05', INTERVAL -1 MONTH) AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2024-10-05 05:25:05') AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR `c`.`core_publish_down` >= '2024-10-05 05:25:05')
GROUP BY `tag_id`,`title`,`access`,`alias`
ORDER BY `count` DESC LIMIT 15
