Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-22 0:0:40' AND e.date<='2024-01-22 23:0:40' AND e.DeviceLoginName='2871' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-21 22:00:40' AND g.time<='2024-01-22 21:00:40' AND g.DeviceLoginName='2871' GROUP BY g.time, g.Distance; CountAzimuth:290 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-23 5:5:48' AND e.date<='2024-01-23 9:5:48' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-23 03:05:48' AND g.time<='2024-01-23 07:05:48' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:296 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-22 14:6:48' AND e.date<='2024-01-22 23:6:48' 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>='2024-01-22 12:06:48' AND g.time<='2024-01-22 21:06:48' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:503 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-22 15:7:34' AND e.date<='2024-01-22 23:7:34' 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>='2024-01-22 13:07:34' AND g.time<='2024-01-22 21:07:34' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:317 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-22 11:8:15' AND e.date<='2024-01-22 23:8:15' 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>='2024-01-22 09:08:15' AND g.time<='2024-01-22 21:08:15' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:605 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-22 9:8:41' AND e.date<='2024-01-22 23:8:41' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-22 07:08:41' AND g.time<='2024-01-22 21:08:41' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:564 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-22 9:10:4' AND e.date<='2024-01-22 23:10:4' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-22 07:10:04' AND g.time<='2024-01-22 21:10:04' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:996 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-23 0:23:35' AND e.date<='2024-01-23 23:23:35' 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>='2024-01-22 22:23:35' AND g.time<='2024-01-23 21:23:35' AND g.DeviceLoginName='4884' GROUP BY g.time, g.Distance; CountAzimuth:164 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 0:38:47' AND e.date<='2024-01-09 23:38:47' AND e.DeviceLoginName='2871' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-08 22:38:47' AND g.time<='2024-01-09 21:38:47' AND g.DeviceLoginName='2871' GROUP BY g.time, g.Distance; CountAzimuth:4315 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-22 10:39:31' AND e.date<='2024-01-23 10:39:31' AND e.DeviceLoginName='2871' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-22 08:39:31' AND g.time<='2024-01-23 08:39:31' AND g.DeviceLoginName='2871' GROUP BY g.time, g.Distance; CountAzimuth:1081 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-23 7:6:53' AND e.date<='2024-01-23 11:6: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>='2024-01-23 05:06:53' AND g.time<='2024-01-23 09:06:53' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:566 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-23 0:39:55' AND e.date<='2024-01-23 13:39:55' AND e.DeviceLoginName='2871' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-22 22:39:55' AND g.time<='2024-01-23 11:39:55' AND g.DeviceLoginName='2871' GROUP BY g.time, g.Distance; CountAzimuth:1898 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 14:30:10' AND e.date<='2023-12-26 14:34:10' AND e.DeviceLoginName='2783' 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>='2023-12-26 12:30:10' AND g.time<='2023-12-26 12:34:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:39 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 14:27:10' AND e.date<='2023-12-26 14:30:10' AND e.DeviceLoginName='2783' 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>='2023-12-26 12:27:10' AND g.time<='2023-12-26 12:30:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 15:43:10' AND e.date<='2023-12-27 15:45:10' AND e.DeviceLoginName='2783' 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>='2023-12-27 13:43:10' AND g.time<='2023-12-27 13:45:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:4 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 11:30:10' AND e.date<='2023-12-28 11:33:10' AND e.DeviceLoginName='2783' 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>='2023-12-28 09:30:10' AND g.time<='2023-12-28 09:33:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 11:30:10' AND e.date<='2023-12-28 11:33:10' AND e.DeviceLoginName='2783' 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>='2023-12-28 09:30:10' AND g.time<='2023-12-28 09:33:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 8:30:10' AND e.date<='2023-12-28 15:33:10' AND e.DeviceLoginName='2783' 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>='2023-12-28 06:30:10' AND g.time<='2023-12-28 13:33:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:1790 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-02 14:38:10' AND e.date<='2024-01-02 14:44:10' AND e.DeviceLoginName='2783' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-02 12:38:10' AND g.time<='2024-01-02 12:44:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:45 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-04 10:48:10' AND e.date<='2024-01-04 10:52:10' AND e.DeviceLoginName='2783' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-04 08:48:10' AND g.time<='2024-01-04 08:52:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:20 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-05 16:0:10' AND e.date<='2024-01-05 16:5:10' AND e.DeviceLoginName='2783' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-05 14:00:10' AND g.time<='2024-01-05 14:05:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:41 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-11 10:0:10' AND e.date<='2024-01-11 10:5:10' AND e.DeviceLoginName='2783' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-11 08:00:10' AND g.time<='2024-01-11 08:05:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:10 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-12 17:7:10' AND e.date<='2024-01-12 17:13:10' AND e.DeviceLoginName='2783' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-12 15:07:10' AND g.time<='2024-01-12 15:13:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-16 10:30:10' AND e.date<='2024-01-16 10:37:10' AND e.DeviceLoginName='2783' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-16 08:30:10' AND g.time<='2024-01-16 08:37:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:21 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-17 15:30:10' AND e.date<='2024-01-17 15:37:10' AND e.DeviceLoginName='2783' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-17 13:30:10' AND g.time<='2024-01-17 13:37:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:63 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-19 10:43:10' AND e.date<='2024-01-19 10:49:10' AND e.DeviceLoginName='2783' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-19 08:43:10' AND g.time<='2024-01-19 08:49:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:9 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-19 18:0:10' AND e.date<='2024-01-19 18:2:10' AND e.DeviceLoginName='2783' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-19 16:00:10' AND g.time<='2024-01-19 16:02:10' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:4 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-15 16:26:55' AND e.date<='2024-01-21 16:26:55' AND e.DeviceLoginName='352353084655866' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-15 14:26:55' AND g.time<='2024-01-21 14:26:55' AND g.DeviceLoginName='352353084655866' GROUP BY g.time, g.Distance; CountAzimuth:4316 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-22 0:49:49' AND e.date<='2024-01-23 16:49:49' AND e.DeviceLoginName='2486' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-01-21 22:49:49' AND g.time<='2024-01-23 14:49:49' AND g.DeviceLoginName='2486' GROUP BY g.time, g.Distance; CountAzimuth:2168