Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 0:47:45' AND e.date<='2024-01-08 23:47:45' AND e.DeviceLoginName='3178' 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>='2024-01-07 22:47:45' AND g.time<='2024-01-08 21:47:45' AND g.DeviceLoginName='3178' GROUP BY  g.time, g.Distance;
CountAzimuth:1778
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-02 0:59:24' AND e.date<='2024-01-02 23:59:24' AND e.DeviceLoginName='2910' 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>='2024-01-01 22:59:24' AND g.time<='2024-01-02 21:59:24' AND g.DeviceLoginName='2910' GROUP BY  g.time, g.Distance;
CountAzimuth:9
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-03 0:59:24' AND e.date<='2024-01-03 23:59:24' AND e.DeviceLoginName='2910' 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>='2024-01-02 22:59:24' AND g.time<='2024-01-03 21:59:24' AND g.DeviceLoginName='2910' GROUP BY  g.time, g.Distance;
CountAzimuth:597
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-04 0:59:24' AND e.date<='2024-01-04 23:59:24' AND e.DeviceLoginName='2910' 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>='2024-01-03 22:59:24' AND g.time<='2024-01-04 21:59:24' AND g.DeviceLoginName='2910' GROUP BY  g.time, g.Distance;
CountAzimuth:546
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-05 0:59:24' AND e.date<='2024-01-05 23:59:24' AND e.DeviceLoginName='2910' 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>='2024-01-04 22:59:24' AND g.time<='2024-01-05 21:59:24' AND g.DeviceLoginName='2910' GROUP BY  g.time, g.Distance;
CountAzimuth:8
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-04 0:59:24' AND e.date<='2024-01-04 23:59:24' AND e.DeviceLoginName='2910' 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>='2024-01-03 22:59:24' AND g.time<='2024-01-04 21:59:24' AND g.DeviceLoginName='2910' GROUP BY  g.time, g.Distance;
CountAzimuth:546
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-03 0:59:24' AND e.date<='2024-01-04 23:59:24' AND e.DeviceLoginName='2910' 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>='2024-01-02 22:59:24' AND g.time<='2024-01-04 21:59:24' AND g.DeviceLoginName='2910' GROUP BY  g.time, g.Distance;
CountAzimuth:1153
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-03 0:59:24' AND e.date<='2024-01-03 23:59:24' AND e.DeviceLoginName='2910' 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>='2024-01-02 22:59:24' AND g.time<='2024-01-03 21:59:24' AND g.DeviceLoginName='2910' GROUP BY  g.time, g.Distance;
CountAzimuth:597
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-03 0:7:27' AND e.date<='2024-01-03 23:7:27' AND e.DeviceLoginName='2910' 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>='2024-01-02 22:07:27' AND g.time<='2024-01-03 21:07:27' AND g.DeviceLoginName='2910' GROUP BY  g.time, g.Distance;
CountAzimuth:597
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-04 0:7:27' AND e.date<='2024-01-04 23:7:27' AND e.DeviceLoginName='2910' 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>='2024-01-03 22:07:27' AND g.time<='2024-01-04 21:07:27' AND g.DeviceLoginName='2910' GROUP BY  g.time, g.Distance;
CountAzimuth:554
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-05 0:7:27' AND e.date<='2024-01-05 23:7:27' AND e.DeviceLoginName='2910' 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>='2024-01-04 22:07:27' AND g.time<='2024-01-05 21:07:27' AND g.DeviceLoginName='2910' GROUP BY  g.time, g.Distance;
CountAzimuth:8
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 0:37:20' AND e.date<='2024-01-09 13:37:20' AND e.DeviceLoginName='ai4682' 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>='2024-01-07 22:37:20' AND g.time<='2024-01-09 11:37:20' AND g.DeviceLoginName='ai4682' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 0:37:20' AND e.date<='2024-01-09 13:37:20' AND e.DeviceLoginName='ai4682' 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>='2024-01-08 22:37:20' AND g.time<='2024-01-09 11:37:20' AND g.DeviceLoginName='ai4682' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 13:38:39' AND e.date<='2024-01-09 13:38:39' AND e.DeviceLoginName='352353083480050' 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>='2024-01-08 11:38:39' AND g.time<='2024-01-09 11:38:39' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:2047
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 17:0:0' AND e.date<='2024-01-09 10:0:0' AND e.DeviceLoginName='352353083480050' 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>='2024-01-08 15:00:00' AND g.time<='2024-01-09 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:890
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 15:0:0' AND e.date<='2024-01-09 10:0:0' AND e.DeviceLoginName='352353083480050' 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>='2024-01-08 13:00:00' AND g.time<='2024-01-09 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:1398
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-08 15:0:0' AND e.date<='2024-01-09 10:0:0' AND e.DeviceLoginName='352353083480050' 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>='2024-01-08 13:00:00' AND g.time<='2024-01-09 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:1398
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-01 15:0:0' AND e.date<='2024-01-09 10:0:0' AND e.DeviceLoginName='352353083480050' 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>='2024-01-01 13:00:00' AND g.time<='2024-01-09 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:7548
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-01 15:0:0' AND e.date<='2024-01-08 10:0:0' AND e.DeviceLoginName='352353083480050' 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>='2024-01-01 13:00:00' AND g.time<='2024-01-08 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:5630
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-01 15:0:0' AND e.date<='2024-01-08 10:0:0' AND e.DeviceLoginName='352353083480050' 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>='2024-01-01 13:00:00' AND g.time<='2024-01-08 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:5630
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-01 15:0:0' AND e.date<='2024-01-02 10:0:0' AND e.DeviceLoginName='352353083480050' 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>='2024-01-01 13:00:00' AND g.time<='2024-01-02 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:662
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-25 0:0:0' AND e.date<='2024-01-02 10:0:0' AND e.DeviceLoginName='352353083480050' 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-24 22:00:00' AND g.time<='2024-01-02 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:7126
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 0:0:0' AND e.date<='2024-01-02 10:0:0' AND e.DeviceLoginName='352353083480050' 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 22:00:00' AND g.time<='2024-01-02 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:7122
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-25 0:0:0' AND e.date<='2023-12-26 10:0:0' AND e.DeviceLoginName='352353083480050' 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-24 22:00:00' AND g.time<='2023-12-26 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:282
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-26 0:0:0' AND e.date<='2023-12-27 10:0:0' AND e.DeviceLoginName='352353083480050' 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 22:00:00' AND g.time<='2023-12-27 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:2465
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 0:0:0' AND e.date<='2023-12-28 10:0:0' AND e.DeviceLoginName='352353083480050' 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 22:00:00' AND g.time<='2023-12-28 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:3140
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 0:0:0' AND e.date<='2023-12-29 10:0:0' AND e.DeviceLoginName='352353083480050' 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 22:00:00' AND g.time<='2023-12-29 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:2432
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-29 0:0:0' AND e.date<='2023-12-30 10:0:0' AND e.DeviceLoginName='352353083480050' 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 22:00:00' AND g.time<='2023-12-30 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:21
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 0:0:0' AND e.date<='2024-01-01 10:0:0' AND e.DeviceLoginName='352353083480050' 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 22:00:00' AND g.time<='2024-01-01 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:2471
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-28 0:0:0' AND e.date<='2024-01-02 10:0:0' AND e.DeviceLoginName='352353083480050' 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 22:00:00' AND g.time<='2024-01-02 08:00:00' AND g.DeviceLoginName='352353083480050' GROUP BY  g.time, g.Distance;
CountAzimuth:3133
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 12:14:32' AND e.date<='2024-01-09 15:14:32' AND e.DeviceLoginName='356078111301566' 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>='2024-01-09 10:14:32' AND g.time<='2024-01-09 13:14:32' AND g.DeviceLoginName='356078111301566' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 11:14:44' AND e.date<='2024-01-09 15:14:44' AND e.DeviceLoginName='2473' 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>='2024-01-09 09:14:44' AND g.time<='2024-01-09 13:14:44' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:634
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 10:15:11' AND e.date<='2024-01-09 15:15:11' AND e.DeviceLoginName='358021081803706' 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>='2024-01-09 08:15:11' AND g.time<='2024-01-09 13:15:11' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:657
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 12:15:43' AND e.date<='2024-01-09 15:15:43' AND e.DeviceLoginName='3056' 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>='2024-01-09 10:15:43' AND g.time<='2024-01-09 13:15:43' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:634