File: /var/www/madambrosh/data/www/madambrosh.ru/bitrix/modules/statistic/classes/mysql/traffic.php
Line: 423
MySQL Query Error:
SELECT
sum(HITS) TOTAL_HITS,
sum(if(to_days(curdate())=to_days(DATE_STAT),HITS,0)) TODAY_HITS,
sum(if(to_days(curdate())-to_days(DATE_STAT)=1,HITS,0)) YESTERDAY_HITS,
sum(if(to_days(curdate())-to_days(DATE_STAT)=2,HITS,0)) B_YESTERDAY_HITS,
sum(SESSIONS) TOTAL_SESSIONS,
sum(if(to_days(curdate())=to_days(DATE_STAT),SESSIONS,0)) TODAY_SESSIONS,
sum(if(to_days(curdate())-to_days(DATE_STAT)=1,SESSIONS,0)) YESTERDAY_SESSIONS,
sum(if(to_days(curdate())-to_days(DATE_STAT)=2,SESSIONS,0)) B_YESTERDAY_SESSIONS,
sum(C_EVENTS) TOTAL_EVENTS,
sum(if(to_days(curdate())=to_days(DATE_STAT),C_EVENTS,0)) TODAY_EVENTS,
sum(if(to_days(curdate())-to_days(DATE_STAT)=1,C_EVENTS,0)) YESTERDAY_EVENTS,
sum(if(to_days(curdate())-to_days(DATE_STAT)=2,C_EVENTS,0)) B_YESTERDAY_EVENTS,
sum(C_HOSTS) TOTAL_HOSTS,
sum(if(to_days(curdate())=to_days(DATE_STAT),C_HOSTS,0)) TODAY_HOSTS,
sum(if(to_days(curdate())-to_days(DATE_STAT)=1,C_HOSTS,0)) YESTERDAY_HOSTS,
sum(if(to_days(curdate())-to_days(DATE_STAT)=2,C_HOSTS,0)) B_YESTERDAY_HOSTS,
sum(NEW_GUESTS) TOTAL_GUESTS,
sum(if(to_days(curdate())=to_days(DATE_STAT),GUESTS,0)) TODAY_GUESTS,
sum(if(to_days(curdate())-to_days(DATE_STAT)=1,GUESTS,0)) YESTERDAY_GUESTS,
sum(if(to_days(curdate())-to_days(DATE_STAT)=2,GUESTS,0)) B_YESTERDAY_GUESTS,
sum(if(to_days(curdate())=to_days(DATE_STAT),NEW_GUESTS,0)) TODAY_NEW_GUESTS,
sum(if(to_days(curdate())-to_days(DATE_STAT)=1,NEW_GUESTS,0)) YESTERDAY_NEW_GUESTS,
sum(if(to_days(curdate())-to_days(DATE_STAT)=2,NEW_GUESTS,0)) B_YESTERDAY_NEW_GUESTS,
sum(FAVORITES) TOTAL_FAVORITES,
sum(if(to_days(curdate())=to_days(DATE_STAT),FAVORITES,0)) TODAY_FAVORITES,
sum(if(to_days(curdate())-to_days(DATE_STAT)=1,FAVORITES,0)) YESTERDAY_FAVORITES,
sum(if(to_days(curdate())-to_days(DATE_STAT)=2,FAVORITES,0)) B_YESTERDAY_FAVORITES
FROM
b_stat_day
WHERE
1=1
[[1053] Server shutdown in progress]
DB query error.
Please try later.
|
|