SELECT stags2.NAME ,COUNT(DISTINCT stags2.SEARCH_CONTENT_ID) as CNT ,MAX(sc.DATE_CHANGE) DC_TMP ,DATE_FORMAT(MAX(sc.DATE_CHANGE), '%d.%m.%Y %H:%i:%s') as FULL_DATE_CHANGE ,DATE_FORMAT(MAX(sc.DATE_CHANGE), '%d.%m.%Y') as DATE_CHANGE FROM b_search_tags stags2 INNER JOIN b_search_content sc ON (stags2.SEARCH_CONTENT_ID=sc.ID) INNER JOIN b_search_content_site scsite ON (sc.ID=scsite.SEARCH_CONTENT_ID AND stags2.SITE_ID=scsite.SITE_ID) WHERE (( EXISTS ( SELECT 1 FROM b_search_content_right scg WHERE sc.ID = scg.SEARCH_CONTENT_ID AND scg.GROUP_CODE = 'G2' ))) AND (1=1) AND ( ( scsite.SITE_ID = 's1' AND ( ( (sc.DATE_FROM IS NULL) OR sc.DATE_FROM <= '2022-07-07 10:28:48' ) AND ( (sc.DATE_TO IS NULL) OR sc.DATE_TO >= '2022-07-07 10:28:48' ) )) AND( ( sc.MODULE_ID = 'iblock' AND sc.PARAM1 = 'aspro_max_content' AND sc.PARAM2 = '17' )) ) GROUP BY stags2.NAME ORDER BY CNT DESC LIMIT 150