Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-03 0:2:42' AND e.date<='2024-07-03 23:2:42' AND e.DeviceLoginName='352353083473741' 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>='2024-07-02 21:02:42' AND g.time<='2024-07-03 20:02:42' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:4816 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-04 5:32:35' AND e.date<='2024-07-04 9:32:35' 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>='2024-07-04 02:32:35' AND g.time<='2024-07-04 06:32:35' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:279 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-03 0:2:42' AND e.date<='2024-07-03 23:2:42' AND e.DeviceLoginName='352353083473741' 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>='2024-07-02 21:02:42' AND g.time<='2024-07-03 20:02:42' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:4816 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-04 4:10:40' AND e.date<='2024-07-04 12:10:40' 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>='2024-07-04 01:10:40' AND g.time<='2024-07-04 09:10:40' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:211 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-03 0:11:8' AND e.date<='2024-07-03 23:11:8' 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>='2024-07-02 21:11:08' AND g.time<='2024-07-03 20:11:08' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:421 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-03 0:11:58' AND e.date<='2024-07-03 23:11:58' 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>='2024-07-02 21:11:58' AND g.time<='2024-07-03 20:11:58' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:737 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:7:59' AND e.date<='2024-06-17 23:7:59' AND e.DeviceLoginName='352353086180491' 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>='2024-06-16 21:07:59' AND g.time<='2024-06-17 20:07:59' AND g.DeviceLoginName='352353086180491' GROUP BY g.time, g.Distance; CountAzimuth:1600 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-04 10:12:46' AND e.date<='2024-07-04 13:12:46' 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>='2024-07-04 07:12:46' AND g.time<='2024-07-04 10:12:46' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:289 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-04 6:20:30' AND e.date<='2024-07-04 13:20:30' 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>='2024-07-04 03:20:30' AND g.time<='2024-07-04 10:20:30' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:483 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-03 15:44:6' AND e.date<='2024-07-04 15:44:6' AND e.DeviceLoginName='2647' 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>='2024-07-03 12:44:06' AND g.time<='2024-07-04 12:44:06' AND g.DeviceLoginName='2647' GROUP BY g.time, g.Distance; CountAzimuth:1891 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-01 15:44:14' AND e.date<='2024-07-04 15:44:14' AND e.DeviceLoginName='2647' 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>='2024-07-01 12:44:14' AND g.time<='2024-07-04 12:44:14' AND g.DeviceLoginName='2647' GROUP BY g.time, g.Distance; CountAzimuth:4146 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-04 0:46:21' AND e.date<='2024-07-04 15:46:21' AND e.DeviceLoginName='2590' 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>='2024-07-03 21:46:21' AND g.time<='2024-07-04 12:46:21' AND g.DeviceLoginName='2590' GROUP BY g.time, g.Distance; CountAzimuth:1085