Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-30 23:0:0' AND e.date<='2023-12-31 5:0:0' AND e.DeviceLoginName='2881' 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-30 21:00:00' AND g.time<='2023-12-31 03:00:00' AND g.DeviceLoginName='2881' GROUP BY  g.time, g.Distance;
CountAzimuth:574
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-30 23:0:0' AND e.date<='2023-12-31 5:0:0' AND e.DeviceLoginName='8992' 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-30 21:00:00' AND g.time<='2023-12-31 03:00:00' AND g.DeviceLoginName='8992' GROUP BY  g.time, g.Distance;
CountAzimuth:75
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-30 23:0:0' AND e.date<='2023-12-31 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-30 21:00:00' AND g.time<='2023-12-31 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:432
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-30 23:0:0' AND e.date<='2023-12-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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-30 21:00:00' AND g.time<='2023-12-31 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:324
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-30 23:0:0' AND e.date<='2023-12-31 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-30 21:00:00' AND g.time<='2023-12-31 03:00:00' AND g.DeviceLoginName='5129' GROUP BY  g.time, g.Distance;
CountAzimuth:156
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-30 23:0:0' AND e.date<='2023-12-31 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-30 21:00:00' AND g.time<='2023-12-31 03:00:00' AND g.DeviceLoginName='3124' GROUP BY  g.time, g.Distance;
CountAzimuth:356
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-30 23:0:0' AND e.date<='2023-12-31 5:0:0' AND e.DeviceLoginName='2470' 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-30 21:00:00' AND g.time<='2023-12-31 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:170
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY  g.time, g.Distance;
CountAzimuth:57
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 5:0:0' AND e.DeviceLoginName='2652' 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-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:7
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 5:0:0' AND e.DeviceLoginName='862531041080400' 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-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='862531041080400' GROUP BY  g.time, g.Distance;
CountAzimuth:43
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 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-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:520
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 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-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='2913' GROUP BY  g.time, g.Distance;
CountAzimuth:177
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 5:0:0' AND e.DeviceLoginName='2883' 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-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='2883' GROUP BY  g.time, g.Distance;
CountAzimuth:63
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='353173060537865' GROUP BY  g.time, g.Distance;
CountAzimuth:83
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 5:0:0' AND e.DeviceLoginName='862531041078289' 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-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='862531041078289' GROUP BY  g.time, g.Distance;
CountAzimuth:8
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 5:0:0' AND e.DeviceLoginName='355234055170423' 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-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='355234055170423' GROUP BY  g.time, g.Distance;
CountAzimuth:6
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='3124' GROUP BY  g.time, g.Distance;
CountAzimuth:912
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 5:0:0' AND e.DeviceLoginName='2470' 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-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:232
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 5:0:0' AND e.DeviceLoginName='9019' 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-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='9019' GROUP BY  g.time, g.Distance;
CountAzimuth:196
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 5:0:0' AND e.DeviceLoginName='4868' 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-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='4868' GROUP BY  g.time, g.Distance;
CountAzimuth:130
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='3179' GROUP BY  g.time, g.Distance;
CountAzimuth:20
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:18
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='2495' GROUP BY  g.time, g.Distance;
CountAzimuth:68
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-31 23:0:0' AND e.date<='2024-01-01 5:0:0' AND e.DeviceLoginName='356078111293896' 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-31 21:00:00' AND g.time<='2024-01-01 03:00:00' AND g.DeviceLoginName='356078111293896' GROUP BY  g.time, g.Distance;
CountAzimuth:80