File: H:\OSPanel\domains\stanki.loc\public\bitrix\modules\search\classes\general\search.php
Line: 242
MySQL Query Error: SEL ECT DISTINCT sc.ID ,sc.MODULE_ID ,sc.ITEM_ID ,sc.TITLE ,sc.TAGS ,sc.BODY ,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 FR OM 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 WH ERE ((1=1)) AND (( (sct.searchable_content LIKE '%КРО%') )) AND ( ( scsite.SITE_ID = 's1' AND ( ( (sc.DATE_FROM IS NULL) OR sc.DATE_FROM <= '2020-02-18 16:21:46' ) AND ( (sc.DATE_TO IS NULL) OR sc.DATE_TO >= '2020-02-18 16:21:46' ) )) AND( ( sc.MODULE_ID = 'main' AND ((sc.URL LIKE '/%') OR (scsite.URL LIKE '/%'))) OR( sc.MODULE_ID = 'iblock' AND sc.PARAM1 = 'tsv_corp_catalog') OR( sc.MODULE_ID = 'iblock' AND sc.PARAM1 = 'tsv_corp_content' )) ) ORDER BY CUSTOM_RANK DESC, TITLE_RANK DESC, RANK DESC, sc.DATE_CHANGE DESC LIMIT 500[[1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RANK FR OM b_search_content_text sct INNER JOIN b_search_c' at line 22]