File: /var/www/fishingstock_usr/data/www/fishingstock.ua/bitrix/modules/search/classes/general/search.php
Line: 255
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, 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 (0, 56004)
and sf.SITE_ID = 's1'
group by st.search_content_id
having (( (sum(st.stem = 0)>0) AND (sum(st.stem = 56004)>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.MODULE_ID = 'iblock'
AND sc.PARAM1 = '1c_catalog'
AND sc.PARAM2 = '5'
))
)
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]
DB query error.
Please try later.
|
|