Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-04 0:50:37' AND e.date<='2025-03-04 23:50:37' AND e.DeviceLoginName='2753' 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>='2025-03-03 22:50:37' AND g.time<='2025-03-04 21:50:37' AND g.DeviceLoginName='2753' GROUP BY g.time, g.Distance; CountAzimuth:1426 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-03 0:50:37' AND e.date<='2025-03-07 23:50:37' AND e.DeviceLoginName='2753' 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>='2025-03-02 22:50:37' AND g.time<='2025-03-07 21:50:37' AND g.DeviceLoginName='2753' GROUP BY g.time, g.Distance; CountAzimuth:5038 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-04 0:50:37' AND e.date<='2025-03-04 23:50:37' AND e.DeviceLoginName='2753' 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>='2025-03-03 22:50:37' AND g.time<='2025-03-04 21:50:37' AND g.DeviceLoginName='2753' GROUP BY g.time, g.Distance; CountAzimuth:1426 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 8:53:30' AND e.date<='2025-03-14 23:53:30' 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>='2025-03-14 06:53:30' AND g.time<='2025-03-14 21:53:30' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1494 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-10 0:50:37' AND e.date<='2025-03-14 23:50:37' AND e.DeviceLoginName='2753' 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>='2025-03-09 22:50:37' AND g.time<='2025-03-14 21:50:37' AND g.DeviceLoginName='2753' GROUP BY g.time, g.Distance; CountAzimuth:5716 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 7:55:36' AND e.date<='2025-03-15 22:55:36' 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>='2025-03-15 05:55:36' AND g.time<='2025-03-15 20:55:36' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:918 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-10 0:56:40' AND e.date<='2025-03-10 23:56:40' AND e.DeviceLoginName='862531041050148' 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>='2025-03-09 22:56:40' AND g.time<='2025-03-10 21:56:40' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:1319 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-11 0:56:40' AND e.date<='2025-03-11 23:56:40' AND e.DeviceLoginName='862531041050148' 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>='2025-03-10 22:56:40' AND g.time<='2025-03-11 21:56:40' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:1387 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-12 0:56:40' AND e.date<='2025-03-12 23:56:40' AND e.DeviceLoginName='862531041050148' 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>='2025-03-11 22:56:40' AND g.time<='2025-03-12 21:56:40' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:1259 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-13 0:56:40' AND e.date<='2025-03-13 23:56:40' AND e.DeviceLoginName='862531041050148' 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>='2025-03-12 22:56:40' AND g.time<='2025-03-13 21:56:40' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:634 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 0:56:40' AND e.date<='2025-03-14 23:56:40' AND e.DeviceLoginName='862531041050148' 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>='2025-03-13 22:56:40' AND g.time<='2025-03-14 21:56:40' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:1304 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 0:56:40' AND e.date<='2025-03-15 23:56:40' AND e.DeviceLoginName='862531041050148' 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>='2025-03-14 22:56:40' AND g.time<='2025-03-15 21:56:40' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:211 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 0:56:40' AND e.date<='2025-03-15 23:56:40' AND e.DeviceLoginName='4966' 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>='2025-03-14 22:56:40' AND g.time<='2025-03-15 21:56:40' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:22 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-11 0:56:40' AND e.date<='2025-03-11 23:56:40' AND e.DeviceLoginName='4966' 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>='2025-03-10 22:56:40' AND g.time<='2025-03-11 21:56:40' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:32 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 7:0:21' AND e.date<='2025-03-16 22:0:21' 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>='2025-03-16 05:00:21' AND g.time<='2025-03-16 20:00:21' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:518 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-10 0:56:40' AND e.date<='2025-03-10 23:56:40' AND e.DeviceLoginName='4966' 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>='2025-03-09 22:56:40' AND g.time<='2025-03-10 21:56:40' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:9 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-12 0:56:40' AND e.date<='2025-03-12 23:56:40' AND e.DeviceLoginName='4966' 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>='2025-03-11 22:56:40' AND g.time<='2025-03-12 21:56:40' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:260 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-12 0:56:40' AND e.date<='2025-03-12 23:56:40' AND e.DeviceLoginName='862531041078313' 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>='2025-03-11 22:56:40' AND g.time<='2025-03-12 21:56:40' AND g.DeviceLoginName='862531041078313' GROUP BY g.time, g.Distance; CountAzimuth:2489 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-13 0:56:40' AND e.date<='2025-03-13 23:56:40' AND e.DeviceLoginName='862531041078313' 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>='2025-03-12 22:56:40' AND g.time<='2025-03-13 21:56:40' AND g.DeviceLoginName='862531041078313' GROUP BY g.time, g.Distance; CountAzimuth:2855 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 0:56:40' AND e.date<='2025-03-14 23:56:40' AND e.DeviceLoginName='862531041078313' 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>='2025-03-13 22:56:40' AND g.time<='2025-03-14 21:56:40' AND g.DeviceLoginName='862531041078313' GROUP BY g.time, g.Distance; CountAzimuth:1642 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 9:2:4' AND e.date<='2025-03-17 9:2:4' AND e.DeviceLoginName='358021081803706' 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>='2025-03-15 07:02:04' AND g.time<='2025-03-17 07:02:04' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:1417 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-11 0:56:40' AND e.date<='2025-03-11 23:56:40' AND e.DeviceLoginName='2753' 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>='2025-03-10 22:56:40' AND g.time<='2025-03-11 21:56:40' AND g.DeviceLoginName='2753' GROUP BY g.time, g.Distance; CountAzimuth:1207 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 9:2:34' AND e.date<='2025-03-17 9:2:34' 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>='2025-03-15 07:02:34' AND g.time<='2025-03-17 07:02:34' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:1026 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-12 0:56:40' AND e.date<='2025-03-12 23:56:40' AND e.DeviceLoginName='2753' 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>='2025-03-11 22:56:40' AND g.time<='2025-03-12 21:56:40' AND g.DeviceLoginName='2753' GROUP BY g.time, g.Distance; CountAzimuth:977 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 9:3:37' AND e.date<='2025-03-17 9:3:37' 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>='2025-03-15 07:03:37' AND g.time<='2025-03-17 07:03:37' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:86 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-10 9:15:24' AND e.date<='2025-03-17 9:15:24' AND e.DeviceLoginName='3100' 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>='2025-03-10 07:15:24' AND g.time<='2025-03-17 07:15:24' AND g.DeviceLoginName='3100' GROUP BY g.time, g.Distance; CountAzimuth:4073 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-10 9:15:24' AND e.date<='2025-03-17 9:15:24' AND e.DeviceLoginName='4884' 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>='2025-03-10 07:15:24' AND g.time<='2025-03-17 07:15:24' AND g.DeviceLoginName='4884' GROUP BY g.time, g.Distance; CountAzimuth:4808 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-17 9:15:24' AND e.date<='2025-03-17 9:15:24' AND e.DeviceLoginName='4884' 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>='2025-02-17 07:15:24' AND g.time<='2025-03-17 07:15:24' AND g.DeviceLoginName='4884' GROUP BY g.time, g.Distance; CountAzimuth:10728 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 0:27:23' AND e.date<='2025-03-17 9:27:23' AND e.DeviceLoginName='354836080357964' 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>='2025-03-16 22:27:23' AND g.time<='2025-03-17 07:27:23' AND g.DeviceLoginName='354836080357964' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-11 0:56:40' AND e.date<='2025-03-11 23:56:40' AND e.DeviceLoginName='2753' 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>='2025-03-10 22:56:40' AND g.time<='2025-03-11 21:56:40' AND g.DeviceLoginName='2753' GROUP BY g.time, g.Distance; CountAzimuth:1207 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-04 0:56:40' AND e.date<='2025-03-04 23:56:40' AND e.DeviceLoginName='2753' 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>='2025-03-03 22:56:40' AND g.time<='2025-03-04 21:56:40' AND g.DeviceLoginName='2753' GROUP BY g.time, g.Distance; CountAzimuth:1426 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-05 0:56:40' AND e.date<='2025-03-05 23:56:40' AND e.DeviceLoginName='2753' 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>='2025-03-04 22:56:40' AND g.time<='2025-03-05 21:56:40' AND g.DeviceLoginName='2753' GROUP BY g.time, g.Distance; CountAzimuth:955 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 4:42:11' AND e.date<='2025-03-17 9:42:11' 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>='2025-03-17 02:42:11' AND g.time<='2025-03-17 07:42:11' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:352 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 2:12:28' AND e.date<='2025-03-17 10:12:28' 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>='2025-03-17 00:12:28' AND g.time<='2025-03-17 08:12:28' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:219 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-05 0:56:40' AND e.date<='2025-03-05 23:56:40' AND e.DeviceLoginName='352353084102240' 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>='2025-03-04 22:56:40' AND g.time<='2025-03-05 21:56:40' AND g.DeviceLoginName='352353084102240' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 0:56:40' AND e.date<='2025-03-17 23:56:40' AND e.DeviceLoginName='352353084102240' 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>='2025-03-16 22:56:40' AND g.time<='2025-03-17 21:56:40' AND g.DeviceLoginName='352353084102240' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 0:56:40' AND e.date<='2025-03-17 23:56:40' AND e.DeviceLoginName='352353084102240' 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>='2025-03-13 22:56:40' AND g.time<='2025-03-17 21:56:40' AND g.DeviceLoginName='352353084102240' GROUP BY g.time, g.Distance; CountAzimuth:465 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 0:56:40' AND e.date<='2025-03-17 23:56:40' AND e.DeviceLoginName='352353085039086' 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>='2025-03-13 22:56:40' AND g.time<='2025-03-17 21:56:40' AND g.DeviceLoginName='352353085039086' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-10 0:56:40' AND e.date<='2025-03-17 23:56:40' AND e.DeviceLoginName='352353085039086' 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>='2025-03-09 22:56:40' AND g.time<='2025-03-17 21:56:40' AND g.DeviceLoginName='352353085039086' GROUP BY g.time, g.Distance; CountAzimuth:801 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-10 0:56:40' AND e.date<='2025-03-17 23:56:40' AND e.DeviceLoginName='356078118078019' 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>='2025-03-09 22:56:40' AND g.time<='2025-03-17 21:56:40' AND g.DeviceLoginName='356078118078019' GROUP BY g.time, g.Distance; CountAzimuth:334 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 10:54:45' AND e.date<='2025-03-17 10:54:45' 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>='2025-03-16 08:54:45' AND g.time<='2025-03-17 08:54:45' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:906 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 11:0:12' AND e.date<='2025-03-17 11:0:12' 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>='2025-03-17 09:00:12' AND g.time<='2025-03-17 09:00:12' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 0:0:24' AND e.date<='2025-03-17 11:0:24' 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>='2025-03-16 22:00:24' AND g.time<='2025-03-17 09:00:24' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:388 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 11:2:54' AND e.date<='2025-03-17 11:2:54' AND e.DeviceLoginName='3144' 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>='2025-03-16 09:02:54' AND g.time<='2025-03-17 09:02:54' AND g.DeviceLoginName='3144' GROUP BY g.time, g.Distance; CountAzimuth:31 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 5:7:7' AND e.date<='2025-03-17 11:7:7' 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>='2025-03-17 03:07:07' AND g.time<='2025-03-17 09:07:07' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:491 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 11:2:54' AND e.date<='2025-03-17 11:2:54' AND e.DeviceLoginName='2672' 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>='2025-03-16 09:02:54' AND g.time<='2025-03-17 09:02:54' AND g.DeviceLoginName='2672' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 11:2:54' AND e.date<='2025-03-17 11:2:54' AND e.DeviceLoginName='356078111430837' 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>='2025-03-16 09:02:54' AND g.time<='2025-03-17 09:02:54' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:1179 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 0:2:54' AND e.date<='2025-03-16 23:2:54' AND e.DeviceLoginName='356078111430837' 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>='2025-03-14 22:02:54' AND g.time<='2025-03-16 21:02:54' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:788 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 0:2:54' AND e.date<='2025-03-17 23:2:54' AND e.DeviceLoginName='356078111430837' 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>='2025-03-16 22:02:54' AND g.time<='2025-03-17 21:02:54' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:820 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='356078116287711' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='356078116287711' GROUP BY g.time, g.Distance; CountAzimuth:16 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='5130' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='5130' GROUP BY g.time, g.Distance; CountAzimuth:257 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='3154' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='3154' GROUP BY g.time, g.Distance; CountAzimuth:33 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='3157' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='3157' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='4966' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:34 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='4869' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='4869' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='4862' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:223 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='2728' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='2728' GROUP BY g.time, g.Distance; CountAzimuth:147 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='8983' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='8983' GROUP BY g.time, g.Distance; CountAzimuth:160 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='2610' GROUP BY g.time, g.Distance; CountAzimuth:23 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='9016' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='9016' GROUP BY g.time, g.Distance; CountAzimuth:319 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='2499' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='2499' GROUP BY g.time, g.Distance; CountAzimuth:28 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='3197' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='3197' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='2964' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='2964' GROUP BY g.time, g.Distance; CountAzimuth:59 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='9016' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='9016' GROUP BY g.time, g.Distance; CountAzimuth:319 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 5:9:53' AND e.date<='2025-03-17 13:9:53' 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>='2025-03-17 03:09:53' AND g.time<='2025-03-17 11:09:53' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:593 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 5:10:48' AND e.date<='2025-03-17 13:10:48' 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>='2025-03-17 03:10:48' AND g.time<='2025-03-17 11:10:48' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:333 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 5:11:15' AND e.date<='2025-03-17 13:11:15' 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>='2025-03-17 03:11:15' AND g.time<='2025-03-17 11:11:15' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:594 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 13:33:47' AND e.date<='2025-03-17 13:33:47' 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>='2025-03-16 11:33:47' AND g.time<='2025-03-17 11:33:47' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:567 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 1:34:20' AND e.date<='2025-03-17 13:34:20' 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>='2025-03-16 23:34:20' AND g.time<='2025-03-17 11:34:20' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:698 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 0:0:0' AND e.date<='2025-03-14 23:0:0' AND e.DeviceLoginName='9016' 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>='2025-03-13 22:00:00' AND g.time<='2025-03-14 21:00:00' AND g.DeviceLoginName='9016' GROUP BY g.time, g.Distance; CountAzimuth:2923 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 23:0:0' AND e.date<='2025-03-15 5:0:0' AND e.DeviceLoginName='9016' 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>='2025-03-14 21:00:00' AND g.time<='2025-03-15 03:00:00' AND g.DeviceLoginName='9016' GROUP BY g.time, g.Distance; CountAzimuth:319 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='356078116287711' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='356078116287711' GROUP BY g.time, g.Distance; CountAzimuth:13 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='4848' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='4848' GROUP BY g.time, g.Distance; CountAzimuth:83 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='2695' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='2695' GROUP BY g.time, g.Distance; CountAzimuth:14 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='4849' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:207 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='2769' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='2769' GROUP BY g.time, g.Distance; CountAzimuth:91 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='5078' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='5078' GROUP BY g.time, g.Distance; CountAzimuth:100 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='3025' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='3025' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='864866053467873' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='864866053467873' GROUP BY g.time, g.Distance; CountAzimuth:20 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='3263' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='3263' GROUP BY g.time, g.Distance; CountAzimuth:83 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='4869' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='4869' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='3039' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='3039' GROUP BY g.time, g.Distance; CountAzimuth:14 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='2676' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='2676' GROUP BY g.time, g.Distance; CountAzimuth:75 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='3071' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='3071' GROUP BY g.time, g.Distance; CountAzimuth:207 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='2964' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='2964' GROUP BY g.time, g.Distance; CountAzimuth:803 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 23:0:0' AND e.date<='2025-03-16 5:0:0' AND e.DeviceLoginName='356078118085311' 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>='2025-03-15 21:00:00' AND g.time<='2025-03-16 03:00:00' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:14 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 23:0:0' AND e.date<='2025-03-17 5:0:0' AND e.DeviceLoginName='9011' 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>='2025-03-16 21:00:00' AND g.time<='2025-03-17 03:00:00' AND g.DeviceLoginName='9011' GROUP BY g.time, g.Distance; CountAzimuth:195 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 23:0:0' AND e.date<='2025-03-17 5:0:0' AND e.DeviceLoginName='3057' 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>='2025-03-16 21:00:00' AND g.time<='2025-03-17 03:00:00' AND g.DeviceLoginName='3057' GROUP BY g.time, g.Distance; CountAzimuth:34 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 23:0:0' AND e.date<='2025-03-17 5:0:0' AND e.DeviceLoginName='4849' 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>='2025-03-16 21:00:00' AND g.time<='2025-03-17 03:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:285 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 23:0:0' AND e.date<='2025-03-17 5:0:0' AND e.DeviceLoginName='2790' 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>='2025-03-16 21:00:00' AND g.time<='2025-03-17 03:00:00' AND g.DeviceLoginName='2790' GROUP BY g.time, g.Distance; CountAzimuth:73 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 23:0:0' AND e.date<='2025-03-17 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>='2025-03-16 21:00:00' AND g.time<='2025-03-17 03:00:00' AND g.DeviceLoginName='2610' GROUP BY g.time, g.Distance; CountAzimuth:82 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 13:52:30' AND e.date<='2025-03-17 13:52:30' AND e.DeviceLoginName='5081' 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>='2025-03-16 11:52:30' AND g.time<='2025-03-17 11:52:30' AND g.DeviceLoginName='5081' GROUP BY g.time, g.Distance; CountAzimuth:473 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 23:0:0' AND e.date<='2025-03-17 5:0:0' AND e.DeviceLoginName='2499' 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>='2025-03-16 21:00:00' AND g.time<='2025-03-17 03:00:00' AND g.DeviceLoginName='2499' GROUP BY g.time, g.Distance; CountAzimuth:202 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 23:0:0' AND e.date<='2025-03-17 5:0:0' AND e.DeviceLoginName='2997' 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>='2025-03-16 21:00:00' AND g.time<='2025-03-17 03:00:00' AND g.DeviceLoginName='2997' GROUP BY g.time, g.Distance; CountAzimuth:123 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 23:0:0' AND e.date<='2025-03-17 5:0:0' AND e.DeviceLoginName='3027' 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>='2025-03-16 21:00:00' AND g.time<='2025-03-17 03:00:00' AND g.DeviceLoginName='3027' GROUP BY g.time, g.Distance; CountAzimuth:21 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 23:0:0' AND e.date<='2025-03-17 5:0:0' AND e.DeviceLoginName='3047' 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>='2025-03-16 21:00:00' AND g.time<='2025-03-17 03:00:00' AND g.DeviceLoginName='3047' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 0:5:10' AND e.date<='2025-03-14 23:5:10' AND e.DeviceLoginName='5081' 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>='2025-03-13 22:05:10' AND g.time<='2025-03-14 21:05:10' AND g.DeviceLoginName='5081' GROUP BY g.time, g.Distance; CountAzimuth:1360 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 7:18:8' AND e.date<='2025-03-17 14:18:8' 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>='2025-03-17 05:18:08' AND g.time<='2025-03-17 12:18:08' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:517 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 0:5:10' AND e.date<='2025-03-15 23:5:10' AND e.DeviceLoginName='3980' 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>='2025-03-14 22:05:10' AND g.time<='2025-03-15 21:05:10' AND g.DeviceLoginName='3980' GROUP BY g.time, g.Distance; CountAzimuth:1536 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-12 0:5:10' AND e.date<='2025-03-12 23:5:10' AND e.DeviceLoginName='3139' 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>='2025-03-11 22:05:10' AND g.time<='2025-03-12 21:05:10' AND g.DeviceLoginName='3139' GROUP BY g.time, g.Distance; CountAzimuth:86 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-12 15:20:10' AND e.date<='2025-03-12 15:25:10' AND e.DeviceLoginName='3139' 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>='2025-03-12 13:20:10' AND g.time<='2025-03-12 13:25:10' AND g.DeviceLoginName='3139' GROUP BY g.time, g.Distance; CountAzimuth:9 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 20:15:10' AND e.date<='2025-03-16 20:25:10' AND e.DeviceLoginName='3139' 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>='2025-03-16 18:15:10' AND g.time<='2025-03-16 18:25:10' AND g.DeviceLoginName='3139' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 20:15:10' AND e.date<='2025-03-16 20:25:10' AND e.DeviceLoginName='8998' 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>='2025-03-16 18:15:10' AND g.time<='2025-03-16 18:25:10' AND g.DeviceLoginName='8998' GROUP BY g.time, g.Distance; CountAzimuth:153 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 20:20:10' AND e.date<='2025-03-16 20:25:10' AND e.DeviceLoginName='8998' 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>='2025-03-16 18:20:10' AND g.time<='2025-03-16 18:25:10' AND g.DeviceLoginName='8998' GROUP BY g.time, g.Distance; CountAzimuth:83 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-12 20:20:10' AND e.date<='2025-03-12 20:25:10' AND e.DeviceLoginName='2602' 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>='2025-03-12 18:20:10' AND g.time<='2025-03-12 18:25:10' AND g.DeviceLoginName='2602' GROUP BY g.time, g.Distance; CountAzimuth:61 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-12 20:32:10' AND e.date<='2025-03-12 20:38:10' AND e.DeviceLoginName='2602' 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>='2025-03-12 18:32:10' AND g.time<='2025-03-12 18:38:10' AND g.DeviceLoginName='2602' GROUP BY g.time, g.Distance; CountAzimuth:73 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-12 10:40:10' AND e.date<='2025-03-12 10:43:10' AND e.DeviceLoginName='2543' 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>='2025-03-12 08:40:10' AND g.time<='2025-03-12 08:43:10' AND g.DeviceLoginName='2543' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-12 10:40:10' AND e.date<='2025-03-12 10:43:10' AND e.DeviceLoginName='2557' 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>='2025-03-12 08:40:10' AND g.time<='2025-03-12 08:43:10' AND g.DeviceLoginName='2557' GROUP BY g.time, g.Distance; CountAzimuth:36 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 9:22:2' AND e.date<='2025-03-17 14:22:2' 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>='2025-03-17 07:22:02' AND g.time<='2025-03-17 12:22:02' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:338 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-13 15:27:10' AND e.date<='2025-03-13 15:35:10' AND e.DeviceLoginName='356078116291713' 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>='2025-03-13 13:27:10' AND g.time<='2025-03-13 13:35:10' AND g.DeviceLoginName='356078116291713' GROUP BY g.time, g.Distance; CountAzimuth:39 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-13 15:30:10' AND e.date<='2025-03-13 15:35:10' AND e.DeviceLoginName='356078116291713' 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>='2025-03-13 13:30:10' AND g.time<='2025-03-13 13:35:10' AND g.DeviceLoginName='356078116291713' GROUP BY g.time, g.Distance; CountAzimuth:32 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-13 15:30:10' AND e.date<='2025-03-13 15:32:10' AND e.DeviceLoginName='356078116291713' 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>='2025-03-13 13:30:10' AND g.time<='2025-03-13 13:32:10' AND g.DeviceLoginName='356078116291713' GROUP BY g.time, g.Distance; CountAzimuth:18 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-10 15:30:10' AND e.date<='2025-03-10 15:32:10' AND e.DeviceLoginName='352353084175246' 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>='2025-03-10 13:30:10' AND g.time<='2025-03-10 13:32:10' AND g.DeviceLoginName='352353084175246' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-10 13:0:10' AND e.date<='2025-03-10 13:6:10' AND e.DeviceLoginName='352353084175246' 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>='2025-03-10 11:00:10' AND g.time<='2025-03-10 11:06:10' AND g.DeviceLoginName='352353084175246' GROUP BY g.time, g.Distance; CountAzimuth:22 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 6:24:16' AND e.date<='2025-03-17 14:24:16' 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>='2025-03-17 04:24:16' AND g.time<='2025-03-17 12:24:16' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:629 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-14 10:22:10' AND e.date<='2025-03-14 10:27:10' AND e.DeviceLoginName='2473' 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>='2025-03-14 08:22:10' AND g.time<='2025-03-14 08:27:10' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:44 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-16 0:22:10' AND e.date<='2025-03-16 23:27:10' AND e.DeviceLoginName='8998' 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>='2025-03-15 22:22:10' AND g.time<='2025-03-16 21:27:10' AND g.DeviceLoginName='8998' GROUP BY g.time, g.Distance; CountAzimuth:224 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-10 0:17:25' AND e.date<='2025-03-15 23:17:25' AND e.DeviceLoginName='2786' 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>='2025-03-09 22:17:25' AND g.time<='2025-03-15 21:17:25' AND g.DeviceLoginName='2786' GROUP BY g.time, g.Distance; CountAzimuth:6287 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-17 0:10:55' AND e.date<='2025-03-17 16:10:55' AND e.DeviceLoginName='354836080357964' 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>='2025-03-16 22:10:55' AND g.time<='2025-03-17 14:10:55' AND g.DeviceLoginName='354836080357964' GROUP BY g.time, g.Distance; CountAzimuth:706 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-16 22:00:00' AND g.time<='2025-03-17 15:36:01' AND g.DeviceLoginName='352353085039086' Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-03-17 14:09:48' AND TIME<='2025-03-17 14:19:48' AND DeviceLoginName='352353085039086' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-03-17 14:54:52' AND TIME<='2025-03-17 15:04:52' AND DeviceLoginName='352353085039086' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-03-17 15:13:39' AND TIME<='2025-03-17 15:23:39' AND DeviceLoginName='352353085039086' AND speed=0 Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353085039086' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2025-03-16 22:00:00' AND e.date<='2025-03-17 15:36:01' Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-03-17 14:09:48' AND TIME<='2025-03-17 14:19:48' AND DeviceLoginName='352353085039086' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-03-17 14:54:52' AND TIME<='2025-03-17 15:04:52' AND DeviceLoginName='352353085039086' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-03-17 15:13:39' AND TIME<='2025-03-17 15:23:39' AND DeviceLoginName='352353085039086' AND speed=0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-11 0:13:48' AND e.date<='2025-03-15 22:13:48' AND e.DeviceLoginName='352353085039086' 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>='2025-03-10 22:13:48' AND g.time<='2025-03-15 20:13:48' AND g.DeviceLoginName='352353085039086' GROUP BY g.time, g.Distance; CountAzimuth:79 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-15 0:13:48' AND e.date<='2025-03-17 22:13:48' AND e.DeviceLoginName='352353085039086' 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>='2025-03-14 22:13:48' AND g.time<='2025-03-17 20:13:48' AND g.DeviceLoginName='352353085039086' GROUP BY g.time, g.Distance; CountAzimuth:593