Поради покупцям

					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