Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-25 7:32:39' AND e.date<='2024-11-25 21:32:39' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-25 05:32:39' AND g.time<='2024-11-25 19:32:39' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:961
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-26 5:33:23' AND e.date<='2024-11-26 7:33:23' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-26 03:33:23' AND g.time<='2024-11-26 05:33:23' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:161
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-26 5:35:27' AND e.date<='2024-11-26 7:35:27' AND e.DeviceLoginName='354836080167561' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-26 03:35:27' AND g.time<='2024-11-26 05:35:27' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:578
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-26 4:35:53' AND e.date<='2024-11-26 7:35:53' AND e.DeviceLoginName='354836080167561' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-26 02:35:53' AND g.time<='2024-11-26 05:35:53' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:735
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:36:0' AND e.date<='2024-11-18 23:36:0' AND e.DeviceLoginName='352353086605497' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-17 22:36:00' AND g.time<='2024-11-18 21:36:00' AND g.DeviceLoginName='352353086605497' GROUP BY  g.time, g.Distance;
CountAzimuth:1105
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:40:9' AND e.date<='2024-11-19 23:40:9' AND e.DeviceLoginName='352353086605497' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-18 22:40:09' AND g.time<='2024-11-19 21:40:09' AND g.DeviceLoginName='352353086605497' GROUP BY  g.time, g.Distance;
CountAzimuth:1173
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:43:4' AND e.date<='2024-11-20 23:43:4' AND e.DeviceLoginName='352353086605497' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-19 22:43:04' AND g.time<='2024-11-20 21:43:04' AND g.DeviceLoginName='352353086605497' GROUP BY  g.time, g.Distance;
CountAzimuth:1130
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-26 8:44:43' AND e.date<='2024-11-26 8:44:43' AND e.DeviceLoginName='2510' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-26 06:44:43' AND g.time<='2024-11-26 06:44:43' AND g.DeviceLoginName='2510' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-25 8:44:43' AND e.date<='2024-11-26 8:44:43' AND e.DeviceLoginName='2510' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-25 06:44:43' AND g.time<='2024-11-26 06:44:43' AND g.DeviceLoginName='2510' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:45:19' AND e.date<='2024-11-21 23:45:19' AND e.DeviceLoginName='352353083494887' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-20 22:45:19' AND g.time<='2024-11-21 21:45:19' AND g.DeviceLoginName='352353083494887' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:46:4' AND e.date<='2024-11-21 23:46:4' AND e.DeviceLoginName='352353086605497' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-20 22:46:04' AND g.time<='2024-11-21 21:46:04' AND g.DeviceLoginName='352353086605497' GROUP BY  g.time, g.Distance;
CountAzimuth:540
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 0:48:21' AND e.date<='2024-11-22 23:48:21' AND e.DeviceLoginName='352353086605497' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-21 22:48:21' AND g.time<='2024-11-22 21:48:21' AND g.DeviceLoginName='352353086605497' GROUP BY  g.time, g.Distance;
CountAzimuth:1288
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:7:2' AND e.date<='2024-11-18 23:7:2' AND e.DeviceLoginName='2519' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-17 22:07:02' AND g.time<='2024-11-18 21:07:02' AND g.DeviceLoginName='2519' GROUP BY  g.time, g.Distance;
CountAzimuth:541
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-25 14:7:22' AND e.date<='2024-11-26 9:7:22' AND e.DeviceLoginName='356078116278207' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-25 12:07:22' AND g.time<='2024-11-26 07:07:22' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:281
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-26 6:7:58' AND e.date<='2024-11-26 9:7:58' AND e.DeviceLoginName='356078116278207' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-26 04:07:58' AND g.time<='2024-11-26 07:07:58' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:146
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-25 7:8:14' AND e.date<='2024-11-25 23:8:14' AND e.DeviceLoginName='356078116278207' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-25 05:08:14' AND g.time<='2024-11-25 21:08:14' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:673
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:9:28' AND e.date<='2024-11-19 23:9:28' AND e.DeviceLoginName='2519' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-18 22:09:28' AND g.time<='2024-11-19 21:09:28' AND g.DeviceLoginName='2519' GROUP BY  g.time, g.Distance;
CountAzimuth:804
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:13:4' AND e.date<='2024-11-20 23:13:4' AND e.DeviceLoginName='2519' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-19 22:13:04' AND g.time<='2024-11-20 21:13:04' AND g.DeviceLoginName='2519' GROUP BY  g.time, g.Distance;
CountAzimuth:484
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:16:42' AND e.date<='2024-11-21 23:16:42' AND e.DeviceLoginName='2519' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-20 22:16:42' AND g.time<='2024-11-21 21:16:42' AND g.DeviceLoginName='2519' GROUP BY  g.time, g.Distance;
CountAzimuth:425
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 0:19:45' AND e.date<='2024-11-22 23:19:45' AND e.DeviceLoginName='2519' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-21 22:19:45' AND g.time<='2024-11-22 21:19:45' AND g.DeviceLoginName='2519' GROUP BY  g.time, g.Distance;
CountAzimuth:587
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-25 10:0:42' AND e.date<='2024-11-26 10:0:42' AND e.DeviceLoginName='355234055743963' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-25 08:00:42' AND g.time<='2024-11-26 08:00:42' AND g.DeviceLoginName='355234055743963' GROUP BY  g.time, g.Distance;
CountAzimuth:1282
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-25 10:0:42' AND e.date<='2024-11-26 10:0:42' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-25 08:00:42' AND g.time<='2024-11-26 08:00:42' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:2166
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 23:0:0' AND e.date<='2024-11-06 5:0:0' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-05 21:00:00' AND g.time<='2024-11-06 03:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:128
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 5:0:0' AND e.date<='2024-11-06 6:0:0' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-06 03:00:00' AND g.time<='2024-11-06 04:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 5:0:0' AND e.date<='2024-11-06 7:0:0' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-06 03:00:00' AND g.time<='2024-11-06 05:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 5:0:0' AND e.date<='2024-11-06 8:0:0' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-06 03:00:00' AND g.time<='2024-11-06 06:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 5:0:0' AND e.date<='2024-11-06 9:0:0' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-06 03:00:00' AND g.time<='2024-11-06 07:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 5:0:0' AND e.date<='2024-11-06 10:0:0' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-06 03:00:00' AND g.time<='2024-11-06 08:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:31
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 22:0:0' AND e.date<='2024-11-05 23:0:0' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-05 20:00:00' AND g.time<='2024-11-05 21:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 21:0:0' AND e.date<='2024-11-05 23:0:0' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-05 19:00:00' AND g.time<='2024-11-05 21:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 20:0:0' AND e.date<='2024-11-05 23:0:0' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-05 18:00:00' AND g.time<='2024-11-05 21:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 19:0:0' AND e.date<='2024-11-05 23:0:0' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-05 17:00:00' AND g.time<='2024-11-05 21:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 18:0:0' AND e.date<='2024-11-05 23:0:0' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-05 16:00:00' AND g.time<='2024-11-05 21:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:155
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 18:0:0' AND e.date<='2024-11-06 6:0:0' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-05 16:00:00' AND g.time<='2024-11-06 04:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:283
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-26 2:57:16' AND e.date<='2024-11-26 10:57:16' AND e.DeviceLoginName='2556' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-26 00:57:16' AND g.time<='2024-11-26 08:57:16' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:113
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-26 6:23:50' AND e.date<='2024-11-26 11:23:50' AND e.DeviceLoginName='2556' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-26 04:23:50' AND g.time<='2024-11-26 09:23:50' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:88
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-26 3:12:16' AND e.date<='2024-11-26 12:12:16' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-26 01:12:16' AND g.time<='2024-11-26 10:12:16' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:161
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-26 0:12:33' AND e.date<='2024-11-26 12:12:33' AND e.DeviceLoginName='2556' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-25 22:12:33' AND g.time<='2024-11-26 10:12:33' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:351
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-26 1:30:53' AND e.date<='2024-11-26 12:30:53' AND e.DeviceLoginName='354836080167561' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-25 23:30:53' AND g.time<='2024-11-26 10:30:53' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:1288
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-26 12:42:46' AND e.date<='2024-11-26 13:42:46' AND e.DeviceLoginName='352353084291100' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-26 10:42:46' AND g.time<='2024-11-26 11:42:46' AND g.DeviceLoginName='352353084291100' GROUP BY  g.time, g.Distance;
CountAzimuth:24
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 23:0:0' AND e.date<='2024-11-23 5:0:0' AND e.DeviceLoginName='356078111446148' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-22 21:00:00' AND g.time<='2024-11-23 03:00:00' AND g.DeviceLoginName='356078111446148' GROUP BY  g.time, g.Distance;
CountAzimuth:162
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 23:0:0' AND e.date<='2024-11-20 5:0:0' AND e.DeviceLoginName='3156' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-19 21:00:00' AND g.time<='2024-11-20 03:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:243
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 23:0:0' AND e.date<='2024-11-21 5:0:0' AND e.DeviceLoginName='3156' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-20 21:00:00' AND g.time<='2024-11-21 03:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:225
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 23:0:0' AND e.date<='2024-11-22 5:0:0' AND e.DeviceLoginName='3156' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-21 21:00:00' AND g.time<='2024-11-22 03:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:84
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 23:0:0' AND e.date<='2024-11-17 5:0:0' AND e.DeviceLoginName='9004' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-16 21:00:00' AND g.time<='2024-11-17 03:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 23:0:0' AND e.date<='2024-11-06 5:0:0' AND e.DeviceLoginName='356078116292406' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-05 21:00:00' AND g.time<='2024-11-06 03:00:00' AND g.DeviceLoginName='356078116292406' GROUP BY  g.time, g.Distance;
CountAzimuth:128
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 23:0:0' AND e.date<='2024-11-07 5:0:0' AND e.DeviceLoginName='355234055579235' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-06 21:00:00' AND g.time<='2024-11-07 03:00:00' AND g.DeviceLoginName='355234055579235' GROUP BY  g.time, g.Distance;
CountAzimuth:55
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 23:0:0' AND e.date<='2024-11-23 5:0:0' AND e.DeviceLoginName='4825' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-22 21:00:00' AND g.time<='2024-11-23 03:00:00' AND g.DeviceLoginName='4825' GROUP BY  g.time, g.Distance;
CountAzimuth:134
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-01 23:0:0' AND e.date<='2024-11-02 5:0:0' AND e.DeviceLoginName='2610' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-01 21:00:00' AND g.time<='2024-11-02 03:00:00' AND g.DeviceLoginName='2610' GROUP BY  g.time, g.Distance;
CountAzimuth:50