SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jaextmanager','com_jce','com_jch_optimize','com_joomlaupdate','com_jublog','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_redj','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

1 × SELECTMAX(`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 `jos_contentitem_tag_map` AS `m` INNERJOIN `jos_tags` AS `t` ON `tag_id` = t.id INNERJOIN `jos_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id`