Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-20 8:4:15' AND e.date<='2024-05-20 23:4:15' 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-20 05:04:15' AND g.time<='2024-05-20 20:04:15' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1449 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-21 6:7:37' AND e.date<='2024-05-21 8:7:37' 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-21 03:07:37' AND g.time<='2024-05-21 05:07:37' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-20 8:7:55' AND e.date<='2024-05-21 8:7:55' 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-20 05:07:55' AND g.time<='2024-05-21 05:07:55' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:1760 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-06 8:53:12' AND e.date<='2024-05-21 8:53:12' AND e.DeviceLoginName='3167' 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-06 05:53:12' AND g.time<='2024-05-21 05:53:12' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:20391 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-06 0:53:12' AND e.date<='2024-05-06 23:53:12' AND e.DeviceLoginName='3167' 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-05 21:53:12' AND g.time<='2024-05-06 20:53:12' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:344 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-07 0:53:12' AND e.date<='2024-05-07 23:53:12' AND e.DeviceLoginName='3167' 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-06 21:53:12' AND g.time<='2024-05-07 20:53:12' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:2167 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-08 0:53:12' AND e.date<='2024-05-08 23:53:12' AND e.DeviceLoginName='3167' 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:53:12' AND g.time<='2024-05-08 20:53:12' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:940 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-09 0:53:12' AND e.date<='2024-05-09 23:53:12' AND e.DeviceLoginName='3167' 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-08 21:53:12' AND g.time<='2024-05-09 20:53:12' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:661 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-10 0:53:12' AND e.date<='2024-05-10 23:53:12' AND e.DeviceLoginName='3167' 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-09 21:53:12' AND g.time<='2024-05-10 20:53:12' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:865 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-13 0:53:12' AND e.date<='2024-05-13 23:53:12' AND e.DeviceLoginName='3167' 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-12 21:53:12' AND g.time<='2024-05-13 20:53:12' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:1620 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 0:53:12' AND e.date<='2024-05-14 23:53:12' AND e.DeviceLoginName='3167' 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:53:12' AND g.time<='2024-05-14 20:53:12' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:2272 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-15 0:53:12' AND e.date<='2024-05-15 23:53:12' AND e.DeviceLoginName='3167' 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-14 21:53:12' AND g.time<='2024-05-15 20:53:12' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:2834 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-16 0:53:12' AND e.date<='2024-05-16 23:53:12' AND e.DeviceLoginName='3167' 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-15 21:53:12' AND g.time<='2024-05-16 20:53:12' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:3052 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-17 0:53:12' AND e.date<='2024-05-17 23:53:12' AND e.DeviceLoginName='3167' 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-16 21:53:12' AND g.time<='2024-05-17 20:53:12' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:1779 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-20 0:53:12' AND e.date<='2024-05-20 23:53:12' AND e.DeviceLoginName='3167' 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-19 21:53:12' AND g.time<='2024-05-20 20:53:12' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:2484 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-20 9:18:10' AND e.date<='2024-05-20 9:18:10' AND e.DeviceLoginName='3167' 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-20 06:18:10' AND g.time<='2024-05-20 06:18:10' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-20 0:18:10' AND e.date<='2024-05-20 23:18:10' AND e.DeviceLoginName='3167' 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-19 21:18:10' AND g.time<='2024-05-20 20:18:10' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:2484 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-20 0:56:1' AND e.date<='2024-05-20 23:56:1' AND e.DeviceLoginName='2722' 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-19 21:56:01' AND g.time<='2024-05-20 20:56:01' AND g.DeviceLoginName='2722' GROUP BY g.time, g.Distance; CountAzimuth:907 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-21 0:56:1' AND e.date<='2024-05-21 23:56:1' AND e.DeviceLoginName='2722' 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-20 21:56:01' AND g.time<='2024-05-21 20:56:01' AND g.DeviceLoginName='2722' GROUP BY g.time, g.Distance; CountAzimuth:492 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-16 0:56:1' AND e.date<='2024-05-16 23:56:1' AND e.DeviceLoginName='2722' 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-15 21:56:01' AND g.time<='2024-05-16 20:56:01' AND g.DeviceLoginName='2722' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-15 0:56:1' AND e.date<='2024-05-15 23:56:1' AND e.DeviceLoginName='2722' 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-14 21:56:01' AND g.time<='2024-05-15 20:56:01' AND g.DeviceLoginName='2722' GROUP BY g.time, g.Distance; CountAzimuth:611 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-20 0:56:1' AND e.date<='2024-05-20 23:56:1' AND e.DeviceLoginName='2722' 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-19 21:56:01' AND g.time<='2024-05-20 20:56:01' AND g.DeviceLoginName='2722' GROUP BY g.time, g.Distance; CountAzimuth:907 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-21 0:56:1' AND e.date<='2024-05-21 23:56:1' AND e.DeviceLoginName='2722' 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-20 21:56:01' AND g.time<='2024-05-21 20:56:01' AND g.DeviceLoginName='2722' GROUP BY g.time, g.Distance; CountAzimuth:492 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-21 0:5:33' AND e.date<='2024-05-21 12:5:33' AND e.DeviceLoginName='2556' 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-20 21:05:33' AND g.time<='2024-05-21 09:05:33' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:114 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-21 3:6:7' AND e.date<='2024-05-21 12:6:7' 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-05-21 00:06:07' AND g.time<='2024-05-21 09:06:07' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:352 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-21 3:6:55' AND e.date<='2024-05-21 12:6:55' AND e.DeviceLoginName='2473' 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 00:06:55' AND g.time<='2024-05-21 09:06:55' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:467 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-21 0:50:26' AND e.date<='2024-05-21 13:50:26' 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-20 21:50:26' AND g.time<='2024-05-21 10:50:26' 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-05-21 0:31:37' AND e.date<='2024-05-21 23:31:37' AND e.DeviceLoginName='354836080357964' 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-20 21:31:37' AND g.time<='2024-05-21 20:31:37' AND g.DeviceLoginName='354836080357964' GROUP BY g.time, g.Distance; CountAzimuth:1124 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-20 0:32:59' AND e.date<='2024-05-21 15:32:59' AND e.DeviceLoginName='355234055575019' 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-19 21:32:59' AND g.time<='2024-05-21 12:32:59' AND g.DeviceLoginName='355234055575019' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-21 0:32:59' AND e.date<='2024-05-21 15:32:59' AND e.DeviceLoginName='355234055575019' 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-20 21:32:59' AND g.time<='2024-05-21 12:32:59' AND g.DeviceLoginName='355234055575019' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-21 11:46:39' AND e.date<='2024-05-21 15:46:39' AND e.DeviceLoginName='354836080357964' 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 08:46:39' AND g.time<='2024-05-21 12:46:39' AND g.DeviceLoginName='354836080357964' GROUP BY g.time, g.Distance; CountAzimuth:815