File: /var/www/site/bitrix/modules/statistic/classes/mysql/searcher.php<br>Line: 165<br><font color=#ff0000>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 &lt;&gt; 1
					)
					)
		and S.ID&lt;&gt;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
		</font>[Table './bitrix/b_stat_searcher_day' is marked as crashed and should be repaired]<br>