Search

            SELECT DISTINCT
sc.ID
,sc.MODULE_ID
,sc.ITEM_ID
,sc.TITLE
,sc.TAGS
,sc.PARAM1
,sc.PARAM2
,sc.UPD
,sc.DATE_FROM
,sc.DATE_TO
,sc.URL
,sc.CUSTOM_RANK
,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y %H:%i:%s') as FULL_DATE_CHANGE
,DATE_FORMAT(sc.DATE_CHANGE, '%d.%m.%Y') as DATE_CHANGE
,sct.SEARCHABLE_CONTENT
,sc.USER_ID
,if(locate('ЧАСЫ', upper(sc.TITLE)) > 0, 1, 0) as TITLE_RANK
,scsite.URL as SITE_URL
,scsite.SITE_ID
,1 as `RANK`
				FROM
						b_search_content_text sct
						INNER JOIN b_search_content sc ON sc.ID = sct.SEARCH_CONTENT_ID
						INNER JOIN b_search_content_site scsite ON sc.ID = scsite.SEARCH_CONTENT_ID
				WHERE
					((
					EXISTS (
						SELECT 1
						FROM b_search_content_right scg
						WHERE sc.ID = scg.SEARCH_CONTENT_ID
						AND scg.GROUP_CODE = 'G2'
					)))
					AND (( (sct.searchable_content LIKE '%ЧАСЫ%') ))
				AND (
					(
scsite.SITE_ID = 's3'
AND (
	(
		(sc.DATE_FROM IS NULL)
		OR sc.DATE_FROM <= '2023-02-02 04:10:35'
	)
	AND (
		(sc.DATE_TO IS NULL)
		OR sc.DATE_TO >= '2023-02-02 04:10:35'
	)
))
					AND(
				(
sc.MODULE_ID = 'iblock'
AND sc.PARAM1 = 'aspro_max_catalog'
AND sc.PARAM2 in ('26', '28')
				))
				)
				 ORDER BY CUSTOM_RANK DESC, TITLE_RANK DESC, `RANK` DESC, sc.DATE_CHANGE DESC
LIMIT 1000000            

Кварцевые часы в каталоге