Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-29 0:43:49' AND e.date<='2024-05-29 8:43:49' AND e.DeviceLoginName='5046' 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-05-28 21:43:49' AND g.time<='2024-05-29 05:43:49' AND g.DeviceLoginName='5046' GROUP BY g.time, g.Distance; CountAzimuth:112 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-29 1:44:13' AND e.date<='2024-05-29 8:44:13' AND e.DeviceLoginName='352353084175477' 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-05-28 22:44:13' AND g.time<='2024-05-29 05:44:13' AND g.DeviceLoginName='352353084175477' GROUP BY g.time, g.Distance; CountAzimuth:96 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-29 1:54:7' AND e.date<='2024-05-29 12:54:7' 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-05-28 22:54:07' AND g.time<='2024-05-29 09:54:07' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:1520 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-03 0:8:17' AND e.date<='2024-05-03 23:8:17' 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-05-02 21:08:17' AND g.time<='2024-05-03 20:08:17' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:3167 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-08 0:8:17' AND e.date<='2024-05-08 23:8:17' 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-05-07 21:08:17' AND g.time<='2024-05-08 20:08:17' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:4330 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 0:8:17' AND e.date<='2024-05-14 23:8:17' 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-05-13 21:08:17' AND g.time<='2024-05-14 20:08:17' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:3653 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-22 0:8:17' AND e.date<='2024-05-22 23:8:17' 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-05-21 21:08:17' AND g.time<='2024-05-22 20:08:17' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:3754 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-28 0:8:17' AND e.date<='2024-05-29 23:8:17' 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-05-27 21:08:17' AND g.time<='2024-05-29 20:08:17' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:4030 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-29 5:35:46' AND e.date<='2024-05-29 13:35: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>='2024-05-29 02:35:46' AND g.time<='2024-05-29 10:35:46' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:642 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-28 13:45:34' AND e.date<='2024-05-29 13:45:34' 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-05-28 10:45:34' AND g.time<='2024-05-29 10:45:34' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:2982 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-03 0:45:34' AND e.date<='2024-05-03 23:45:34' 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-05-02 21:45:34' AND g.time<='2024-05-03 20:45:34' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:3167 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 0:45:34' AND e.date<='2024-05-14 23:45:34' 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-05-13 21:45:34' AND g.time<='2024-05-14 20:45:34' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:3653 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-22 0:45:34' AND e.date<='2024-05-22 23:45:34' 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-05-21 21:45:34' AND g.time<='2024-05-22 20:45:34' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:3754 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-03 0:45:34' AND e.date<='2024-05-06 23:45:34' 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-05-02 21:45:34' AND g.time<='2024-05-06 20:45:34' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:3178 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-04 0:45:34' AND e.date<='2024-05-05 23:45:34' 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-05-03 21:45:34' AND g.time<='2024-05-05 20:45:34' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:8 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-11 0:45:34' AND e.date<='2024-05-12 23:45:34' 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-05-10 21:45:34' AND g.time<='2024-05-12 20:45:34' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:1259 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-22 0:45:34' AND e.date<='2024-05-29 23:45:34' AND e.DeviceLoginName='356078118085311' 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-05-21 21:45:34' AND g.time<='2024-05-29 20:45:34' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:9488 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-25 0:45:34' AND e.date<='2024-05-26 23:45:34' AND e.DeviceLoginName='356078118085311' 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-05-24 21:45:34' AND g.time<='2024-05-26 20:45:34' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:2520 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-18 0:45:34' AND e.date<='2024-05-19 23:45:34' AND e.DeviceLoginName='356078118085311' 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-05-17 21:45:34' AND g.time<='2024-05-19 20:45:34' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:2370 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-28 0:45:34' AND e.date<='2024-05-28 23:45:34' AND e.DeviceLoginName='356078118085311' 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-05-27 21:45:34' AND g.time<='2024-05-28 20:45:34' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:2044 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 0:7:5' AND e.date<='2024-05-29 16:7:5' AND e.DeviceLoginName='2506' 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-05-13 21:07:05' AND g.time<='2024-05-29 13:07:05' AND g.DeviceLoginName='2506' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-28 22:40:49' AND e.date<='2024-05-29 22:40:49' AND e.DeviceLoginName='4884' 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-05-28 19:40:49' AND g.time<='2024-05-29 19:40:49' AND g.DeviceLoginName='4884' GROUP BY g.time, g.Distance; CountAzimuth:164