Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-03 5:41:55' AND e.date<='2024-09-03 7:41:55' 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-09-03 02:41:55' AND g.time<='2024-09-03 04:41:55' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:260
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-02 7:42:55' AND e.date<='2024-09-03 7:42:55' 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-09-02 04:42:55' AND g.time<='2024-09-03 04:42:55' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:1879
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-03 5:43:47' AND e.date<='2024-09-03 7:43:47' 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-09-03 02:43:47' AND g.time<='2024-09-03 04:43:47' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:410
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-02 7:44:11' AND e.date<='2024-09-02 23:44:11' AND e.DeviceLoginName='3056' 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-09-02 04:44:11' AND g.time<='2024-09-02 20:44:11' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:2695
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 10:21:14' AND e.date<='2024-08-31 10:21:14' AND e.DeviceLoginName='2833' 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-08-26 07:21:14' AND g.time<='2024-08-31 07:21:14' AND g.DeviceLoginName='2833' GROUP BY  g.time, g.Distance;
CountAzimuth:2025
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-03 7:56:47' AND e.date<='2024-09-03 13:56: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-09-03 04:56:47' AND g.time<='2024-09-03 10:56:47' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:439
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-31 0:51:21' AND e.date<='2024-09-01 23:51:21' AND e.DeviceLoginName='2454' 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-08-30 21:51:21' AND g.time<='2024-09-01 20:51:21' AND g.DeviceLoginName='2454' GROUP BY  g.time, g.Distance;
CountAzimuth:597
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-31 0:51:21' AND e.date<='2024-08-31 23:51:21' AND e.DeviceLoginName='2454' 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-08-30 21:51:21' AND g.time<='2024-08-31 20:51:21' AND g.DeviceLoginName='2454' GROUP BY  g.time, g.Distance;
CountAzimuth:340
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-31 4:51:21' AND e.date<='2024-08-31 23:51:21' AND e.DeviceLoginName='2454' 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-08-31 01:51:21' AND g.time<='2024-08-31 20:51:21' AND g.DeviceLoginName='2454' GROUP BY  g.time, g.Distance;
CountAzimuth:295
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-02 4:51:21' AND e.date<='2024-09-02 23:51:21' AND e.DeviceLoginName='2454' 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-09-02 01:51:21' AND g.time<='2024-09-02 20:51:21' AND g.DeviceLoginName='2454' GROUP BY  g.time, g.Distance;
CountAzimuth:684
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-03 14:0:26' AND e.date<='2024-09-03 17:0:26' AND e.DeviceLoginName='352353086130694' 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-09-03 11:00:26' AND g.time<='2024-09-03 14:00:26' AND g.DeviceLoginName='352353086130694' GROUP BY  g.time, g.Distance;
CountAzimuth:394
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-03 12:2:14' AND e.date<='2024-09-03 17:2:14' AND e.DeviceLoginName='2594' 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-09-03 09:02:14' AND g.time<='2024-09-03 14:02:14' AND g.DeviceLoginName='2594' GROUP BY  g.time, g.Distance;
CountAzimuth:244
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-03 6:2:14' AND e.date<='2024-09-03 17:2:14' AND e.DeviceLoginName='2594' 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-09-03 03:02:14' AND g.time<='2024-09-03 14:02:14' AND g.DeviceLoginName='2594' GROUP BY  g.time, g.Distance;
CountAzimuth:369