IP: - 82.207.53.218 - 147.161.248.119; TIME:2024-11-13 10:22:00; Query_1: SELECT DATE(ADDTIME(MIN(gd.Time),'0 2:0:0')), MIN(gd.time) AS day_start_time, MAX(gd.time) AS day_finish_time, DeviceLoginName,DAYOFMONTH(gd.time) AS `day`, MONTHNAME(gd.time) AS `month` FROM `tms_gpsdata_fixed` gd WHERE gd.time >= '2024-10-31 22:00:00' AND gd.time < '2024-11-13 21:59:59' AND gd.DeviceLoginName IN ('358021081803706') AND gd.speed > 0 GROUP BY `month`, `day`, DeviceLoginName
IP: - 82.207.53.218 - 147.161.248.119; TIME:2024-11-13 10:22:01; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-11-01 05:31:55' AND DeviceLoginName ='358021081803706'
IP: - 82.207.53.218 - 147.161.248.119; TIME:2024-11-13 10:22:05; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-11-02 08:51:25' AND DeviceLoginName ='358021081803706'
IP: - 82.207.53.218 - 147.161.248.119; TIME:2024-11-13 10:22:05; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-11-03 08:24:42' AND DeviceLoginName ='358021081803706'
IP: - 82.207.53.218 - 147.161.248.119; TIME:2024-11-13 10:22:05; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-11-04 05:35:10' AND DeviceLoginName ='358021081803706'
IP: - 82.207.53.218 - 147.161.248.119; TIME:2024-11-13 10:22:05; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-11-05 05:23:26' AND DeviceLoginName ='358021081803706'
IP: - 82.207.53.218 - 147.161.248.119; TIME:2024-11-13 10:22:05; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-11-07 05:24:14' AND DeviceLoginName ='358021081803706'
IP: - 82.207.53.218 - 147.161.248.119; TIME:2024-11-13 10:22:06; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-11-08 05:35:01' AND DeviceLoginName ='358021081803706'
IP: - 82.207.53.218 - 147.161.248.119; TIME:2024-11-13 10:22:06; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-11-09 10:28:43' AND DeviceLoginName ='358021081803706'
IP: - 82.207.53.218 - 147.161.248.119; TIME:2024-11-13 10:22:06; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-11-11 05:40:32' AND DeviceLoginName ='358021081803706'
IP: - 82.207.53.218 - 147.161.248.119; TIME:2024-11-13 10:22:06; Запрос #2: SELECT `longitude`,`latitude` FROM tms_gpsdata_fixed WHERE `time`='2024-11-12 05:18:22' AND DeviceLoginName ='358021081803706'