Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 23:0:0' AND e.date<='2024-10-15 5:0:0' AND e.DeviceLoginName='9011' 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-10-14 20:00:00' AND g.time<='2024-10-15 02:00:00' AND g.DeviceLoginName='9011' GROUP BY g.time, g.Distance; CountAzimuth:100 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 23:0:0' AND e.date<='2024-10-15 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-10-14 20:00:00' AND g.time<='2024-10-15 02:00:00' AND g.DeviceLoginName='3123' GROUP BY g.time, g.Distance; CountAzimuth:131 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 23:0:0' AND e.date<='2024-10-15 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-10-14 20:00:00' AND g.time<='2024-10-15 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:189 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 23:0:0' AND e.date<='2024-10-15 5:0:0' AND e.DeviceLoginName='3238' 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-10-14 20:00:00' AND g.time<='2024-10-15 02:00:00' AND g.DeviceLoginName='3238' GROUP BY g.time, g.Distance; CountAzimuth:49 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 23:0:0' AND e.date<='2024-10-15 5:0:0' AND e.DeviceLoginName='4966' 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-10-14 20:00:00' AND g.time<='2024-10-15 02:00:00' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:8 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 23:0:0' AND e.date<='2024-10-15 5:0:0' AND e.DeviceLoginName='862531041041535' 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-10-14 20:00:00' AND g.time<='2024-10-15 02:00:00' AND g.DeviceLoginName='862531041041535' GROUP BY g.time, g.Distance; CountAzimuth:44 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 23:0:0' AND e.date<='2024-10-15 5:0:0' AND e.DeviceLoginName='2947' 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-10-14 20:00:00' AND g.time<='2024-10-15 02:00:00' AND g.DeviceLoginName='2947' GROUP BY g.time, g.Distance; CountAzimuth:89 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 23:0:0' AND e.date<='2024-10-15 5:0:0' AND e.DeviceLoginName='4862' 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-10-14 20:00:00' AND g.time<='2024-10-15 02:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:249 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 23:0:0' AND e.date<='2024-10-15 5:0:0' AND e.DeviceLoginName='3061' 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-10-14 20:00:00' AND g.time<='2024-10-15 02:00:00' AND g.DeviceLoginName='3061' GROUP BY g.time, g.Distance; CountAzimuth:78 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 23:0:0' AND e.date<='2024-10-15 5:0:0' AND e.DeviceLoginName='2728' 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-10-14 20:00:00' AND g.time<='2024-10-15 02:00:00' AND g.DeviceLoginName='2728' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 23:0:0' AND e.date<='2024-10-15 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-10-14 20:00:00' AND g.time<='2024-10-15 02:00:00' AND g.DeviceLoginName='2709' GROUP BY g.time, g.Distance; CountAzimuth:72 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 23:0:0' AND e.date<='2024-10-15 5:0:0' AND e.DeviceLoginName='2964' 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-10-14 20:00:00' AND g.time<='2024-10-15 02:00:00' AND g.DeviceLoginName='2964' GROUP BY g.time, g.Distance; CountAzimuth:6 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 5:0:0' AND e.DeviceLoginName='9011' 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='9011' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 5:0:0' AND e.DeviceLoginName='3144' 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='3144' GROUP BY g.time, g.Distance; CountAzimuth:145 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:122 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='3157' GROUP BY g.time, g.Distance; CountAzimuth:39 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 5:0:0' AND e.DeviceLoginName='5080' 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='5080' GROUP BY g.time, g.Distance; CountAzimuth:74 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 5:0:0' AND e.DeviceLoginName='353173060537865' 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='353173060537865' GROUP BY g.time, g.Distance; CountAzimuth:122 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 5:0:0' 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:316 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 5:0:0' AND e.DeviceLoginName='2785' 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='2785' GROUP BY g.time, g.Distance; CountAzimuth:62 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='4861' GROUP BY g.time, g.Distance; CountAzimuth:817 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 5:0:0' AND e.DeviceLoginName='2866' 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='2866' GROUP BY g.time, g.Distance; CountAzimuth:74 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 5:0:0' AND e.DeviceLoginName='4862' 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:218 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 5:0:0' AND e.DeviceLoginName='3039' 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='3039' GROUP BY g.time, g.Distance; CountAzimuth:39 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 5:0:0' AND e.DeviceLoginName='3156' 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='3156' GROUP BY g.time, g.Distance; CountAzimuth:146 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 5:0:0' 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:13 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 5:0:0' AND e.DeviceLoginName='8983' 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='8983' GROUP BY g.time, g.Distance; CountAzimuth:184 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-15 23:0:0' AND e.date<='2024-10-16 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-10-15 20:00:00' AND g.time<='2024-10-16 02:00:00' AND g.DeviceLoginName='3197' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-16 23:0:0' AND e.date<='2024-10-17 5:0:0' AND e.DeviceLoginName='9011' 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-10-16 20:00:00' AND g.time<='2024-10-17 02:00:00' AND g.DeviceLoginName='9011' GROUP BY g.time, g.Distance; CountAzimuth:226 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-16 23:0:0' AND e.date<='2024-10-17 5:0:0' AND e.DeviceLoginName='3057' 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-10-16 20:00:00' AND g.time<='2024-10-17 02:00:00' AND g.DeviceLoginName='3057' GROUP BY g.time, g.Distance; CountAzimuth:78 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-16 23:0:0' AND e.date<='2024-10-17 5:0:0' AND e.DeviceLoginName='3158' 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-10-16 20:00:00' AND g.time<='2024-10-17 02:00:00' AND g.DeviceLoginName='3158' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-16 23:0:0' AND e.date<='2024-10-17 5:0:0' AND e.DeviceLoginName='2874' 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-10-16 20:00:00' AND g.time<='2024-10-17 02:00:00' AND g.DeviceLoginName='2874' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-16 23:0:0' AND e.date<='2024-10-17 5:0:0' AND e.DeviceLoginName='2783' 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-10-16 20:00:00' AND g.time<='2024-10-17 02:00:00' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:95 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-16 23:0:0' AND e.date<='2024-10-17 5:0:0' AND e.DeviceLoginName='2625' 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-10-16 20:00:00' AND g.time<='2024-10-17 02:00:00' AND g.DeviceLoginName='2625' GROUP BY g.time, g.Distance; CountAzimuth:28 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-16 23:0:0' AND e.date<='2024-10-17 5:0:0' AND e.DeviceLoginName='862531041041535' 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-10-16 20:00:00' AND g.time<='2024-10-17 02:00:00' AND g.DeviceLoginName='862531041041535' GROUP BY g.time, g.Distance; CountAzimuth:5 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-16 23:0:0' AND e.date<='2024-10-17 5:0:0' AND e.DeviceLoginName='4862' 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-10-16 20:00:00' AND g.time<='2024-10-17 02:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:233 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-16 23:0:0' AND e.date<='2024-10-17 5:0:0' 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-10-16 20:00:00' AND g.time<='2024-10-17 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY g.time, g.Distance; CountAzimuth:108 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-16 23:0:0' AND e.date<='2024-10-17 5:0:0' AND e.DeviceLoginName='2755' 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-10-16 20:00:00' AND g.time<='2024-10-17 02:00:00' AND g.DeviceLoginName='2755' GROUP BY g.time, g.Distance; CountAzimuth:19 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-16 23:0:0' AND e.date<='2024-10-17 5:0:0' AND e.DeviceLoginName='2964' 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-10-16 20:00:00' AND g.time<='2024-10-17 02:00:00' AND g.DeviceLoginName='2964' GROUP BY g.time, g.Distance; CountAzimuth:68 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 23:0:0' AND e.date<='2024-10-18 5:0:0' AND e.DeviceLoginName='2829' 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-10-17 20:00:00' AND g.time<='2024-10-18 02:00:00' AND g.DeviceLoginName='2829' GROUP BY g.time, g.Distance; CountAzimuth:31 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 23:0:0' AND e.date<='2024-10-18 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-10-17 20:00:00' AND g.time<='2024-10-18 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:251 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 23:0:0' AND e.date<='2024-10-18 5:0:0' AND e.DeviceLoginName='2874' 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-10-17 20:00:00' AND g.time<='2024-10-18 02:00:00' AND g.DeviceLoginName='2874' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 23:0:0' AND e.date<='2024-10-18 5:0:0' AND e.DeviceLoginName='4966' 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-10-17 20:00:00' AND g.time<='2024-10-18 02:00:00' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:185 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 23:0:0' AND e.date<='2024-10-18 5:0:0' AND e.DeviceLoginName='4959' 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-10-17 20:00:00' AND g.time<='2024-10-18 02:00:00' AND g.DeviceLoginName='4959' GROUP BY g.time, g.Distance; CountAzimuth:375 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 23:0:0' AND e.date<='2024-10-18 5:0:0' AND e.DeviceLoginName='3023' 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-10-17 20:00:00' AND g.time<='2024-10-18 02:00:00' AND g.DeviceLoginName='3023' GROUP BY g.time, g.Distance; CountAzimuth:424 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 23:0:0' AND e.date<='2024-10-18 5:0:0' AND e.DeviceLoginName='4862' 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-10-17 20:00:00' AND g.time<='2024-10-18 02:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:47 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 23:0:0' AND e.date<='2024-10-18 5:0:0' 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-10-17 20:00:00' AND g.time<='2024-10-18 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY g.time, g.Distance; CountAzimuth:102 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 23:0:0' AND e.date<='2024-10-18 5:0:0' AND e.DeviceLoginName='8983' 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-10-17 20:00:00' AND g.time<='2024-10-18 02:00:00' AND g.DeviceLoginName='8983' GROUP BY g.time, g.Distance; CountAzimuth:146 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-17 23:0:0' AND e.date<='2024-10-18 5:0:0' AND e.DeviceLoginName='2726' 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-10-17 20:00:00' AND g.time<='2024-10-18 02:00:00' AND g.DeviceLoginName='2726' GROUP BY g.time, g.Distance; CountAzimuth:37 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 7:10:7' AND e.date<='2024-10-18 12:10:7' 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-10-18 04:10:07' AND g.time<='2024-10-18 09:10:07' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:68 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 0:10:30' AND e.date<='2024-10-18 12:10:30' 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-10-17 21:10:30' AND g.time<='2024-10-18 09:10:30' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:321 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 5:25:38' AND e.date<='2024-10-18 12:25:38' 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-10-18 02:25:38' AND g.time<='2024-10-18 09:25:38' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:321 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 5:32:59' AND e.date<='2024-10-18 12:32:59' 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-10-18 02:32:59' AND g.time<='2024-10-18 09:32:59' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 2:33:15' AND e.date<='2024-10-18 12:33:15' 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-10-17 23:33:15' AND g.time<='2024-10-18 09:33:15' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 2:33:32' AND e.date<='2024-10-18 12:33:32' 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-10-17 23:33:32' AND g.time<='2024-10-18 09:33:32' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:717 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 3:33:51' AND e.date<='2024-10-18 12:33:51' 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-10-18 00:33:51' AND g.time<='2024-10-18 09:33:51' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 0:34:7' AND e.date<='2024-10-18 12:34:7' 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-10-17 21:34:07' AND g.time<='2024-10-18 09:34:07' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:296 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 9:41:44' AND e.date<='2024-10-18 12:41: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-10-18 06:41:44' AND g.time<='2024-10-18 09:41:44' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:68 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 5:59:1' AND e.date<='2024-10-18 12:59:1' 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-10-18 02:59:01' AND g.time<='2024-10-18 09:59:01' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:321 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 5:19:51' AND e.date<='2024-10-18 13:19:51' 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-10-18 02:19:51' AND g.time<='2024-10-18 10:19:51' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:450 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 2:47:12' AND e.date<='2024-10-18 13:47:12' 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-10-17 23:47:12' AND g.time<='2024-10-18 10:47:12' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:514 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 8:48:29' AND e.date<='2024-10-18 13:48:29' 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-10-18 05:48:29' AND g.time<='2024-10-18 10:48:29' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:51 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 8:52:27' AND e.date<='2024-10-18 14:52:27' 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-10-18 05:52:27' AND g.time<='2024-10-18 11:52:27' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:381 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 6:57:7' AND e.date<='2024-10-18 14:57:7' 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-10-18 03:57:07' AND g.time<='2024-10-18 11:57:07' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:417 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 10:6:6' AND e.date<='2024-10-18 15:6:6' 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-10-18 07:06:06' AND g.time<='2024-10-18 12:06:06' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:463 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 8:13:46' AND e.date<='2024-10-18 15:13:46' 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-10-18 05:13:46' AND g.time<='2024-10-18 12:13:46' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:523 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 9:23:47' AND e.date<='2024-10-18 15:23: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-10-18 06:23:47' AND g.time<='2024-10-18 12:23:47' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:570 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 0:30:27' AND e.date<='2024-10-18 15:30:27' AND e.DeviceLoginName='352353086186647' 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-10-17 21:30:27' AND g.time<='2024-10-18 12:30:27' AND g.DeviceLoginName='352353086186647' GROUP BY g.time, g.Distance; CountAzimuth:1139 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 8:43:36' AND e.date<='2024-10-18 15:43:36' 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-10-18 05:43:36' AND g.time<='2024-10-18 12:43:36' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:570 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 0:30:27' AND e.date<='2024-10-18 23:30:27' AND e.DeviceLoginName='352353086186647' 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-10-17 21:30:27' AND g.time<='2024-10-18 20:30:27' AND g.DeviceLoginName='352353086186647' GROUP BY g.time, g.Distance; CountAzimuth:1229 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 0:30:27' AND e.date<='2024-10-11 23:30:27' AND e.DeviceLoginName='352353086186647' 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-10-10 21:30:27' AND g.time<='2024-10-11 20:30:27' AND g.DeviceLoginName='352353086186647' GROUP BY g.time, g.Distance; CountAzimuth:1620