Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 7:19:47' AND e.date<='2025-02-28 7:19:47' AND e.DeviceLoginName='352353083458635' 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>='2025-02-27 05:19:47' AND g.time<='2025-02-28 05:19:47' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1379
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 7:38:48' AND e.date<='2025-02-27 23:38:48' AND e.DeviceLoginName='354836080167561' 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>='2025-02-27 05:38:48' AND g.time<='2025-02-27 21:38:48' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:928
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 7:39:28' AND e.date<='2025-02-27 23:39:28' AND e.DeviceLoginName='356078116278207' 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>='2025-02-27 05:39:28' AND g.time<='2025-02-27 21:39:28' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:1437
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 7:39:50' AND e.date<='2025-02-27 23:39:50' 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>='2025-02-27 05:39:50' AND g.time<='2025-02-27 21:39:50' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:550
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-08 0:36:52' AND e.date<='2025-02-09 23:36:52' AND e.DeviceLoginName='355234055565614' 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>='2025-02-07 22:36:52' AND g.time<='2025-02-09 21:36:52' AND g.DeviceLoginName='355234055565614' GROUP BY  g.time, g.Distance;
CountAzimuth:604
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-17 0:46:16' AND e.date<='2025-02-17 23:46:16' AND e.DeviceLoginName='3212' 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>='2025-02-16 22:46:16' AND g.time<='2025-02-17 21:46:16' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:2297
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-18 0:46:16' AND e.date<='2025-02-18 23:46:16' AND e.DeviceLoginName='3212' 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>='2025-02-17 22:46:16' AND g.time<='2025-02-18 21:46:16' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:3485
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-19 0:46:16' AND e.date<='2025-02-19 23:46:16' AND e.DeviceLoginName='3212' 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>='2025-02-18 22:46:16' AND g.time<='2025-02-19 21:46:16' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:1981
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-20 0:46:16' AND e.date<='2025-02-20 23:46:16' AND e.DeviceLoginName='3212' 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>='2025-02-19 22:46:16' AND g.time<='2025-02-20 21:46:16' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:2425
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-21 0:46:16' AND e.date<='2025-02-21 23:46:16' AND e.DeviceLoginName='3212' 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>='2025-02-20 22:46:16' AND g.time<='2025-02-21 21:46:16' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:2843
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-08 0:36:52' AND e.date<='2025-02-09 23:36:52' AND e.DeviceLoginName='352353086131601' 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>='2025-02-07 22:36:52' AND g.time<='2025-02-09 21:36:52' AND g.DeviceLoginName='352353086131601' GROUP BY  g.time, g.Distance;
CountAzimuth:416
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-15 0:36:52' AND e.date<='2025-02-16 23:36:52' AND e.DeviceLoginName='352353086131601' 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>='2025-02-14 22:36:52' AND g.time<='2025-02-16 21:36:52' AND g.DeviceLoginName='352353086131601' GROUP BY  g.time, g.Distance;
CountAzimuth:20
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-22 0:36:52' AND e.date<='2025-02-23 23:36:52' AND e.DeviceLoginName='352353086131601' 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>='2025-02-21 22:36:52' AND g.time<='2025-02-23 21:36:52' AND g.DeviceLoginName='352353086131601' GROUP BY  g.time, g.Distance;
CountAzimuth:32
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-08 0:36:52' AND e.date<='2025-02-08 23:36:52' AND e.DeviceLoginName='2557' 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>='2025-02-07 22:36:52' AND g.time<='2025-02-08 21:36:52' AND g.DeviceLoginName='2557' GROUP BY  g.time, g.Distance;
CountAzimuth:1449
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 5:0:0' AND e.DeviceLoginName='356078116287711' 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='356078116287711' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY  g.time, g.Distance;
CountAzimuth:33
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='4848' GROUP BY  g.time, g.Distance;
CountAzimuth:57
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 5:0:0' AND e.DeviceLoginName='3154' 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='3154' GROUP BY  g.time, g.Distance;
CountAzimuth:469
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='3057' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 5:0:0' AND e.DeviceLoginName='2769' 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='2769' GROUP BY  g.time, g.Distance;
CountAzimuth:74
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:41
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='2790' GROUP BY  g.time, g.Distance;
CountAzimuth:44
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 5:0:0' AND e.DeviceLoginName='9014' 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='9014' GROUP BY  g.time, g.Distance;
CountAzimuth:210
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='2883' GROUP BY  g.time, g.Distance;
CountAzimuth:162
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='2947' GROUP BY  g.time, g.Distance;
CountAzimuth:20
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:111
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 5:0:0' AND e.DeviceLoginName='2662' 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='2662' GROUP BY  g.time, g.Distance;
CountAzimuth:137
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='2866' GROUP BY  g.time, g.Distance;
CountAzimuth:923
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:38
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 5:0:0' AND e.DeviceLoginName='2590' 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='2590' GROUP BY  g.time, g.Distance;
CountAzimuth:10
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 5:0:0' AND e.DeviceLoginName='3147' 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='3147' GROUP BY  g.time, g.Distance;
CountAzimuth:49
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:34
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 5:0:0' AND e.DeviceLoginName='2743' 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='2743' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='2495' GROUP BY  g.time, g.Distance;
CountAzimuth:19
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='2499' GROUP BY  g.time, g.Distance;
CountAzimuth:430
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 5:0:0' AND e.DeviceLoginName='2584' 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='2584' GROUP BY  g.time, g.Distance;
CountAzimuth:378
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 5:0:0' AND e.DeviceLoginName='3071' 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='3071' GROUP BY  g.time, g.Distance;
CountAzimuth:86
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='2964' GROUP BY  g.time, g.Distance;
CountAzimuth:295
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 23:0:0' AND e.date<='2025-02-25 5:0:0' AND e.DeviceLoginName='4819' 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>='2025-02-24 21:00:00' AND g.time<='2025-02-25 03:00:00' AND g.DeviceLoginName='4819' GROUP BY  g.time, g.Distance;
CountAzimuth:258
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 0:0:0' AND e.date<='2025-02-28 23:0:0' AND e.DeviceLoginName='355234055581363' 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>='2025-02-23 22:00:00' AND g.time<='2025-02-28 21:00:00' AND g.DeviceLoginName='355234055581363' GROUP BY  g.time, g.Distance;
CountAzimuth:3084
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-17 0:0:0' AND e.date<='2025-02-21 23:0:0' AND e.DeviceLoginName='3212' 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>='2025-02-16 22:00:00' AND g.time<='2025-02-21 21:00:00' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:13031
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-17 0:0:0' AND e.date<='2025-02-21 23:0:0' AND e.DeviceLoginName='3212' 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>='2025-02-16 22:00:00' AND g.time<='2025-02-21 21:00:00' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:13031
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 0:0:0' AND e.date<='2025-02-28 23:0:0' AND e.DeviceLoginName='3212' 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>='2025-02-23 22:00:00' AND g.time<='2025-02-28 21:00:00' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:7945
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-28 0:23:51' AND e.date<='2025-02-28 11:23:51' AND e.DeviceLoginName='352353083458635' 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>='2025-02-27 22:23:51' AND g.time<='2025-02-28 09:23:51' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:322
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2025-02-27 22:00:00' AND g.time<='2025-02-28 10:06:49' AND g.DeviceLoginName='356078111294241'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-28 06:57:00' AND TIME<='2025-02-28 07:07:00' AND DeviceLoginName='356078111294241' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-28 07:53:23' AND TIME<='2025-02-28 08:03:23' AND DeviceLoginName='356078111294241' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='356078111294241' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2025-02-27 22:00:00' AND e.date<='2025-02-28 10:06:49'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-28 06:57:00' AND TIME<='2025-02-28 07:07:00' AND DeviceLoginName='356078111294241' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-28 07:53:23' AND TIME<='2025-02-28 08:03:23' AND DeviceLoginName='356078111294241' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='4848' GROUP BY  g.time, g.Distance;
CountAzimuth:96
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 5:0:0' AND e.DeviceLoginName='2545' 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='2545' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 5:0:0' AND e.DeviceLoginName='9014' 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='9014' GROUP BY  g.time, g.Distance;
CountAzimuth:91
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 5:0:0' AND e.DeviceLoginName='356078111430837' 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='356078111430837' GROUP BY  g.time, g.Distance;
CountAzimuth:6
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 5:0:0' AND e.DeviceLoginName='3263' 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='3263' GROUP BY  g.time, g.Distance;
CountAzimuth:154
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 5:0:0' AND e.DeviceLoginName='862531041041642' 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='862531041041642' GROUP BY  g.time, g.Distance;
CountAzimuth:23
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 5:0:0' AND e.DeviceLoginName='2500' 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:318
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='2947' GROUP BY  g.time, g.Distance;
CountAzimuth:53
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='3124' GROUP BY  g.time, g.Distance;
CountAzimuth:75
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:103
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='2866' GROUP BY  g.time, g.Distance;
CountAzimuth:164
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 5:0:0' AND e.DeviceLoginName='3092' 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='3092' GROUP BY  g.time, g.Distance;
CountAzimuth:22
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 5:0:0' AND e.DeviceLoginName='2846' 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='2846' GROUP BY  g.time, g.Distance;
CountAzimuth:8
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 5:0:0' AND e.DeviceLoginName='2610' 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='2610' GROUP BY  g.time, g.Distance;
CountAzimuth:38
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 5:0:0' AND e.DeviceLoginName='2676' 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:232
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 5:0:0' AND e.DeviceLoginName='352353086181416' 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='352353086181416' GROUP BY  g.time, g.Distance;
CountAzimuth:110
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='2499' GROUP BY  g.time, g.Distance;
CountAzimuth:272
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 5:0:0' AND e.DeviceLoginName='2584' 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='2584' GROUP BY  g.time, g.Distance;
CountAzimuth:259
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='3187' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 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>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='2597' GROUP BY  g.time, g.Distance;
CountAzimuth:9
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-25 23:0:0' AND e.date<='2025-02-26 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-25 21:00:00' AND g.time<='2025-02-26 03:00:00' AND g.DeviceLoginName='2964' GROUP BY  g.time, g.Distance;
CountAzimuth:337
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-24 0:0:0' AND e.date<='2025-02-28 23: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>='2025-02-23 22:00:00' AND g.time<='2025-02-28 21:00:00' AND g.DeviceLoginName='5132' GROUP BY  g.time, g.Distance;
CountAzimuth:9374
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='356078116287711' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='356078116287711' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='9011' GROUP BY  g.time, g.Distance;
CountAzimuth:976
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='3176' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='3176' GROUP BY  g.time, g.Distance;
CountAzimuth:466
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='5131' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='5131' GROUP BY  g.time, g.Distance;
CountAzimuth:110
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='3108' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='3108' GROUP BY  g.time, g.Distance;
CountAzimuth:24
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='3154' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='3154' GROUP BY  g.time, g.Distance;
CountAzimuth:312
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='3021' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='3021' GROUP BY  g.time, g.Distance;
CountAzimuth:237
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='9014' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='9014' GROUP BY  g.time, g.Distance;
CountAzimuth:64
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='3263' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='3263' GROUP BY  g.time, g.Distance;
CountAzimuth:167
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:28
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='862531041041642' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='862531041041642' GROUP BY  g.time, g.Distance;
CountAzimuth:42
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='3091' GROUP BY  g.time, g.Distance;
CountAzimuth:14
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='5076' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='5076' GROUP BY  g.time, g.Distance;
CountAzimuth:91
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='2500' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:314
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='3175' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='3175' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:134
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='2866' GROUP BY  g.time, g.Distance;
CountAzimuth:557
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:144
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='2846' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='2846' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='3132' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='3132' GROUP BY  g.time, g.Distance;
CountAzimuth:56
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='2499' GROUP BY  g.time, g.Distance;
CountAzimuth:443
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03: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>='2025-02-26 23:0:0' AND e.date<='2025-02-27 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='2964' GROUP BY  g.time, g.Distance;
CountAzimuth:224
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-26 23:0:0' AND e.date<='2025-02-27 5:0:0' AND e.DeviceLoginName='4819' 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>='2025-02-26 21:00:00' AND g.time<='2025-02-27 03:00:00' AND g.DeviceLoginName='4819' GROUP BY  g.time, g.Distance;
CountAzimuth:34
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='4848' GROUP BY  g.time, g.Distance;
CountAzimuth:199
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='356078111353955' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='356078111353955' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='356078111472284' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='356078111472284' GROUP BY  g.time, g.Distance;
CountAzimuth:600
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='3079' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='3079' GROUP BY  g.time, g.Distance;
CountAzimuth:223
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:29
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='3025' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='3025' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='9014' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='9014' GROUP BY  g.time, g.Distance;
CountAzimuth:87
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='3166' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='3166' GROUP BY  g.time, g.Distance;
CountAzimuth:84
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='354836080152241' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='354836080152241' GROUP BY  g.time, g.Distance;
CountAzimuth:8
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='3126' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='3126' GROUP BY  g.time, g.Distance;
CountAzimuth:39
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='3263' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='3263' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='2677' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='2677' GROUP BY  g.time, g.Distance;
CountAzimuth:705
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:30
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='2722' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='2722' GROUP BY  g.time, g.Distance;
CountAzimuth:31
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='5076' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='5076' GROUP BY  g.time, g.Distance;
CountAzimuth:78
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='2546' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='2546' GROUP BY  g.time, g.Distance;
CountAzimuth:110
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:47
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='352353086131585' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='352353086131585' GROUP BY  g.time, g.Distance;
CountAzimuth:495
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 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>='2025-02-27 23:0:0' AND e.date<='2025-02-28 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:363
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='2743' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='2743' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='3132' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='3132' GROUP BY  g.time, g.Distance;
CountAzimuth:448
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='8983' GROUP BY  g.time, g.Distance;
CountAzimuth:199
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='2499' GROUP BY  g.time, g.Distance;
CountAzimuth:179
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='2584' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='2584' GROUP BY  g.time, g.Distance;
CountAzimuth:226
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='2964' GROUP BY  g.time, g.Distance;
CountAzimuth:93
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 23:0:0' AND e.date<='2025-02-28 5:0:0' AND e.DeviceLoginName='4819' 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>='2025-02-27 21:00:00' AND g.time<='2025-02-28 03:00:00' AND g.DeviceLoginName='4819' GROUP BY  g.time, g.Distance;
CountAzimuth:94
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-27 12:0:15' AND e.date<='2025-02-27 12:22:15' AND e.DeviceLoginName='9005' 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>='2025-02-27 10:00:15' AND g.time<='2025-02-27 10:22:15' AND g.DeviceLoginName='9005' GROUP BY  g.time, g.Distance;
CountAzimuth:65
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-28 4:13:58' AND e.date<='2025-02-28 15:13:58' 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>='2025-02-28 02:13:58' AND g.time<='2025-02-28 13:13:58' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:442
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-28 8:15:6' AND e.date<='2025-02-28 15:15:6' AND e.DeviceLoginName='356078116278207' 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>='2025-02-28 06:15:06' AND g.time<='2025-02-28 13:15:06' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:1180
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-28 7:15:41' AND e.date<='2025-02-28 15:15:41' AND e.DeviceLoginName='352353083458635' 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>='2025-02-28 05:15:41' AND g.time<='2025-02-28 13:15:41' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:211
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-28 9:17:44' AND e.date<='2025-02-28 15:17:44' 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>='2025-02-28 07:17:44' AND g.time<='2025-02-28 13:17:44' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:328
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-28 8:18:1' AND e.date<='2025-02-28 15:18:1' AND e.DeviceLoginName='356078116278207' 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>='2025-02-28 06:18:01' AND g.time<='2025-02-28 13:18:01' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:1181
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-28 3:24:16' AND e.date<='2025-02-28 15:24:16' AND e.DeviceLoginName='352353083458635' 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>='2025-02-28 01:24:16' AND g.time<='2025-02-28 13:24:16' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:507
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-28 6:24:54' AND e.date<='2025-02-28 15:24:54' 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>='2025-02-28 04:24:54' AND g.time<='2025-02-28 13:24:54' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:444
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-28 5:31:17' AND e.date<='2025-02-28 15:31:17' AND e.DeviceLoginName='352353083458635' 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>='2025-02-28 03:31:17' AND g.time<='2025-02-28 13:31:17' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:507
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-28 3:35:22' AND e.date<='2025-02-28 15:35:22' 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>='2025-02-28 01:35:22' AND g.time<='2025-02-28 13:35:22' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:445
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-28 0:46:32' AND e.date<='2025-02-28 15:46:32' AND e.DeviceLoginName='356078116278207' 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>='2025-02-27 22:46:32' AND g.time<='2025-02-28 13:46:32' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:1230
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-28 6:54:5' AND e.date<='2025-02-28 15:54:5' AND e.DeviceLoginName='356078116278207' 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>='2025-02-28 04:54:05' AND g.time<='2025-02-28 13:54:05' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:1230
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-17 22:56:31' AND e.date<='2025-02-28 22:56:31' AND e.DeviceLoginName='352353084149035' 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>='2025-02-17 20:56:31' AND g.time<='2025-02-28 20:56:31' AND g.DeviceLoginName='352353084149035' GROUP BY  g.time, g.Distance;
CountAzimuth:16351