Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-29 7:23:57' AND e.date<='2024-08-29 23:23:57' 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-08-29 04:23:57' AND g.time<='2024-08-29 20:23:57' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1903
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 9:1:31' AND e.date<='2024-08-30 9:1:31' AND e.DeviceLoginName='356078118085444' 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 06:01:31' AND g.time<='2024-08-30 06:01:31' AND g.DeviceLoginName='356078118085444' GROUP BY  g.time, g.Distance;
CountAzimuth:7973
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 0:51:21' AND e.date<='2024-08-26 23:51:21' AND e.DeviceLoginName='2736' 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-25 21:51:21' AND g.time<='2024-08-26 20:51:21' AND g.DeviceLoginName='2736' GROUP BY  g.time, g.Distance;
CountAzimuth:158
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 0:51:21' AND e.date<='2024-08-27 23:51:21' AND e.DeviceLoginName='2736' 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 21:51:21' AND g.time<='2024-08-27 20:51:21' AND g.DeviceLoginName='2736' GROUP BY  g.time, g.Distance;
CountAzimuth:1331
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 1:34:42' AND e.date<='2024-08-30 13:34:42' 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-08-29 22:34:42' AND g.time<='2024-08-30 10:34:42' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:478
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-30 3:37:50' AND e.date<='2024-08-30 13:37:50' AND e.DeviceLoginName='356078116278207' 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 00:37:50' AND g.time<='2024-08-30 10:37:50' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:489
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-06 0:9:33' AND e.date<='2024-08-06 23:59:33' AND e.DeviceLoginName='2580' 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-05 21:09:33' AND g.time<='2024-08-06 20:59:33' AND g.DeviceLoginName='2580' GROUP BY  g.time, g.Distance;
CountAzimuth:583
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-06 0:9:33' AND e.date<='2024-08-06 8:59:33' AND e.DeviceLoginName='2580' 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-05 21:09:33' AND g.time<='2024-08-06 05:59:33' AND g.DeviceLoginName='2580' GROUP BY  g.time, g.Distance;
CountAzimuth:22
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-06 14:9:33' AND e.date<='2024-08-06 23:59:33' AND e.DeviceLoginName='2580' 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-06 11:09:33' AND g.time<='2024-08-06 20:59:33' AND g.DeviceLoginName='2580' GROUP BY  g.time, g.Distance;
CountAzimuth:38
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-08 23:9:33' AND e.date<='2024-08-06 23:59:33' AND e.DeviceLoginName='2580' 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-08 20:09:33' AND g.time<='2024-08-06 20:59:33' AND g.DeviceLoginName='2580' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-15 23:0:33' AND e.date<='2024-08-15 23:59:33' AND e.DeviceLoginName='2580' 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-15 20:00:33' AND g.time<='2024-08-15 20:59:33' AND g.DeviceLoginName='2580' GROUP BY  g.time, g.Distance;
CountAzimuth:15
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-15 22:0:33' AND e.date<='2024-08-15 23:59:33' AND e.DeviceLoginName='2580' 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-15 19:00:33' AND g.time<='2024-08-15 20:59:33' AND g.DeviceLoginName='2580' GROUP BY  g.time, g.Distance;
CountAzimuth:23
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-15 22:0:33' AND e.date<='2024-08-15 23:59:33' AND e.DeviceLoginName='9002' 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-15 19:00:33' AND g.time<='2024-08-15 20:59:33' AND g.DeviceLoginName='9002' GROUP BY  g.time, g.Distance;
CountAzimuth:20
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-15 23:0:33' AND e.date<='2024-08-15 23:59:33' AND e.DeviceLoginName='9002' 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-15 20:00:33' AND g.time<='2024-08-15 20:59:33' AND g.DeviceLoginName='9002' GROUP BY  g.time, g.Distance;
CountAzimuth:20
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-09 23:0:33' AND e.date<='2024-08-09 23:59:33' AND e.DeviceLoginName='9002' 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-09 20:00:33' AND g.time<='2024-08-09 20:59:33' AND g.DeviceLoginName='9002' GROUP BY  g.time, g.Distance;
CountAzimuth:128
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-15 23:0:33' AND e.date<='2024-08-15 23:59:33' AND e.DeviceLoginName='9002' 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-15 20:00:33' AND g.time<='2024-08-15 20:59:33' AND g.DeviceLoginName='9002' GROUP BY  g.time, g.Distance;
CountAzimuth:20
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 23:0:33' AND e.date<='2024-08-20 23:59:33' AND e.DeviceLoginName='2735' 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-20 20:00:33' AND g.time<='2024-08-20 20:59:33' AND g.DeviceLoginName='2735' GROUP BY  g.time, g.Distance;
CountAzimuth:55
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 23:0:33' AND e.date<='2024-08-21 23:59:33' AND e.DeviceLoginName='2735' 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-21 20:00:33' AND g.time<='2024-08-21 20:59:33' AND g.DeviceLoginName='2735' GROUP BY  g.time, g.Distance;
CountAzimuth:50
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-09 23:0:33' AND e.date<='2024-08-09 23:59:33' AND e.DeviceLoginName='2735' 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-09 20:00:33' AND g.time<='2024-08-09 20:59:33' AND g.DeviceLoginName='2735' GROUP BY  g.time, g.Distance;
CountAzimuth:53