File: /var/www/vhosts/oknaidveri.ru/httpdocs/bitrix/modules/search/classes/general/search.php Line: 217 MySQL Query Error: SELECT 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
,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 sc
INNER JOIN b_search_content_site scsite ON sc.ID=scsite.SEARCH_CONTENT_ID
INNER JOIN b_search_tags stags ON (sc.ID = stags.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 <= '2020-07-05 17:43:33'
)
AND (
(sc.DATE_TO IS NULL)
OR sc.DATE_TO >= '2020-07-05 17:43:33'
)
)
AND (
(
sc.MODULE_ID = 'main'
AND ((sc.URL LIKE '/%') OR (scsite.URL LIKE '/%')))
OR(
sc.MODULE_ID = 'forum')
OR(
sc.MODULE_ID = 'iblock'
AND sc.PARAM1 = 'Catalog')
OR(
sc.MODULE_ID = 'iblock'
AND sc.PARAM1 = 'Information'
AND sc.PARAM2 in ('4', '5', '18'))
)
AND stags.NAME in ('огнезащита башни останкино')
GROUP BY
sc.ID
,scsite.URL
,scsite.SITE_ID
HAVING
( (sum(stags.name = 'огнезащита башни останкино')>0) )
ORDER BY CUSTOM_RANK DESC, TITLE_RANK DESC, RANK DESC, sc.DATE_CHANGE DESC
LIMIT 500[Got error 28 from storage engine]