|
|
|
Обсуждение |
 |
|
|
|
|
|
Поиск
|
File: /var/www/vhosts/vidding.ru/httpdocs_ladaonline/bitrix/modules/search/classes/general/search.php Line: 169 MySQL Query Error:
SELECT
stags2.NAME
,COUNT(DISTINCT stags.SEARCH_CONTENT_ID) as CNT
,MAX(sc.DATE_CHANGE) DC_TMP
,DATE_FORMAT(MAX(sc.DATE_CHANGE), '%d.%m.%Y %H:%i:%s') as FULL_DATE_CHANGE
,DATE_FORMAT(MAX(sc.DATE_CHANGE), '%d.%m.%Y') as DATE_CHANGE
FROM b_search_tags stags2
INNER JOIN b_search_tags stags ON (stags.SEARCH_CONTENT_ID=stags2.SEARCH_CONTENT_ID and stags.SITE_ID=stags2.SITE_ID)
INNER JOIN b_search_content sc ON (stags.SEARCH_CONTENT_ID=sc.ID)
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 AND stags.SITE_ID=scsite.SITE_ID)
WHERE
stags.name in ('Авторынок России', 'спецпредложения', 'утилизация', 'АвтоВАЗ') AND
scsite.SITE_ID = 'af'
GROUP BY
stags2.NAME
HAVING
(( (sum(stags.name = 'Авторынок России')>0) AND (sum(stags.name = 'спецпредложения')>0) AND (sum(stags.name = 'утилизация')>0) AND (sum(stags.name = 'АвтоВАЗ')>0) ))
ORDER BY CNT DESC
LIMIT 20[Table 'ladaonline_db.b_search_content_group' doesn't exist]
DB query error. Please try later. |
|
| |