Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 3:23:34' AND e.date<='2024-04-01 23:23:34' 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-03-29 00:23:34' AND g.time<='2024-04-01 20:23:34' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:2213 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 2:24:39' AND e.date<='2024-04-01 7:24:39' 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-03-29 23:24:39' AND g.time<='2024-04-01 04:24:39' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:551 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 7:25:38' AND e.date<='2024-04-01 7:25:38' AND e.DeviceLoginName='358021081803706' 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-03-29 04:25:38' AND g.time<='2024-04-01 04:25:38' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:1538 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 7:27:52' AND e.date<='2024-04-01 7:27:52' 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-03-30 04:27:52' AND g.time<='2024-04-01 04:27:52' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:170 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='8997' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='8997' GROUP BY g.time, g.Distance; CountAzimuth:185 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='3123' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='3123' GROUP BY g.time, g.Distance; CountAzimuth:140 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='4849' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:164 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='3157' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='3157' GROUP BY g.time, g.Distance; CountAzimuth:31 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='3081' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='3081' GROUP BY g.time, g.Distance; CountAzimuth:510 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='354836080152241' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='354836080152241' GROUP BY g.time, g.Distance; CountAzimuth:14 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='2786' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='2786' GROUP BY g.time, g.Distance; CountAzimuth:123 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='2699' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='2699' GROUP BY g.time, g.Distance; CountAzimuth:69 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='356078111473472' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='356078111473472' GROUP BY g.time, g.Distance; CountAzimuth:544 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='353173060487822' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='353173060487822' GROUP BY g.time, g.Distance; CountAzimuth:121 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='5117' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:323 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='3124' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='3124' GROUP BY g.time, g.Distance; CountAzimuth:420 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='4861' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='9012' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='9012' GROUP BY g.time, g.Distance; CountAzimuth:127 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='2494' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='2494' GROUP BY g.time, g.Distance; CountAzimuth:39 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='3179' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:14 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='2492' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='2492' GROUP BY g.time, g.Distance; CountAzimuth:46 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='2714' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='2714' GROUP BY g.time, g.Distance; CountAzimuth:112 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='355234055521542' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='355234055521542' GROUP BY g.time, g.Distance; CountAzimuth:208 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='352353086185151' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='352353086185151' GROUP BY g.time, g.Distance; CountAzimuth:162 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='352353086185169' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='352353086185169' GROUP BY g.time, g.Distance; CountAzimuth:165 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='2519' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='2519' GROUP BY g.time, g.Distance; CountAzimuth:293 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='3100' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='3100' GROUP BY g.time, g.Distance; CountAzimuth:61 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='2927' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='2927' GROUP BY g.time, g.Distance; CountAzimuth:141 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='356078111451585' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='356078111451585' GROUP BY g.time, g.Distance; CountAzimuth:202 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='3197' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='3197' GROUP BY g.time, g.Distance; CountAzimuth:31 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 23:0:0' AND e.date<='2024-03-30 5:0:0' AND e.DeviceLoginName='2709' 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-03-29 20:00:00' AND g.time<='2024-03-30 02:00:00' AND g.DeviceLoginName='2709' GROUP BY g.time, g.Distance; CountAzimuth:218 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' AND e.DeviceLoginName='353173060485131' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:135 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' AND e.DeviceLoginName='2558' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='2558' GROUP BY g.time, g.Distance; CountAzimuth:268 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' AND e.DeviceLoginName='4849' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:196 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' AND e.DeviceLoginName='355234055234161' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='355234055234161' GROUP BY g.time, g.Distance; CountAzimuth:107 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' AND e.DeviceLoginName='5078' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='5078' GROUP BY g.time, g.Distance; CountAzimuth:177 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='352353084175477' GROUP BY g.time, g.Distance; CountAzimuth:85 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' AND e.DeviceLoginName='3179' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:551 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' AND e.DeviceLoginName='2714' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='2714' GROUP BY g.time, g.Distance; CountAzimuth:91 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' AND e.DeviceLoginName='2495' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='2495' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' AND e.DeviceLoginName='356078111326001' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='356078111326001' GROUP BY g.time, g.Distance; CountAzimuth:100 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' AND e.DeviceLoginName='356078111292955' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='356078111292955' GROUP BY g.time, g.Distance; CountAzimuth:148 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' AND e.DeviceLoginName='356078111445637' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='356078111445637' GROUP BY g.time, g.Distance; CountAzimuth:134 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' AND e.DeviceLoginName='3027' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='3027' GROUP BY g.time, g.Distance; CountAzimuth:42 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-30 23:0:0' AND e.date<='2024-03-31 5:0:0' AND e.DeviceLoginName='2709' 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-03-30 20:00:00' AND g.time<='2024-03-31 01:00:00' AND g.DeviceLoginName='2709' GROUP BY g.time, g.Distance; CountAzimuth:153 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-31 23:0:0' AND e.date<='2024-04-01 5:0:0' AND e.DeviceLoginName='353173060485131' 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-03-31 20:00:00' AND g.time<='2024-04-01 02:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:72 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-31 23:0:0' AND e.date<='2024-04-01 5:0:0' AND e.DeviceLoginName='2898' 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-03-31 20:00:00' AND g.time<='2024-04-01 02:00:00' AND g.DeviceLoginName='2898' GROUP BY g.time, g.Distance; CountAzimuth:41 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-31 23:0:0' AND e.date<='2024-04-01 5:0:0' AND e.DeviceLoginName='4849' 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-03-31 20:00:00' AND g.time<='2024-04-01 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:277 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-31 23:0:0' AND e.date<='2024-04-01 5:0:0' AND e.DeviceLoginName='2508' 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-03-31 20:00:00' AND g.time<='2024-04-01 02:00:00' AND g.DeviceLoginName='2508' GROUP BY g.time, g.Distance; CountAzimuth:53 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-31 23:0:0' AND e.date<='2024-04-01 5:0:0' AND e.DeviceLoginName='353173060487970' 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-03-31 20:00:00' AND g.time<='2024-04-01 02:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY g.time, g.Distance; CountAzimuth:109 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-31 23:0:0' AND e.date<='2024-04-01 5:0:0' AND e.DeviceLoginName='356078111473472' 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-03-31 20:00:00' AND g.time<='2024-04-01 02:00:00' AND g.DeviceLoginName='356078111473472' GROUP BY g.time, g.Distance; CountAzimuth:430 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-31 23:0:0' AND e.date<='2024-04-01 5:0:0' 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-03-31 20:00:00' AND g.time<='2024-04-01 02:00:00' 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-03-31 23:0:0' AND e.date<='2024-04-01 5:0:0' AND e.DeviceLoginName='3188' 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-03-31 20:00:00' AND g.time<='2024-04-01 02:00:00' AND g.DeviceLoginName='3188' GROUP BY g.time, g.Distance; CountAzimuth:65 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-31 23:0:0' AND e.date<='2024-04-01 5:0:0' AND e.DeviceLoginName='3179' 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-03-31 20:00:00' AND g.time<='2024-04-01 02:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:21 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-31 23:0:0' AND e.date<='2024-04-01 5:0:0' AND e.DeviceLoginName='2580' 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-03-31 20:00:00' AND g.time<='2024-04-01 02:00:00' AND g.DeviceLoginName='2580' GROUP BY g.time, g.Distance; CountAzimuth:162 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-31 23:0:0' AND e.date<='2024-04-01 5:0:0' AND e.DeviceLoginName='3197' 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-03-31 20:00:00' AND g.time<='2024-04-01 02:00:00' AND g.DeviceLoginName='3197' GROUP BY g.time, g.Distance; CountAzimuth:34 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-23 0:9:36' AND e.date<='2024-03-24 23:9:36' AND e.DeviceLoginName='3179' 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-03-22 21:09:36' AND g.time<='2024-03-24 20:09:36' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:1252 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 0:9:36' AND e.date<='2024-03-17 23:9:36' AND e.DeviceLoginName='3179' 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-03-15 21:09:36' AND g.time<='2024-03-17 20:09:36' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:1043 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 0:9:36' AND e.date<='2024-03-17 23:9:36' AND e.DeviceLoginName='353173060485131' 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-03-15 21:09:36' AND g.time<='2024-03-17 20:09:36' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:986 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 0:9:36' AND e.date<='2024-03-17 23:9:36' AND e.DeviceLoginName='353173060497698' 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-03-15 21:09:36' AND g.time<='2024-03-17 20:09:36' AND g.DeviceLoginName='353173060497698' GROUP BY g.time, g.Distance; CountAzimuth:826 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 0:9:36' AND e.date<='2024-03-17 23:9:36' AND e.DeviceLoginName='862531041050148' 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-03-15 21:09:36' AND g.time<='2024-03-17 20:09:36' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:482 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 0:9:36' AND e.date<='2024-03-17 23:9:36' AND e.DeviceLoginName='352353086185169' 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-03-15 21:09:36' AND g.time<='2024-03-17 20:09:36' AND g.DeviceLoginName='352353086185169' GROUP BY g.time, g.Distance; CountAzimuth:2649