IP: - 93.175.194.138 - 147.161.136.92; TIME:2024-09-25 08:13:55; Вход в систему; client_id: query:SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, u.locale, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format, c.`client_type`, s.`lost_signal`, u.`theme`, s.monit_from, s.groupmarker FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.login=? AND u.password=?) IP: - 93.175.194.138 - 147.161.136.92; TIME:2024-09-25 08:13:55; Вход в систему; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 08:55:10; Вход в систему; client_id: query:SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, u.locale, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format, c.`client_type`, s.`lost_signal`, u.`theme`, s.monit_from, s.groupmarker FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.login=? AND u.password=?) IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 08:55:10; Вход в систему; client_id:53 IP: - 79.143.35.116 - 147.161.138.105; TIME:2024-09-25 09:18:39; Вход в систему; client_id: query:SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, u.locale, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format, c.`client_type`, s.`lost_signal`, u.`theme`, s.monit_from, s.groupmarker FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.login=? AND u.password=?) IP: - 79.143.35.116 - 147.161.138.105; TIME:2024-09-25 09:18:39; Вход в систему; client_id:53 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:38:16; Вход в систему; client_id: query:SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, u.locale, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format, c.`client_type`, s.`lost_signal`, u.`theme`, s.monit_from, s.groupmarker FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.login=? AND u.password=?) IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:38:16; Вход в систему; client_id:53 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:38:50; Начало создания Пробег машин в городе; client_id:53 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:38:50; Query Пробег машин в городе; Query:0 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:38:50; Query Пробег машин в городе; Query:4884 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:38:50; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '4884' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:38:55; Query Пробег машин в городе; Query:1 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:38:55; Query Пробег машин в городе; Query:2485 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:38:55; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2485' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:01; Query Пробег машин в городе; Query:2 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:01; Query Пробег машин в городе; Query:2619 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:01; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2619' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:05; Query Пробег машин в городе; Query:3 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:05; Query Пробег машин в городе; Query:2500 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:05; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2500' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:10; Query Пробег машин в городе; Query:4 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:10; Query Пробег машин в городе; Query:2453 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:10; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2453' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:10; Query Пробег машин в городе; Query:5 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:10; Query Пробег машин в городе; Query:2571 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:10; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2571' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:6 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:2578 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2578' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:7 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:2564 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2564' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:8 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:2850 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2850' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:9 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:2867 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2867' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:10 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:2876 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:11; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2876' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:19; Query Пробег машин в городе; Query:11 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:19; Query Пробег машин в городе; Query:2898 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:19; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2898' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:28; Query Пробег машин в городе; Query:12 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:28; Query Пробег машин в городе; Query:2915 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:28; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2915' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:28; Query Пробег машин в городе; Query:13 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:28; Query Пробег машин в городе; Query:2939 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:28; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2939' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:28; Query Пробег машин в городе; Query:14 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:28; Query Пробег машин в городе; Query:3032 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:28; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '3032' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:28; Query Пробег машин в городе; Query:15 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:28; Query Пробег машин в городе; Query:3057 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:28; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '3057' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:34; Query Пробег машин в городе; Query:16 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:34; Query Пробег машин в городе; Query:3071 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:34; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '3071' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:37; Query Пробег машин в городе; Query:17 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:37; Query Пробег машин в городе; Query:3088 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:37; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '3088' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:38; Query Пробег машин в городе; Query:18 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:38; Query Пробег машин в городе; Query:3100 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:38; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '3100' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:44; Query Пробег машин в городе; Query:19 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:44; Query Пробег машин в городе; Query:3165 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:44; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '3165' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:44; Query Пробег машин в городе; Query:20 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:44; Query Пробег машин в городе; Query:3172 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:44; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '3172' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:50; Query Пробег машин в городе; Query:21 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:50; Query Пробег машин в городе; Query:3188 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:50; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '3188' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:53; Query Пробег машин в городе; Query:22 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:53; Query Пробег машин в городе; Query:3197 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:53; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '3197' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:57; Query Пробег машин в городе; Query:23 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:57; Query Пробег машин в городе; Query:2817 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:57; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2817' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:57; Query Пробег машин в городе; Query:24 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:57; Query Пробег машин в городе; Query:2475 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:57; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2475' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:57; Query Пробег машин в городе; Query:25 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:57; Query Пробег машин в городе; Query:3162 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:39:57; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '3162' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:06; Query Пробег машин в городе; Query:26 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:06; Query Пробег машин в городе; Query:353173060485131 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:06; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '353173060485131' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:08; Query Пробег машин в городе; Query:27 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:08; Query Пробег машин в городе; Query:2790 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:08; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2790' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:12; Query Пробег машин в городе; Query:28 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:12; Query Пробег машин в городе; Query:2677 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:12; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '2677' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:18; Query Пробег машин в городе; Query:29 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:18; Query Пробег машин в городе; Query:353173060512918 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:18; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '353173060512918' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:18; Query Пробег машин в городе; Query:30 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:18; Query Пробег машин в городе; Query:355234055170423 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:18; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '355234055170423' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:20; Query Пробег машин в городе; Query:31 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:20; Query Пробег машин в городе; Query:355234055575019 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:20; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '355234055575019' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:20; Query Пробег машин в городе; Query:32 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:20; Query Пробег машин в городе; Query:354836080392292 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:20; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '354836080392292' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:24; Query Пробег машин в городе; Query:33 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:24; Query Пробег машин в городе; Query:354836080314031 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:24; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '354836080314031' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:27; Query Пробег машин в городе; Query:34 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:27; Query Пробег машин в городе; Query:354836080357964 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:27; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '354836080357964' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:29; Query Пробег машин в городе; Query:35 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:29; Query Пробег машин в городе; Query:354836080405763 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:29; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '354836080405763' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:32; Query Пробег машин в городе; Query:36 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:32; Query Пробег машин в городе; Query:352353083494887 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:32; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '352353083494887' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:32; Query Пробег машин в городе; Query:37 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:32; Query Пробег машин в городе; Query:352353084102240 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:32; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '352353084102240' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:35; Query Пробег машин в городе; Query:38 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:35; Query Пробег машин в городе; Query:352353084149035 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:35; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '352353084149035' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:37; Query Пробег машин в городе; Query:39 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:37; Query Пробег машин в городе; Query:352353085039615 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:37; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '352353085039615' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:38; Query Пробег машин в городе; Query:40 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:38; Query Пробег машин в городе; Query:352353086157176 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:38; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '352353086157176' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:40; Query Пробег машин в городе; Query:41 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:40; Query Пробег машин в городе; Query:862531041072803 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:40; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '862531041072803' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:40; Query Пробег машин в городе; Query:42 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:40; Query Пробег машин в городе; Query:356078111471005 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:40; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '356078111471005' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:40; Query Пробег машин в городе; Query:43 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:40; Query Пробег машин в городе; Query:356078111451585 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:40; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '356078111451585' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:42; Query Пробег машин в городе; Query:44 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:42; Query Пробег машин в городе; Query:356078118085444 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:42; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '356078118085444' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:43; Query Пробег машин в городе; Query:45 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:43; Query Пробег машин в городе; Query: IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:43; Query Пробег машин в городе; Query:SELECT DATE(ADDTIME(`time`,'0 3:0:0')) AS `date`, `DeviceLoginName`, ADDTIME(MIN(`time`),'0 3:0:0') AS `startdate`, ADDTIME(MAX(`time`),'0 3:0:0') AS `enddate`, MAX(speed), `max_speed`, SUM(`Distance`), `speeding`, DAYOFMONTH(ADDTIME(`time`,'0 3:0:0')) AS `day`, MONTHNAME(ADDTIME(`time`,'0 3:0:0')) AS `month` FROM `tms_gpsdata_fixed` WHERE `DeviceLoginName` = '' AND `time`>='2024-08-18 21:00:00' AND `time`<='2024-09-22 20:59:59' AND (`speeding` = 0 OR `speeding` > 800) GROUP BY `month`, `day`, `max_speed` ORDER BY `startdate` ASC; IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 09:40:43; Окончание создания отчета Пробег машин в городе; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 09:48:24; Вход в систему; client_id: query:SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, u.locale, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format, c.`client_type`, s.`lost_signal`, u.`theme`, s.monit_from, s.groupmarker FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.login=? AND u.password=?) IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 09:48:24; Вход в систему; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 10:27:49; Вход в систему; client_id: query:SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, u.locale, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format, c.`client_type`, s.`lost_signal`, u.`theme`, s.monit_from, s.groupmarker FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.login=? AND u.password=?) IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 10:27:49; Вход в систему; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 10:48:46; Вход в систему; client_id: query:SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, u.locale, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format, c.`client_type`, s.`lost_signal`, u.`theme`, s.monit_from, s.groupmarker FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.login=? AND u.password=?) IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 10:48:46; Вход в систему; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 11:04:50; Вход в систему; client_id: query:SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, u.locale, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format, c.`client_type`, s.`lost_signal`, u.`theme`, s.monit_from, s.groupmarker FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.login=? AND u.password=?) IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 11:04:50; Вход в систему; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 11:07:37; Начало создания отчета по последней координате; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 11:07:37; Окончание создания отчета по последней координате; client_id:53 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 11:43:52; Вход в систему; client_id: query:SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, u.locale, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format, c.`client_type`, s.`lost_signal`, u.`theme`, s.monit_from, s.groupmarker FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.login=? AND u.password=?) IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 11:43:52; Вход в систему; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 12:21:09; Вход в систему; client_id: query:SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, u.locale, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format, c.`client_type`, s.`lost_signal`, u.`theme`, s.monit_from, s.groupmarker FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.login=? AND u.password=?) IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 12:21:09; Вход в систему; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 12:23:28; Начало создания отчета по последней координате; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 12:23:28; Окончание создания отчета по последней координате; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 13:14:41; Начало создания отчета по пробегу; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 13:14:41; Окончание создания отчета по пробегу; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 13:23:12; Начало создания отчета по последней координате; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 13:23:12; Окончание создания отчета по последней координате; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 13:23:42; Начало создания отчета по движению; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 13:23:42; Окончание создания отчета по движению; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 13:26:51; Начало создания отчета по движению; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 13:26:51; Окончание создания отчета по движению; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 14:05:05; Начало создания отчета по движению; client_id:53 IP: - 82.207.53.218 - 147.161.136.103; TIME:2024-09-25 14:05:09; Окончание создания отчета по движению; client_id:53 IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 14:22:32; Вход в систему; client_id: query:SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, u.locale, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format, c.`client_type`, s.`lost_signal`, u.`theme`, s.monit_from, s.groupmarker FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.login=? AND u.password=?) IP: - 77.93.45.223 - 147.161.136.120; TIME:2024-09-25 14:22:32; Вход в систему; client_id:53 IP: - 82.207.53.218 - 136.226.198.120; TIME:2024-09-25 15:19:12; Вход в систему; client_id: query:SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, u.locale, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format, c.`client_type`, s.`lost_signal`, u.`theme`, s.monit_from, s.groupmarker FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.login=? AND u.password=?) IP: - 82.207.53.218 - 136.226.198.120; TIME:2024-09-25 15:19:12; Вход в систему; client_id:53 IP: - - 188.163.5.65; TIME:2024-09-25 21:44:12; Вход в систему; client_id: query:SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, u.locale, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format, c.`client_type`, s.`lost_signal`, u.`theme`, s.monit_from, s.groupmarker FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.login=? AND u.password=?) IP: - - 188.163.5.65; TIME:2024-09-25 21:44:12; Вход в систему; client_id:53