Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:31:37' AND e.date<='2024-07-16 23:31:37' AND e.DeviceLoginName='3155' 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-15 21:31:37' AND g.time<='2024-07-16 20:31:37' AND g.DeviceLoginName='3155' GROUP BY g.time, g.Distance; CountAzimuth:2945 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 9:51:11' AND e.date<='2024-07-18 9:51:11' AND e.DeviceLoginName='3091' 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-17 06:51:11' AND g.time<='2024-07-18 06:51:11' AND g.DeviceLoginName='3091' GROUP BY g.time, g.Distance; CountAzimuth:2386 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-01 0:51:11' AND e.date<='2024-07-01 23:51:11' AND e.DeviceLoginName='3091' 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-30 21:51:11' AND g.time<='2024-07-01 20:51:11' AND g.DeviceLoginName='3091' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-02 0:51:11' AND e.date<='2024-07-02 23:51:11' AND e.DeviceLoginName='3091' 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 21:51:11' AND g.time<='2024-07-02 20:51:11' AND g.DeviceLoginName='3091' GROUP BY g.time, g.Distance; CountAzimuth:1212 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-03 0:51:11' AND e.date<='2024-07-03 23:51:11' AND e.DeviceLoginName='3091' 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:51:11' AND g.time<='2024-07-03 20:51:11' AND g.DeviceLoginName='3091' GROUP BY g.time, g.Distance; CountAzimuth:2541 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-04 0:51:11' AND e.date<='2024-07-04 23:51:11' AND e.DeviceLoginName='3091' 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:51:11' AND g.time<='2024-07-04 20:51:11' AND g.DeviceLoginName='3091' GROUP BY g.time, g.Distance; CountAzimuth:2358 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 0:18:14' AND e.date<='2024-07-17 23:18:14' AND e.DeviceLoginName='2630' 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-16 21:18:14' AND g.time<='2024-07-17 20:18:14' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:1041 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 0:18:14' AND e.date<='2024-07-15 23:18:14' AND e.DeviceLoginName='2630' 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-14 21:18:14' AND g.time<='2024-07-15 20:18:14' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:529 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:18:14' AND e.date<='2024-07-16 23:18:14' AND e.DeviceLoginName='2630' 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-15 21:18:14' AND g.time<='2024-07-16 20:18:14' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:883 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 0:18:14' AND e.date<='2024-07-17 23:18:14' AND e.DeviceLoginName='2630' 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-16 21:18:14' AND g.time<='2024-07-17 20:18:14' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:1041 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 5:22:26' AND e.date<='2024-07-17 23:22:26' AND e.DeviceLoginName='2615' 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-17 02:22:26' AND g.time<='2024-07-17 20:22:26' AND g.DeviceLoginName='2615' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-18 5:22:26' AND e.date<='2024-07-18 23:22:26' AND e.DeviceLoginName='2615' 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-18 02:22:26' AND g.time<='2024-07-18 20:22:26' AND g.DeviceLoginName='2615' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 5:22:26' AND e.date<='2024-07-16 23:22:26' AND e.DeviceLoginName='2615' 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-16 02:22:26' AND g.time<='2024-07-16 20:22:26' AND g.DeviceLoginName='2615' GROUP BY g.time, g.Distance; CountAzimuth:484 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 12:50:26' AND e.date<='2024-07-18 12:50:26' AND e.DeviceLoginName='353173060488002' 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-17 09:50:26' AND g.time<='2024-07-18 09:50:26' AND g.DeviceLoginName='353173060488002' GROUP BY g.time, g.Distance; CountAzimuth:273 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:51:3' AND e.date<='2024-07-16 23:51:3' AND e.DeviceLoginName='353173060488002' 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-15 21:51:03' AND g.time<='2024-07-16 20:51:03' AND g.DeviceLoginName='353173060488002' GROUP BY g.time, g.Distance; CountAzimuth:364 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 0:51:3' AND e.date<='2024-07-15 23:51:3' AND e.DeviceLoginName='353173060488002' 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-14 21:51:03' AND g.time<='2024-07-15 20:51:03' AND g.DeviceLoginName='353173060488002' GROUP BY g.time, g.Distance; CountAzimuth:85 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:51:3' AND e.date<='2024-07-16 23:51:3' AND e.DeviceLoginName='353173060488002' 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-15 21:51:03' AND g.time<='2024-07-16 20:51:03' AND g.DeviceLoginName='353173060488002' GROUP BY g.time, g.Distance; CountAzimuth:364 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 0:51:3' AND e.date<='2024-07-17 23:51:3' AND e.DeviceLoginName='353173060488002' 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-16 21:51:03' AND g.time<='2024-07-17 20:51:03' AND g.DeviceLoginName='353173060488002' GROUP BY g.time, g.Distance; CountAzimuth:273 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-18 0:51:3' AND e.date<='2024-07-18 23:51:3' AND e.DeviceLoginName='353173060488002' 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-17 21:51:03' AND g.time<='2024-07-18 20:51:03' AND g.DeviceLoginName='353173060488002' GROUP BY g.time, g.Distance; CountAzimuth:125 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 0:51:3' AND e.date<='2024-07-15 23:51:3' AND e.DeviceLoginName='353173060488002' 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-14 21:51:03' AND g.time<='2024-07-15 20:51:03' AND g.DeviceLoginName='353173060488002' GROUP BY g.time, g.Distance; CountAzimuth:85 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-18 0:28:34' AND e.date<='2024-07-18 23:28:34' AND e.DeviceLoginName='3155' 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-17 21:28:34' AND g.time<='2024-07-18 20:28:34' AND g.DeviceLoginName='3155' GROUP BY g.time, g.Distance; CountAzimuth:1393 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-18 0:28:34' AND e.date<='2024-07-18 23:28:34' AND e.DeviceLoginName='352353085630389' 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-17 21:28:34' AND g.time<='2024-07-18 20:28:34' AND g.DeviceLoginName='352353085630389' GROUP BY g.time, g.Distance; CountAzimuth:851 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 0:28:34' AND e.date<='2024-07-17 23:28:34' AND e.DeviceLoginName='352353085630389' 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-16 21:28:34' AND g.time<='2024-07-17 20:28:34' AND g.DeviceLoginName='352353085630389' GROUP BY g.time, g.Distance; CountAzimuth:1242 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:28:34' AND e.date<='2024-07-16 23:28:34' AND e.DeviceLoginName='352353085630389' 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-15 21:28:34' AND g.time<='2024-07-16 20:28:34' AND g.DeviceLoginName='352353085630389' GROUP BY g.time, g.Distance; CountAzimuth:633 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 0:28:34' AND e.date<='2024-07-15 23:28:34' AND e.DeviceLoginName='352353085630389' 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-14 21:28:34' AND g.time<='2024-07-15 20:28:34' AND g.DeviceLoginName='352353085630389' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:28:34' AND e.date<='2024-07-16 23:28:34' AND e.DeviceLoginName='352353085630389' 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-15 21:28:34' AND g.time<='2024-07-16 20:28:34' AND g.DeviceLoginName='352353085630389' GROUP BY g.time, g.Distance; CountAzimuth:633 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-18 0:28:34' AND e.date<='2024-07-18 23:28:34' AND e.DeviceLoginName='352353085630389' 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-17 21:28:34' AND g.time<='2024-07-18 20:28:34' AND g.DeviceLoginName='352353085630389' GROUP BY g.time, g.Distance; CountAzimuth:851 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 0:28:34' AND e.date<='2024-07-17 23:28:34' AND e.DeviceLoginName='352353085630389' 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-16 21:28:34' AND g.time<='2024-07-17 20:28:34' AND g.DeviceLoginName='352353085630389' GROUP BY g.time, g.Distance; CountAzimuth:1242 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:28:34' AND e.date<='2024-07-16 23:28:34' AND e.DeviceLoginName='352353085630389' 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-15 21:28:34' AND g.time<='2024-07-16 20:28:34' AND g.DeviceLoginName='352353085630389' GROUP BY g.time, g.Distance; CountAzimuth:633