Line: 242
MySQL Query Error: SELECT 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 ,sc.USER_ID ,scsite.URL as SITE_URL ,scsite.SITE_ID ,stt.RANK as RANK FROM b_search_content sc INNER JOIN b_search_content_site scsite ON sc.ID=scsite.SEARCH_CONTENT_ID INNER JOIN ( select search_content_id, max(st.TF) TF, if(STDDEV(st.PS)-0.5 between -0.000001 and 1, 1/STDDEV(st.PS), 0) + sum(st.TF/sf.FREQ) as RANK from b_search_content_stem st, b_search_content_freq sf where st.language_id = 'ru' and st.stem = sf.stem and sf.language_id = st.language_id and st.stem in (987, 9380) and sf.SITE_ID = 's1' group by st.search_content_id having (( (sum(st.stem = 987)>0) AND (sum(st.stem = 9380)>0) )) ) stt ON sc.id = stt.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 ( ( scsite.SITE_ID = 's1' AND ( ( (sc.DATE_FROM IS NULL) OR sc.DATE_FROM <= '2026-09-15 12:59:44' ) AND ( (sc.DATE_TO IS NULL) OR sc.DATE_TO >= '2026-09-15 12:59:44' ) )) AND( ( sc.MODULE_ID = 'iblock' AND sc.PARAM1 = 'aspro_mshop_catalog' AND sc.PARAM2 = '13' )) ) ORDER BY CUSTOM_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 FROM b_search_content sc INNER JOIN b_search_content_site s' at line 20]
|