Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 0:37:27' AND e.date<='2024-07-17 6:37:27' 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-07-16 21:37:27' AND g.time<='2024-07-17 03:37:27' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 4:41:49' AND e.date<='2024-07-17 6:41:49' 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-07-17 01:41:49' AND g.time<='2024-07-17 03:41:49' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:135
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 4:51:10' AND e.date<='2024-07-17 6:51:10' 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-07-17 01:51:10' AND g.time<='2024-07-17 03:51:10' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:201
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 9:12:19' AND e.date<='2024-07-17 9:12:19' AND e.DeviceLoginName='356078111430936' 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-07-16 06:12:19' AND g.time<='2024-07-17 06:12:19' AND g.DeviceLoginName='356078111430936' GROUP BY  g.time, g.Distance;
CountAzimuth:7
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 9:12:19' AND e.date<='2024-07-17 9:12:19' AND e.DeviceLoginName='356078111430936' 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-07-08 06:12:19' AND g.time<='2024-07-17 06:12:19' AND g.DeviceLoginName='356078111430936' GROUP BY  g.time, g.Distance;
CountAzimuth:992
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 0:33:6' AND e.date<='2024-07-15 23:33:6' AND e.DeviceLoginName='3157' 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-07-14 21:33:06' AND g.time<='2024-07-15 20:33:06' AND g.DeviceLoginName='3157' GROUP BY  g.time, g.Distance;
CountAzimuth:3239
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:33:6' AND e.date<='2024-07-16 23:33:6' AND e.DeviceLoginName='3157' 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-07-15 21:33:06' AND g.time<='2024-07-16 20:33:06' AND g.DeviceLoginName='3157' GROUP BY  g.time, g.Distance;
CountAzimuth:2119
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 0:1:22' AND e.date<='2024-07-15 23:1:22' AND e.DeviceLoginName='3157' 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-07-14 21:01:22' AND g.time<='2024-07-15 20:01:22' AND g.DeviceLoginName='3157' GROUP BY  g.time, g.Distance;
CountAzimuth:3231
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:1:22' AND e.date<='2024-07-16 23:1:22' AND e.DeviceLoginName='3157' 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-07-15 21:01:22' AND g.time<='2024-07-16 20:01:22' AND g.DeviceLoginName='3157' GROUP BY  g.time, g.Distance;
CountAzimuth:2119
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 0:35:39' AND e.date<='2024-07-10 23:35:39' AND e.DeviceLoginName='3076' 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-07-09 21:35:39' AND g.time<='2024-07-10 20:35:39' AND g.DeviceLoginName='3076' GROUP BY  g.time, g.Distance;
CountAzimuth:3673
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 0:47:12' AND e.date<='2024-07-15 23:47:12' AND e.DeviceLoginName='3212' 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-07-14 21:47:12' AND g.time<='2024-07-15 20:47:12' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:2191
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:47:12' AND e.date<='2024-07-16 23:47:12' AND e.DeviceLoginName='3212' 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-07-15 21:47:12' AND g.time<='2024-07-16 20:47:12' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:2336
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 0:47:12' AND e.date<='2024-07-17 23:47:12' AND e.DeviceLoginName='3212' 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-07-16 21:47:12' AND g.time<='2024-07-17 20:47:12' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:338
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:1:22' AND e.date<='2024-07-16 23:1:22' AND e.DeviceLoginName='352353084097622' 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-07-15 21:01:22' AND g.time<='2024-07-16 20:01:22' AND g.DeviceLoginName='352353084097622' GROUP BY  g.time, g.Distance;
CountAzimuth:1305
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 0:47:12' AND e.date<='2024-07-08 23:47:12' AND e.DeviceLoginName='3212' 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-07-07 21:47:12' AND g.time<='2024-07-08 20:47:12' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:1799
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-09 0:47:12' AND e.date<='2024-07-09 23:47:12' AND e.DeviceLoginName='3212' 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-07-08 21:47:12' AND g.time<='2024-07-09 20:47:12' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:1541
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 0:47:12' AND e.date<='2024-07-10 23:47:12' AND e.DeviceLoginName='3212' 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-07-09 21:47:12' AND g.time<='2024-07-10 20:47:12' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:899
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 0:47:12' AND e.date<='2024-07-11 23:47:12' AND e.DeviceLoginName='3212' 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-07-10 21:47:12' AND g.time<='2024-07-11 20:47:12' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:2128
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 0:47:12' AND e.date<='2024-07-12 23:47:12' AND e.DeviceLoginName='3212' 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-07-11 21:47:12' AND g.time<='2024-07-12 20:47:12' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:1026
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-13 0:47:12' AND e.date<='2024-07-13 23:47:12' AND e.DeviceLoginName='3212' 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-07-12 21:47:12' AND g.time<='2024-07-13 20:47:12' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 0:47:12' AND e.date<='2024-07-15 23:47:12' AND e.DeviceLoginName='3212' 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-07-14 21:47:12' AND g.time<='2024-07-15 20:47:12' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:2191
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-01 0:47:12' AND e.date<='2024-07-01 23:47:12' AND e.DeviceLoginName='3212' 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-06-30 21:47:12' AND g.time<='2024-07-01 20:47:12' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:1800
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-02 0:47:12' AND e.date<='2024-07-02 23:47:12' AND e.DeviceLoginName='3212' 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-07-01 21:47:12' AND g.time<='2024-07-02 20:47:12' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:0