File: /var/www/evas/data/www/evas-auto.ru/bitrix/modules/statistic/classes/mysql/searcher.php
Line: 184
MySQL Query Error: SELECT S.ID, S.TOTAL_HITS, S.USER_AGENT, S.DIAGRAM_DEFAULT, DATE_FORMAT(max(D.DATE_LAST), '%d.%m.%Y %H:%i:%s') DATE_LAST, max(ifnull(D.DATE_LAST,'1980-01-01')) S_DATE_LAST, sum(ifnull(D.TOTAL_HITS,0))+ifnull(S.TOTAL_HITS,0) TOTAL_HITS, sum(if(to_days(curdate())=to_days(D.DATE_STAT),ifnull(D.TOTAL_HITS,0),0)) TODAY_HITS, sum(if(to_days(curdate())-to_days(D.DATE_STAT)=1,ifnull(D.TOTAL_HITS,0),0)) YESTERDAY_HITS, sum(if(to_days(curdate())-to_days(D.DATE_STAT)=2,ifnull(D.TOTAL_HITS,0),0)) B_YESTERDAY_HITS, 0 PERIOD_HITS, S.NAME FROM b_stat_searcher S LEFT JOIN b_stat_searcher_day D ON (D.SEARCHER_ID = S.ID) WHERE (1=1 AND ( S.ID <> 1 ) ) and S.ID<>1 GROUP BY S.ID HAVING '1'='1' ORDER BY TODAY_HITS desc, YESTERDAY_HITS desc, B_YESTERDAY_HITS desc, TOTAL_HITS desc, PERIOD_HITS desc LIMIT 500 [Duplicate entry '117' for key 'group_key']

DB query error.
Please try later.