Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 7:23:8' AND e.date<='2025-03-31 7:23:8' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 04:23:08' AND g.time<='2025-03-31 04:23:08' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:461 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 7:23:26' AND e.date<='2025-03-31 7:23:26' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 04:23:26' AND g.time<='2025-03-31 04:23:26' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:1005 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 7:23:38' AND e.date<='2025-03-31 7:23:38' AND e.DeviceLoginName='352353086131601' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 04:23:38' AND g.time<='2025-03-31 04:23:38' AND g.DeviceLoginName='352353086131601' GROUP BY g.time, g.Distance; CountAzimuth:192 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-31 3:23:52' AND e.date<='2025-03-31 7:23:52' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-31 00:23:52' AND g.time<='2025-03-31 04:23:52' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:232 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 7:26:10' AND e.date<='2025-03-28 23:26:10' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 04:26:10' AND g.time<='2025-03-28 20:26:10' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1630 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 7:26:46' AND e.date<='2025-03-29 23:26:46' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 04:26:46' AND g.time<='2025-03-29 20:26:46' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 7:27:0' AND e.date<='2025-03-30 23:27:0' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 04:27:00' AND g.time<='2025-03-30 20:27:00' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1031 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-31 0:25:12' AND e.date<='2025-03-31 8:25:12' AND e.DeviceLoginName='862531041080715' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 21:25:12' AND g.time<='2025-03-31 05:25:12' AND g.DeviceLoginName='862531041080715' GROUP BY g.time, g.Distance; CountAzimuth:329 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:38:30' AND e.date<='2025-03-28 23:38:30' AND e.DeviceLoginName='2599' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:38:30' AND g.time<='2025-03-28 20:38:30' AND g.DeviceLoginName='2599' GROUP BY g.time, g.Distance; CountAzimuth:984 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:38:30' AND e.date<='2025-03-28 23:38:30' AND e.DeviceLoginName='2614' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:38:30' AND g.time<='2025-03-28 20:38:30' AND g.DeviceLoginName='2614' GROUP BY g.time, g.Distance; CountAzimuth:737 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:38:30' AND e.date<='2025-03-28 23:38:30' AND e.DeviceLoginName='2754' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:38:30' AND g.time<='2025-03-28 20:38:30' AND g.DeviceLoginName='2754' GROUP BY g.time, g.Distance; CountAzimuth:2158 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-29 5:0:0' AND e.DeviceLoginName='9010' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-29 02:00:00' AND g.DeviceLoginName='9010' GROUP BY g.time, g.Distance; CountAzimuth:152 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-29 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-29 02:00:00' AND g.DeviceLoginName='4848' GROUP BY g.time, g.Distance; CountAzimuth:52 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-29 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-29 02:00:00' AND g.DeviceLoginName='356078111446148' GROUP BY g.time, g.Distance; CountAzimuth:99 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-29 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-29 02:00:00' AND g.DeviceLoginName='5130' GROUP BY g.time, g.Distance; CountAzimuth:455 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-29 5:0:0' AND e.DeviceLoginName='3089' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-29 02:00:00' AND g.DeviceLoginName='3089' GROUP BY g.time, g.Distance; CountAzimuth:999 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-29 5:0:0' AND e.DeviceLoginName='3089' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-29 02:00:00' AND g.DeviceLoginName='3089' GROUP BY g.time, g.Distance; CountAzimuth:999 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='AI11' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='AI11' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='3089' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='3089' GROUP BY g.time, g.Distance; CountAzimuth:3383 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='3089' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='3089' GROUP BY g.time, g.Distance; CountAzimuth:454 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-28 23:59:0' AND e.DeviceLoginName='3089' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-28 20:59:00' AND g.DeviceLoginName='3089' GROUP BY g.time, g.Distance; CountAzimuth:533 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-28 23:59:0' AND e.DeviceLoginName='5130' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-28 20:59:00' AND g.DeviceLoginName='5130' GROUP BY g.time, g.Distance; CountAzimuth:378 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='5130' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='5130' GROUP BY g.time, g.Distance; CountAzimuth:77 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:38:30' AND e.date<='2025-03-28 23:38:30' AND e.DeviceLoginName='356078116299468' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:38:30' AND g.time<='2025-03-28 20:38:30' AND g.DeviceLoginName='356078116299468' GROUP BY g.time, g.Distance; CountAzimuth:2269 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='356078111446148' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='356078111446148' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:0:0' AND e.date<='2025-03-28 5:0:0' AND e.DeviceLoginName='356078111294241' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:00:00' AND g.time<='2025-03-28 02:00:00' AND g.DeviceLoginName='356078111294241' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:0:0' AND e.date<='2025-03-28 6:0:0' AND e.DeviceLoginName='356078111294241' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:00:00' AND g.time<='2025-03-28 03:00:00' AND g.DeviceLoginName='356078111294241' GROUP BY g.time, g.Distance; CountAzimuth:57 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-28 23:59:0' AND e.DeviceLoginName='356078111294241' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-28 20:59:00' AND g.DeviceLoginName='356078111294241' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 23:0:0' AND e.date<='2025-03-29 23:59:0' AND e.DeviceLoginName='356078111294241' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 20:00:00' AND g.time<='2025-03-29 20:59:00' AND g.DeviceLoginName='356078111294241' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:38:30' AND e.date<='2025-03-28 23:38:30' AND e.DeviceLoginName='356078116299468' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:38:30' AND g.time<='2025-03-28 20:38:30' AND g.DeviceLoginName='356078116299468' GROUP BY g.time, g.Distance; CountAzimuth:2269 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:38:30' AND e.date<='2025-03-28 23:38:30' AND e.DeviceLoginName='2754' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:38:30' AND g.time<='2025-03-28 20:38:30' AND g.DeviceLoginName='2754' GROUP BY g.time, g.Distance; CountAzimuth:2158 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:38:30' AND e.date<='2025-03-28 23:38:30' AND e.DeviceLoginName='862531041080715' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:38:30' AND g.time<='2025-03-28 20:38:30' AND g.DeviceLoginName='862531041080715' GROUP BY g.time, g.Distance; CountAzimuth:1188 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-31 0:38:30' AND e.date<='2025-03-31 23:38:30' AND e.DeviceLoginName='862531041080715' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 21:38:30' AND g.time<='2025-03-31 20:38:30' AND g.DeviceLoginName='862531041080715' GROUP BY g.time, g.Distance; CountAzimuth:644 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-31 0:38:30' AND e.date<='2025-03-31 23:38:30' AND e.DeviceLoginName='2754' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 21:38:30' AND g.time<='2025-03-31 20:38:30' AND g.DeviceLoginName='2754' GROUP BY g.time, g.Distance; CountAzimuth:68 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:38:30' AND e.date<='2025-03-28 23:38:30' AND e.DeviceLoginName='2754' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:38:30' AND g.time<='2025-03-28 20:38:30' AND g.DeviceLoginName='2754' GROUP BY g.time, g.Distance; CountAzimuth:2158 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-24 0:38:30' AND e.date<='2025-03-24 23:38:30' AND e.DeviceLoginName='4966' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-23 21:38:30' AND g.time<='2025-03-24 20:38:30' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:1235 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-25 0:38:30' AND e.date<='2025-03-25 23:38:30' AND e.DeviceLoginName='4966' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-24 21:38:30' AND g.time<='2025-03-25 20:38:30' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:968 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-26 0:38:30' AND e.date<='2025-03-26 23:38:30' AND e.DeviceLoginName='4966' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-25 21:38:30' AND g.time<='2025-03-26 20:38:30' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:1515 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-27 0:38:30' AND e.date<='2025-03-27 23:38:30' AND e.DeviceLoginName='4966' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-26 21:38:30' AND g.time<='2025-03-27 20:38:30' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:1303 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:38:30' AND e.date<='2025-03-28 23:38:30' AND e.DeviceLoginName='4966' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:38:30' AND g.time<='2025-03-28 20:38:30' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:1031 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 23:0:0' AND e.date<='2025-03-29 23:59:0' AND e.DeviceLoginName='5130' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 20:00:00' AND g.time<='2025-03-29 20:59:00' AND g.DeviceLoginName='5130' GROUP BY g.time, g.Distance; CountAzimuth:45 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-28 23:59:0' AND e.DeviceLoginName='5130' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-28 20:59:00' AND g.DeviceLoginName='5130' GROUP BY g.time, g.Distance; CountAzimuth:378 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='5130' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='5130' GROUP BY g.time, g.Distance; CountAzimuth:77 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-28 23:59:0' AND e.DeviceLoginName='5130' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-28 20:59:00' AND g.DeviceLoginName='5130' GROUP BY g.time, g.Distance; CountAzimuth:378 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-28 23:59:0' AND e.DeviceLoginName='3089' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-28 20:59:00' AND g.DeviceLoginName='3089' GROUP BY g.time, g.Distance; CountAzimuth:533 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='3089' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='3089' GROUP BY g.time, g.Distance; CountAzimuth:454 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-25 0:38:30' AND e.date<='2025-03-25 23:38:30' AND e.DeviceLoginName='9005' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-24 21:38:30' AND g.time<='2025-03-25 20:38:30' AND g.DeviceLoginName='9005' GROUP BY g.time, g.Distance; CountAzimuth:4237 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-28 23:59:0' AND e.DeviceLoginName='3057' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-28 20:59:00' AND g.DeviceLoginName='3057' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='3057' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='3057' GROUP BY g.time, g.Distance; CountAzimuth:7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='2558' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='2558' GROUP BY g.time, g.Distance; CountAzimuth:7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='4849' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:321 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='353173066816669' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='353173066816669' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='3157' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='3157' GROUP BY g.time, g.Distance; CountAzimuth:13 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='355234055234161' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='355234055234161' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='9014' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='9014' GROUP BY g.time, g.Distance; CountAzimuth:71 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='356078111430837' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:2 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='3090' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='3090' GROUP BY g.time, g.Distance; CountAzimuth:7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:38:30' AND e.date<='2025-03-28 23:38:30' AND e.DeviceLoginName='2754' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 21:38:30' AND g.time<='2025-03-28 20:38:30' AND g.DeviceLoginName='2754' GROUP BY g.time, g.Distance; CountAzimuth:2158 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='3166' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='3166' GROUP BY g.time, g.Distance; CountAzimuth:33 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='2703' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='2703' GROUP BY g.time, g.Distance; CountAzimuth:23 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='353173060537865' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='353173060537865' GROUP BY g.time, g.Distance; CountAzimuth:136 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='3188' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='3188' GROUP BY g.time, g.Distance; CountAzimuth:7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='5076' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='5076' GROUP BY g.time, g.Distance; CountAzimuth:17 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='2954' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='2954' GROUP BY g.time, g.Distance; CountAzimuth:41 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='4861' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='4861' GROUP BY g.time, g.Distance; CountAzimuth:26 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='2576' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='2576' GROUP BY g.time, g.Distance; CountAzimuth:13 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='9019' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='9019' GROUP BY g.time, g.Distance; CountAzimuth:171 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='354836080091142' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='354836080091142' GROUP BY g.time, g.Distance; CountAzimuth:38 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='2714' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='2714' GROUP BY g.time, g.Distance; CountAzimuth:2 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='3039' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='3039' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='352353086159685' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='352353086159685' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='354836080080590' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='354836080080590' GROUP BY g.time, g.Distance; CountAzimuth:2 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='3132' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='3132' GROUP BY g.time, g.Distance; CountAzimuth:43 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='352353084101820' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='352353084101820' GROUP BY g.time, g.Distance; CountAzimuth:4 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='2610' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='2610' GROUP BY g.time, g.Distance; CountAzimuth:4 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='2495' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='2495' GROUP BY g.time, g.Distance; CountAzimuth:4 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='2676' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='2676' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='2948' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='2948' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='2584' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='2584' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='3197' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='3197' GROUP BY g.time, g.Distance; CountAzimuth:13 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:0' AND e.DeviceLoginName='2709' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:00' AND g.DeviceLoginName='2709' GROUP BY g.time, g.Distance; CountAzimuth:7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-27 0:0:0' AND e.date<='2025-03-27 6:0:0' AND e.DeviceLoginName='356078118052857' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-26 21:00:00' AND g.time<='2025-03-27 03:00:00' AND g.DeviceLoginName='356078118052857' GROUP BY g.time, g.Distance; CountAzimuth:106 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 23:0:0' AND e.date<='2025-03-29 23:59:33' AND e.DeviceLoginName='2695' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 20:00:00' AND g.time<='2025-03-29 20:59:33' AND g.DeviceLoginName='2695' GROUP BY g.time, g.Distance; CountAzimuth:147 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 0:0:0' AND e.date<='2025-03-30 6:0:0' AND e.DeviceLoginName='2695' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 21:00:00' AND g.time<='2025-03-30 02:00:00' AND g.DeviceLoginName='2695' GROUP BY g.time, g.Distance; CountAzimuth:57 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 0:0:0' AND e.date<='2025-03-30 6:0:0' AND e.DeviceLoginName='2565' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 21:00:00' AND g.time<='2025-03-30 02:00:00' AND g.DeviceLoginName='2565' GROUP BY g.time, g.Distance; CountAzimuth:72 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 0:0:0' AND e.date<='2025-03-30 6:0:0' AND e.DeviceLoginName='9014' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 21:00:00' AND g.time<='2025-03-30 02:00:00' AND g.DeviceLoginName='9014' GROUP BY g.time, g.Distance; CountAzimuth:1053 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 0:0:0' AND e.date<='2025-03-30 6:0:0' AND e.DeviceLoginName='2703' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 21:00:00' AND g.time<='2025-03-30 02:00:00' AND g.DeviceLoginName='2703' GROUP BY g.time, g.Distance; CountAzimuth:22 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 0:0:0' AND e.date<='2025-03-30 6:0:0' AND e.DeviceLoginName='4861' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 21:00:00' AND g.time<='2025-03-30 02:00:00' AND g.DeviceLoginName='4861' GROUP BY g.time, g.Distance; CountAzimuth:1047 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 0:0:0' AND e.date<='2025-03-30 6:0:0' AND e.DeviceLoginName='2662' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 21:00:00' AND g.time<='2025-03-30 02:00:00' AND g.DeviceLoginName='2662' GROUP BY g.time, g.Distance; CountAzimuth:324 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 0:0:0' AND e.date<='2025-03-30 6:0:0' AND e.DeviceLoginName='354836080091142' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 21:00:00' AND g.time<='2025-03-30 02:00:00' AND g.DeviceLoginName='354836080091142' GROUP BY g.time, g.Distance; CountAzimuth:38 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 0:0:0' AND e.date<='2025-03-30 6:0:0' AND e.DeviceLoginName='3132' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 21:00:00' AND g.time<='2025-03-30 02:00:00' AND g.DeviceLoginName='3132' GROUP BY g.time, g.Distance; CountAzimuth:58 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 0:0:0' AND e.date<='2025-03-30 6:0:0' AND e.DeviceLoginName='2495' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 21:00:00' AND g.time<='2025-03-30 02:00:00' AND g.DeviceLoginName='2495' GROUP BY g.time, g.Distance; CountAzimuth:8 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 0:0:0' AND e.date<='2025-03-30 6:0:0' AND e.DeviceLoginName='2964' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 21:00:00' AND g.time<='2025-03-30 02:00:00' AND g.DeviceLoginName='2964' GROUP BY g.time, g.Distance; CountAzimuth:29 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:00' AND g.DeviceLoginName='9011' GROUP BY g.time, g.Distance; CountAzimuth:134 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:00' AND g.DeviceLoginName='4848' GROUP BY g.time, g.Distance; CountAzimuth:130 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:00' AND g.DeviceLoginName='5130' GROUP BY g.time, g.Distance; CountAzimuth:359 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 5:0:0' AND e.DeviceLoginName='356078111430837' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:00' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:47 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 5:0:0' AND e.DeviceLoginName='2883' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:00' AND g.DeviceLoginName='2883' GROUP BY g.time, g.Distance; CountAzimuth:129 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 5:0:0' AND e.DeviceLoginName='2876' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:00' AND g.DeviceLoginName='2876' GROUP BY g.time, g.Distance; CountAzimuth:69 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 5:0:0' AND e.DeviceLoginName='2947' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:00' AND g.DeviceLoginName='2947' GROUP BY g.time, g.Distance; CountAzimuth:29 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 5:0:0' AND e.DeviceLoginName='3029' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:00' AND g.DeviceLoginName='3029' GROUP BY g.time, g.Distance; CountAzimuth:169 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 5:0:0' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:00' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:194 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 5:0:0' AND e.DeviceLoginName='2743' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:00' AND g.DeviceLoginName='2743' GROUP BY g.time, g.Distance; CountAzimuth:6 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:00' AND g.DeviceLoginName='2676' GROUP BY g.time, g.Distance; CountAzimuth:13 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:00' AND g.DeviceLoginName='2499' GROUP BY g.time, g.Distance; CountAzimuth:448 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 5:0:0' AND e.DeviceLoginName='3205' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:00' AND g.DeviceLoginName='3205' GROUP BY g.time, g.Distance; CountAzimuth:113 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-25 0:38:30' AND e.date<='2025-03-25 23:38:30' AND e.DeviceLoginName='9005' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-24 21:38:30' AND g.time<='2025-03-25 20:38:30' AND g.DeviceLoginName='9005' GROUP BY g.time, g.Distance; CountAzimuth:4237 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-26 0:38:30' AND e.date<='2025-03-26 23:38:30' AND e.DeviceLoginName='2703' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-25 21:38:30' AND g.time<='2025-03-26 20:38:30' AND g.DeviceLoginName='2703' GROUP BY g.time, g.Distance; CountAzimuth:532 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-24 0:38:30' AND e.date<='2025-03-24 23:38:30' AND e.DeviceLoginName='2703' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-23 21:38:30' AND g.time<='2025-03-24 20:38:30' AND g.DeviceLoginName='2703' GROUP BY g.time, g.Distance; CountAzimuth:182 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-27 0:38:30' AND e.date<='2025-03-27 23:38:30' AND e.DeviceLoginName='2703' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-26 21:38:30' AND g.time<='2025-03-27 20:38:30' AND g.DeviceLoginName='2703' GROUP BY g.time, g.Distance; CountAzimuth:127 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-22 0:45:0' AND e.date<='2025-03-22 23:45:0' AND e.DeviceLoginName='3060' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-21 21:45:00' AND g.time<='2025-03-22 20:45:00' AND g.DeviceLoginName='3060' GROUP BY g.time, g.Distance; CountAzimuth:1448 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 14:35:52' AND e.date<='2025-03-31 14:35:52' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 11:35:52' AND g.time<='2025-03-31 11:35:52' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:1295 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-31 6:37:3' AND e.date<='2025-03-31 14:37:3' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-31 03:37:03' AND g.time<='2025-03-31 11:37:03' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:688 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-31 7:37:41' AND e.date<='2025-03-31 14:37:41' AND e.DeviceLoginName='3090' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-31 04:37:41' AND g.time<='2025-03-31 11:37:41' AND g.DeviceLoginName='3090' GROUP BY g.time, g.Distance; CountAzimuth:899 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-31 1:51:6' AND e.date<='2025-03-31 14:51:6' AND e.DeviceLoginName='358021081803706' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 22:51:06' AND g.time<='2025-03-31 11:51:06' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:787 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-28 23:59:3' AND e.DeviceLoginName='356078111430837' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-28 20:59:03' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:113 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:3' AND e.DeviceLoginName='356078111430837' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:03' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:2 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 0:0:0' AND e.date<='2025-03-31 6:0:3' AND e.DeviceLoginName='356078111430837' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 21:00:00' AND g.time<='2025-03-31 03:00:03' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:1355 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 0:0:0' AND e.date<='2025-03-30 6:0:3' AND e.DeviceLoginName='356078111430837' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-29 21:00:00' AND g.time<='2025-03-30 02:00:03' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:6 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-31 0:0:0' AND e.date<='2025-03-31 6:0:3' AND e.DeviceLoginName='356078111430837' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 21:00:00' AND g.time<='2025-03-31 03:00:03' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:6 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 5:0:3' AND e.DeviceLoginName='356078111430837' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:03' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:47 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-30 23:0:0' AND e.date<='2025-03-31 5:0:3' AND e.DeviceLoginName='5130' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-30 20:00:00' AND g.time<='2025-03-31 02:00:03' AND g.DeviceLoginName='5130' GROUP BY g.time, g.Distance; CountAzimuth:359 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 23:0:0' AND e.date<='2025-03-29 5:0:3' AND e.DeviceLoginName='3089' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 20:00:00' AND g.time<='2025-03-29 02:00:03' AND g.DeviceLoginName='3089' GROUP BY g.time, g.Distance; CountAzimuth:999 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:0:0' AND e.date<='2025-03-29 6:0:3' AND e.DeviceLoginName='3089' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-28 21:00:00' AND g.time<='2025-03-29 03:00:03' AND g.DeviceLoginName='3089' GROUP BY g.time, g.Distance; CountAzimuth:454 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-27 17:40:0' AND e.date<='2025-03-27 18:0:3' AND e.DeviceLoginName='356078111430837' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 14:40:00' AND g.time<='2025-03-27 15:00:03' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-27 17:40:0' AND e.date<='2025-03-27 18:16:3' AND e.DeviceLoginName='356078111430837' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 14:40:00' AND g.time<='2025-03-27 15:16:03' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-27 3:9:57' AND e.date<='2025-03-27 23:9:57' AND e.DeviceLoginName='356078111430837' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 00:09:57' AND g.time<='2025-03-27 20:09:57' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:2367 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-27 17:30:57' AND e.date<='2025-03-27 18:10:57' AND e.DeviceLoginName='356078111430837' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 14:30:57' AND g.time<='2025-03-27 15:10:57' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:28 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-27 17:30:57' AND e.date<='2025-03-27 18:30:57' AND e.DeviceLoginName='356078111430837' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 14:30:57' AND g.time<='2025-03-27 15:30:57' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:79 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-31 8:12:31' AND e.date<='2025-03-31 15:12:31' AND e.DeviceLoginName='356078116278207' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-31 05:12:31' AND g.time<='2025-03-31 12:12:31' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:323 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-27 11:30:57' AND e.date<='2025-03-27 12:30:57' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-03-27 08:30:57' AND g.time<='2025-03-27 09:30:57' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:190