File: /var/www/programmplus/data/www/docexplorer.ru/bitrix/modules/statistic/classes/mysql/session.php<br>Line: 53<br><font color=#ff0000>MySQL Query Error: 
			SELECT
				sum(UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST))/count(S.ID)		AM_AVERAGE_TIME,
				sum(if(UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&lt;60,1,0))		AM_1,
				sum(if(UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&gt;=60
				and UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&lt;180,1,0))		AM_1_3,
				sum(if(UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&gt;=180
				and UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&lt;360,1,0))		AM_3_6,
				sum(if(UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&gt;=360
				and UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&lt;540,1,0))		AM_6_9,
				sum(if(UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&gt;=540
				and UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&lt;720,1,0))		AM_9_12,
				sum(if(UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&gt;=720
				and UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&lt;900,1,0))		AM_12_15,
				sum(if(UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&gt;=900
				and UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&lt;1080,1,0))		AM_15_18,
				sum(if(UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&gt;=1080
				and UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&lt;1260,1,0))		AM_18_21,
				sum(if(UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&gt;=1260
				and UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&lt;1440,1,0))		AM_21_24,
				sum(if(UNIX_TIMESTAMP(S.DATE_LAST)-UNIX_TIMESTAMP(S.DATE_FIRST)&gt;=1440,1,0))	AM_24,

				sum(S.HITS)/count(S.ID)						AH_AVERAGE_HITS,
				sum(if(S.HITS&lt;=1, 1, 0))					AH_1,
				sum(if(S.HITS&gt;=2 and S.HITS&lt;=5, 1, 0))		AH_2_5,
				sum(if(S.HITS&gt;=6 and S.HITS&lt;=9, 1, 0))		AH_6_9,
				sum(if(S.HITS&gt;=10 and S.HITS&lt;=13, 1, 0))	AH_10_13,
				sum(if(S.HITS&gt;=14 and S.HITS&lt;=17, 1, 0))	AH_14_17,
				sum(if(S.HITS&gt;=18 and S.HITS&lt;=21, 1, 0))	AH_18_21,
				sum(if(S.HITS&gt;=22 and S.HITS&lt;=25, 1, 0))	AH_22_25,
				sum(if(S.HITS&gt;=26 and S.HITS&lt;=29, 1, 0))	AH_26_29,
				sum(if(S.HITS&gt;=30 and S.HITS&lt;=33, 1, 0))	AH_30_33,
				sum(if(S.HITS&gt;=34, 1, 0))					AH_34
			FROM
				b_stat_session S
			WHERE
				S.DATE_STAT = cast('2023-04-01' as date)
			
			</font>[Table './docexplorer@002eru/b_stat_session' is marked as crashed and should be repaired]<br>