Кастомизация стандартного запроса к БД getTagItemsQuery() под доп.условия - Предлагаю работу

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,
	MAX(c.core_alias) AS core_alias,
	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
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 <= '2021-07-05 17:13:33')
AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2021-07-05 17:13:33')
INNER JOIN #__content_types AS ct ON ct.type_alias = m.type_alias
LEFT JOIN #__categories AS tc ON tc.id = c.core_catid
LEFT JOIN #__users AS ua ON ua.id = c.core_created_user_id
WHERE
m.tag_id IN (10,11) 
AND (c.core_catid = 0 OR tc.published = 1)
AND `c`.`core_language` IN ('en-GB', '*')
AND m.type_alias IN ('com_content.article','com_contact.contact','com_content.category','com_contact.category','com_banners.banner','com_banners.category')
AND c.core_access IN (0,1,2,3,6)
GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author
ORDER BY MAX(`c`.`core_title`) ASC