File: /home/vhosts/amvnews.ru/ladaonline.ru/bitrix/modules/search/classes/general/search.php Line: 169 MySQL Query Error:
SELECT DISTINCT
sc.ID
,sc.MODULE_ID
,sc.ITEM_ID
,sc.LID
,sc.TITLE
,sc.TAGS
,sc.BODY
,sc.SEARCHABLE_CONTENT
,sc.PARAM1
,sc.PARAM2
,sc.UPD
,sc.DATE_FROM
,sc.DATE_TO
,L.DIR
,L.SERVER_NAME
,sc.URL as URL
,1 as RANK
,scsite.URL as SITE_URL
,scsite.SITE_ID
,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
FROM b_search_content sc
INNER JOIN b_search_content_group scg ON sc.ID=scg.SEARCH_CONTENT_ID AND scg.GROUP_ID IN (2)
INNER JOIN b_search_content_site scsite ON sc.ID=scsite.SEARCH_CONTENT_ID
INNER JOIN b_lang L ON scsite.SITE_ID=L.LID
INNER JOIN b_search_tags stags ON (sc.ID = stags.SEARCH_CONTENT_ID)
WHERE
(1=1) AND
scsite.SITE_ID = 'ru'
AND stags.NAME in ('тенденции','Авторынок России','выручка','лидеры','продажи')
GROUP BY
sc.ID
,L.DIR
,L.SERVER_NAME
,scsite.URL
,scsite.SITE_ID
HAVING
(( (sum(stags.name = 'тенденции')>0) AND (sum(stags.name = 'Авторынок России')>0) AND (sum(stags.name = 'выручка')>0) AND (sum(stags.name = 'лидеры')>0) AND (sum(stags.name = 'продажи')>0) ))
ORDER BY CUSTOM_RANK DESC, RANK DESC, sc.DATE_CHANGE DESC
LIMIT 500[Table './ladaonline_db/b_search_tags' is marked as crashed and should be repaired]
DB query error. Please try later. |
|
|