Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-25 23:0:0' AND e.date<='2023-12-26 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-25 21:00:00' AND g.time<='2023-12-26 03:00:00' AND g.DeviceLoginName='8997' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-25 23:0:0' AND e.date<='2023-12-26 5:0:0' AND e.DeviceLoginName='4964' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-25 21:00:00' AND g.time<='2023-12-26 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:308
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-25 23:0:0' AND e.date<='2023-12-26 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-25 21:00:00' AND g.time<='2023-12-26 03:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY  g.time, g.Distance;
CountAzimuth:71
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-25 23:0:0' AND e.date<='2023-12-26 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-25 21:00:00' AND g.time<='2023-12-26 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:250
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-25 23:0:0' AND e.date<='2023-12-26 5:0:0' AND e.DeviceLoginName='2461' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-25 21:00:00' AND g.time<='2023-12-26 03:00:00' AND g.DeviceLoginName='2461' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 23:0:0' AND e.date<='2023-12-27 5:0:0' AND e.DeviceLoginName='862531041072803' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-26 21:00:00' AND g.time<='2023-12-27 03:00:00' AND g.DeviceLoginName='862531041072803' GROUP BY  g.time, g.Distance;
CountAzimuth:142
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 23:0:0' AND e.date<='2023-12-27 5:0:0' AND e.DeviceLoginName='4964' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-26 21:00:00' AND g.time<='2023-12-27 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:291
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 23:0:0' AND e.date<='2023-12-27 5:0:0' AND e.DeviceLoginName='2913' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-26 21:00:00' AND g.time<='2023-12-27 03:00:00' AND g.DeviceLoginName='2913' GROUP BY  g.time, g.Distance;
CountAzimuth:180
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 23:0:0' AND e.date<='2023-12-27 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-26 21:00:00' AND g.time<='2023-12-27 03:00:00' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:70
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 23:0:0' AND e.date<='2023-12-27 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-26 21:00:00' AND g.time<='2023-12-27 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:187
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 23:0:0' AND e.date<='2023-12-27 5:0:0' AND e.DeviceLoginName='3091' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-26 21:00:00' AND g.time<='2023-12-27 03:00:00' AND g.DeviceLoginName='3091' GROUP BY  g.time, g.Distance;
CountAzimuth:18
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 23:0:0' AND e.date<='2023-12-27 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-26 21:00:00' AND g.time<='2023-12-27 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 23:0:0' AND e.date<='2023-12-27 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-26 21:00:00' AND g.time<='2023-12-27 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:227
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 23:0:0' AND e.date<='2023-12-27 5:0:0' AND e.DeviceLoginName='5132' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-26 21:00:00' AND g.time<='2023-12-27 03:00:00' AND g.DeviceLoginName='5132' GROUP BY  g.time, g.Distance;
CountAzimuth:48
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 23:0:0' AND e.date<='2023-12-27 5:0:0' AND e.DeviceLoginName='2878' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-26 21:00:00' AND g.time<='2023-12-27 03:00:00' AND g.DeviceLoginName='2878' GROUP BY  g.time, g.Distance;
CountAzimuth:262
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 23:0:0' AND e.date<='2023-12-27 5:0:0' AND e.DeviceLoginName='2597' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-26 21:00:00' AND g.time<='2023-12-27 03:00:00' AND g.DeviceLoginName='2597' GROUP BY  g.time, g.Distance;
CountAzimuth:8
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 23:0:0' AND e.date<='2023-12-28 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-27 21:00:00' AND g.time<='2023-12-28 03:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY  g.time, g.Distance;
CountAzimuth:42
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 23:0:0' AND e.date<='2023-12-28 5:0:0' AND e.DeviceLoginName='4848' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-27 21:00:00' AND g.time<='2023-12-28 03:00:00' AND g.DeviceLoginName='4848' GROUP BY  g.time, g.Distance;
CountAzimuth:56
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 23:0:0' AND e.date<='2023-12-28 5:0:0' AND e.DeviceLoginName='4964' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-27 21:00:00' AND g.time<='2023-12-28 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:437
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 23:0:0' AND e.date<='2023-12-28 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-27 21:00:00' AND g.time<='2023-12-28 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:357
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 23:0:0' AND e.date<='2023-12-28 5:0:0' AND e.DeviceLoginName='2790' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-27 21:00:00' AND g.time<='2023-12-28 03:00:00' AND g.DeviceLoginName='2790' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 23:0:0' AND e.date<='2023-12-28 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-27 21:00:00' AND g.time<='2023-12-28 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:201
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 23:0:0' AND e.date<='2023-12-28 5:0:0' AND e.DeviceLoginName='2904' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-27 21:00:00' AND g.time<='2023-12-28 03:00:00' AND g.DeviceLoginName='2904' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 23:0:0' AND e.date<='2023-12-28 5:0:0' AND e.DeviceLoginName='2499' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-27 21:00:00' AND g.time<='2023-12-28 03:00:00' AND g.DeviceLoginName='2499' GROUP BY  g.time, g.Distance;
CountAzimuth:60
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 23:0:0' AND e.date<='2023-12-29 5:0:0' AND e.DeviceLoginName='9020' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-28 21:00:00' AND g.time<='2023-12-29 03:00:00' AND g.DeviceLoginName='9020' GROUP BY  g.time, g.Distance;
CountAzimuth:86
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 23:0:0' AND e.date<='2023-12-29 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-28 21:00:00' AND g.time<='2023-12-29 03:00:00' AND g.DeviceLoginName='3123' GROUP BY  g.time, g.Distance;
CountAzimuth:469
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 23:0:0' AND e.date<='2023-12-29 5:0:0' AND e.DeviceLoginName='4964' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-28 21:00:00' AND g.time<='2023-12-29 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:180
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 23:0:0' AND e.date<='2023-12-29 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-28 21:00:00' AND g.time<='2023-12-29 03:00:00' AND g.DeviceLoginName='2558' GROUP BY  g.time, g.Distance;
CountAzimuth:225
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 23:0:0' AND e.date<='2023-12-29 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-28 21:00:00' AND g.time<='2023-12-29 03:00:00' AND g.DeviceLoginName='5080' GROUP BY  g.time, g.Distance;
CountAzimuth:769
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 23:0:0' AND e.date<='2023-12-29 5:0:0' AND e.DeviceLoginName='5129' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-28 21:00:00' AND g.time<='2023-12-29 03:00:00' AND g.DeviceLoginName='5129' GROUP BY  g.time, g.Distance;
CountAzimuth:139
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 23:0:0' AND e.date<='2023-12-29 5:0:0' AND e.DeviceLoginName='358021081932786' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-28 21:00:00' AND g.time<='2023-12-29 03:00:00' AND g.DeviceLoginName='358021081932786' GROUP BY  g.time, g.Distance;
CountAzimuth:106
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 23:0:0' AND e.date<='2023-12-29 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-28 21:00:00' AND g.time<='2023-12-29 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:201
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 23:0:0' AND e.date<='2023-12-29 5:0:0' AND e.DeviceLoginName='2674' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-28 21:00:00' AND g.time<='2023-12-29 03:00:00' AND g.DeviceLoginName='2674' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 23:0:0' AND e.date<='2023-12-29 5:0:0' AND e.DeviceLoginName='2624' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-28 21:00:00' AND g.time<='2023-12-29 03:00:00' AND g.DeviceLoginName='2624' GROUP BY  g.time, g.Distance;
CountAzimuth:28
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 23:0:0' AND e.date<='2023-12-29 5:0:0' AND e.DeviceLoginName='2526' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-28 21:00:00' AND g.time<='2023-12-29 03:00:00' AND g.DeviceLoginName='2526' GROUP BY  g.time, g.Distance;
CountAzimuth:106
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 23:0:0' AND e.date<='2023-12-29 5:0:0' AND e.DeviceLoginName='2888' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-28 21:00:00' AND g.time<='2023-12-29 03:00:00' AND g.DeviceLoginName='2888' GROUP BY  g.time, g.Distance;
CountAzimuth:85
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='9010' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='9010' GROUP BY  g.time, g.Distance;
CountAzimuth:599
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='4964' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:554
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='9010' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='9010' GROUP BY  g.time, g.Distance;
CountAzimuth:599
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='2913' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='2913' GROUP BY  g.time, g.Distance;
CountAzimuth:271
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='2761' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='2761' GROUP BY  g.time, g.Distance;
CountAzimuth:227
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='358021081838710' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='358021081838710' GROUP BY  g.time, g.Distance;
CountAzimuth:543
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='358021081838710' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='358021081838710' GROUP BY  g.time, g.Distance;
CountAzimuth:543
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='358021081838710' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='358021081838710' GROUP BY  g.time, g.Distance;
CountAzimuth:543
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='2411' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='2411' GROUP BY  g.time, g.Distance;
CountAzimuth:471
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:223
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='2576' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='2576' GROUP BY  g.time, g.Distance;
CountAzimuth:111
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='352353084196515' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='352353084196515' GROUP BY  g.time, g.Distance;
CountAzimuth:20
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='352353085652458' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='352353085652458' GROUP BY  g.time, g.Distance;
CountAzimuth:484
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='352353086183362' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='352353086183362' GROUP BY  g.time, g.Distance;
CountAzimuth:318
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:106
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='2908' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='2908' GROUP BY  g.time, g.Distance;
CountAzimuth:204
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 23:0:0' AND e.date<='2023-12-30 5:0:0' AND e.DeviceLoginName='3187' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-29 21:00:00' AND g.time<='2023-12-30 03:00:00' AND g.DeviceLoginName='3187' GROUP BY  g.time, g.Distance;
CountAzimuth:88