Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-04 0:14:59' AND e.date<='2024-09-04 8:14:59' 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-09-03 21:14:59' AND g.time<='2024-09-04 05:14:59' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:372 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-03 8:15:58' AND e.date<='2024-09-03 23:15:58' 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-09-03 05:15:58' AND g.time<='2024-09-03 20:15:58' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1017 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-04 6:1:47' AND e.date<='2024-09-04 9:1:47' 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-09-04 03:01:47' AND g.time<='2024-09-04 06:01:47' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:422 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-03 0:2:29' AND e.date<='2024-09-03 23:2:29' AND e.DeviceLoginName='2627' 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-09-02 21:02:29' AND g.time<='2024-09-03 20:02:29' AND g.DeviceLoginName='2627' GROUP BY g.time, g.Distance; CountAzimuth:482 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-04 0:23:28' AND e.date<='2024-09-04 9:23:28' 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-09-03 21:23:28' AND g.time<='2024-09-04 06:23:28' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:421 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-04 0:46:37' AND e.date<='2024-09-04 9:46:37' 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-09-03 21:46:37' AND g.time<='2024-09-04 06:46:37' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:490 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-03 0:2:29' AND e.date<='2024-08-04 23:2:29' AND e.DeviceLoginName='2735' 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-08-02 21:02:29' AND g.time<='2024-08-04 20:02:29' AND g.DeviceLoginName='2735' GROUP BY g.time, g.Distance; CountAzimuth:1430 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-10 0:2:29' AND e.date<='2024-08-11 23:2:29' AND e.DeviceLoginName='2735' 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-08-09 21:02:29' AND g.time<='2024-08-11 20:02:29' AND g.DeviceLoginName='2735' GROUP BY g.time, g.Distance; CountAzimuth:1230 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-10 0:2:29' AND e.date<='2024-08-11 23:2:29' AND e.DeviceLoginName='2809' 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-08-09 21:02:29' AND g.time<='2024-08-11 20:02:29' AND g.DeviceLoginName='2809' GROUP BY g.time, g.Distance; CountAzimuth:1336 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-03 0:2:29' AND e.date<='2024-08-04 23:2:29' AND e.DeviceLoginName='2809' 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-08-02 21:02:29' AND g.time<='2024-08-04 20:02:29' AND g.DeviceLoginName='2809' GROUP BY g.time, g.Distance; CountAzimuth:1195 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-03 0:2:29' AND e.date<='2024-08-04 23:2:29' 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>='2024-08-02 21:02:29' AND g.time<='2024-08-04 20:02:29' AND g.DeviceLoginName='4861' GROUP BY g.time, g.Distance; CountAzimuth:3053 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-10 0:2:29' AND e.date<='2024-08-11 23:2:29' 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>='2024-08-09 21:02:29' AND g.time<='2024-08-11 20:02:29' AND g.DeviceLoginName='4861' GROUP BY g.time, g.Distance; CountAzimuth:93 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-17 0:2:29' AND e.date<='2024-08-18 23:2:29' 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>='2024-08-16 21:02:29' AND g.time<='2024-08-18 20:02:29' AND g.DeviceLoginName='4861' GROUP BY g.time, g.Distance; CountAzimuth:997 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-24 0:2:29' AND e.date<='2024-08-25 23:2:29' 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>='2024-08-23 21:02:29' AND g.time<='2024-08-25 20:02:29' AND g.DeviceLoginName='4861' GROUP BY g.time, g.Distance; CountAzimuth:2020 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-31 0:2:29' AND e.date<='2024-08-31 23:2:29' 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>='2024-08-30 21:02:29' AND g.time<='2024-08-31 20:02:29' AND g.DeviceLoginName='4861' GROUP BY g.time, g.Distance; CountAzimuth:607 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-31 0:2:29' AND e.date<='2024-08-31 23:2:29' AND e.DeviceLoginName='2566' 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-08-30 21:02:29' AND g.time<='2024-08-31 20:02:29' AND g.DeviceLoginName='2566' GROUP BY g.time, g.Distance; CountAzimuth:288 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-03 0:2:29' AND e.date<='2024-08-04 23:2:29' AND e.DeviceLoginName='2566' 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-08-02 21:02:29' AND g.time<='2024-08-04 20:02:29' AND g.DeviceLoginName='2566' GROUP BY g.time, g.Distance; CountAzimuth:854 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-10 0:2:29' AND e.date<='2024-08-11 23:2:29' AND e.DeviceLoginName='2566' 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-08-09 21:02:29' AND g.time<='2024-08-11 20:02:29' AND g.DeviceLoginName='2566' GROUP BY g.time, g.Distance; CountAzimuth:748 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-17 0:2:29' AND e.date<='2024-08-18 23:2:29' AND e.DeviceLoginName='2566' 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-08-16 21:02:29' AND g.time<='2024-08-18 20:02:29' AND g.DeviceLoginName='2566' GROUP BY g.time, g.Distance; CountAzimuth:967 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-17 0:2:29' AND e.date<='2024-08-18 23:2:29' 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-08-16 21:02:29' AND g.time<='2024-08-18 20:02:29' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:980 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-10 0:2:29' AND e.date<='2024-08-11 23:2:29' 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-08-09 21:02:29' AND g.time<='2024-08-11 20:02:29' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:2591 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 0:2:29' AND e.date<='2024-08-26 23:2:29' AND e.DeviceLoginName='353173067115228' 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-08-25 21:02:29' AND g.time<='2024-08-26 20:02:29' AND g.DeviceLoginName='353173067115228' GROUP BY g.time, g.Distance; CountAzimuth:702 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 0:2:29' AND e.date<='2024-08-27 23:2:29' AND e.DeviceLoginName='353173067115228' 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-08-26 21:02:29' AND g.time<='2024-08-27 20:02:29' AND g.DeviceLoginName='353173067115228' GROUP BY g.time, g.Distance; CountAzimuth:1290 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-28 0:2:29' AND e.date<='2024-08-28 23:2:29' AND e.DeviceLoginName='353173067115228' 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-08-27 21:02:29' AND g.time<='2024-08-28 20:02:29' AND g.DeviceLoginName='353173067115228' GROUP BY g.time, g.Distance; CountAzimuth:1363 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-29 0:2:29' AND e.date<='2024-08-29 23:2:29' AND e.DeviceLoginName='353173067115228' 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-08-28 21:02:29' AND g.time<='2024-08-29 20:02:29' AND g.DeviceLoginName='353173067115228' GROUP BY g.time, g.Distance; CountAzimuth:1695 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 0:2:29' AND e.date<='2024-08-30 23:2:29' AND e.DeviceLoginName='353173067115228' 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-08-29 21:02:29' AND g.time<='2024-08-30 20:02:29' AND g.DeviceLoginName='353173067115228' GROUP BY g.time, g.Distance; CountAzimuth:519 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 0:2:29' AND e.date<='2024-08-30 23:2:29' AND e.DeviceLoginName='353173067115228' 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-08-29 21:02:29' AND g.time<='2024-08-30 20:02:29' AND g.DeviceLoginName='353173067115228' GROUP BY g.time, g.Distance; CountAzimuth:519 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-31 0:2:29' AND e.date<='2024-08-31 23:2:29' AND e.DeviceLoginName='353173067115228' 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-08-30 21:02:29' AND g.time<='2024-08-31 20:02:29' AND g.DeviceLoginName='353173067115228' GROUP BY g.time, g.Distance; CountAzimuth:590 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-03 0:2:29' AND e.date<='2024-09-03 23:2:29' AND e.DeviceLoginName='2908' 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-09-02 21:02:29' AND g.time<='2024-09-03 20:02:29' AND g.DeviceLoginName='2908' GROUP BY g.time, g.Distance; CountAzimuth:4552 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 0:15:3' AND e.date<='2024-08-30 23:15:3' 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-08-25 21:15:03' AND g.time<='2024-08-30 20:15:03' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:9276 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-02 0:15:3' AND e.date<='2024-09-04 23:15:3' 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-09-01 21:15:03' AND g.time<='2024-09-04 20:15:03' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:5405