Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-22 9:34:31' AND e.date<='2024-08-21 9:34:31' AND e.DeviceLoginName='2633' 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-22 06:34:31' AND g.time<='2024-08-21 06:34:31' AND g.DeviceLoginName='2633' GROUP BY g.time, g.Distance; CountAzimuth:8180 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-22 9:34:31' AND e.date<='2024-08-18 9:34:31' AND e.DeviceLoginName='2633' 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-22 06:34:31' AND g.time<='2024-08-18 06:34:31' AND g.DeviceLoginName='2633' GROUP BY g.time, g.Distance; CountAzimuth:717 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 6:26:17' AND e.date<='2024-08-20 23:26:17' 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-20 03:26:17' AND g.time<='2024-08-20 20:26:17' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1848 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 1:27:29' AND e.date<='2024-08-21 10:27: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-20 22:27:29' AND g.time<='2024-08-21 07:27:29' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:331 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 5:42:43' AND e.date<='2024-08-21 10:42:43' 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-08-21 02:42:43' AND g.time<='2024-08-21 07:42:43' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:294 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 0:21:40' AND e.date<='2024-08-20 23:21:40' AND e.DeviceLoginName='356078111347361' 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-19 21:21:40' AND g.time<='2024-08-20 20:21:40' AND g.DeviceLoginName='356078111347361' GROUP BY g.time, g.Distance; CountAzimuth:1288 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 9:22:44' AND e.date<='2024-08-21 11:22:44' 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-21 06:22:44' AND g.time<='2024-08-21 08:22:44' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:112 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 8:34:56' AND e.date<='2024-08-21 11:34:56' 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-21 05:34:56' AND g.time<='2024-08-21 08:34:56' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:116 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-19 0:53:29' AND e.date<='2024-08-21 11:53:29' AND e.DeviceLoginName='352353084131751' 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-18 21:53:29' AND g.time<='2024-08-21 08:53:29' AND g.DeviceLoginName='352353084131751' GROUP BY g.time, g.Distance; CountAzimuth:4260 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 7:2:47' AND e.date<='2024-08-21 12:2: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-08-21 04:02:47' AND g.time<='2024-08-21 09:02:47' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:230 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 10:3:52' AND e.date<='2024-08-21 12:3:52' 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-21 07:03:52' AND g.time<='2024-08-21 09:03:52' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:191 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 9:11:35' AND e.date<='2024-08-21 12:11: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-08-21 06:11:35' AND g.time<='2024-08-21 09:11:35' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:292 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 9:11:55' AND e.date<='2024-08-21 12:11: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-08-21 06:11:55' AND g.time<='2024-08-21 09:11:55' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:521 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 10:12:21' AND e.date<='2024-08-21 12:12:21' 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-08-21 07:12:21' AND g.time<='2024-08-21 09:12:21' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:434 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 8:27:19' AND e.date<='2024-08-21 12:27:19' 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-21 05:27:19' AND g.time<='2024-08-21 09:27:19' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:401 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 8:39:10' AND e.date<='2024-08-21 12:39:10' 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-21 05:39:10' AND g.time<='2024-08-21 09:39:10' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:402 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 9:40:13' AND e.date<='2024-08-21 12:40:13' 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-08-21 06:40:13' AND g.time<='2024-08-21 09:40:13' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:415 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 10:41:4' AND e.date<='2024-08-21 12:41:4' 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-08-21 07:41:04' AND g.time<='2024-08-21 09:41:04' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:326 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 10:57:55' AND e.date<='2024-08-21 12:57:55' 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-21 07:57:55' AND g.time<='2024-08-21 09:57:55' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:401 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 11:2:8' AND e.date<='2024-08-21 13:2:8' 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-21 08:02:08' AND g.time<='2024-08-21 10:02:08' 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-08-21 5:38:1' AND e.date<='2024-08-21 13:38:1' 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-08-21 02:38:01' AND g.time<='2024-08-21 10:38:01' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:766 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 5:39:7' AND e.date<='2024-08-21 13:39: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-08-21 02:39:07' AND g.time<='2024-08-21 10:39:07' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:646 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 6:39:33' AND e.date<='2024-08-20 21:39:33' 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-08-20 03:39:33' AND g.time<='2024-08-20 18:39:33' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:449 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 9:40:10' AND e.date<='2024-08-21 13:40:10' 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-08-21 06:40:10' AND g.time<='2024-08-21 10:40:10' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:442 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 0:0:58' AND e.date<='2024-08-20 23:0:58' AND e.DeviceLoginName='2910' 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-19 21:00:58' AND g.time<='2024-08-20 20:00:58' AND g.DeviceLoginName='2910' GROUP BY g.time, g.Distance; CountAzimuth:3264