Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-28 8:37:24' AND e.date<='2024-10-30 8:37:24' AND e.DeviceLoginName='2912' 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-10-28 06:37:24' AND g.time<='2024-10-30 06:37:24' AND g.DeviceLoginName='2912' GROUP BY  g.time, g.Distance;
CountAzimuth:5915
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-29 10:4:1' AND e.date<='2024-10-30 10:4:1' AND e.DeviceLoginName='2962' 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-10-29 08:04:01' AND g.time<='2024-10-30 08:04:01' AND g.DeviceLoginName='2962' GROUP BY  g.time, g.Distance;
CountAzimuth:2171
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-28 0:4:1' AND e.date<='2024-10-28 23:4:1' AND e.DeviceLoginName='2962' 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-10-27 22:04:01' AND g.time<='2024-10-28 21:04:01' AND g.DeviceLoginName='2962' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-29 0:4:1' AND e.date<='2024-10-29 23:4:1' AND e.DeviceLoginName='2962' 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-10-28 22:04:01' AND g.time<='2024-10-29 21:04:01' AND g.DeviceLoginName='2962' GROUP BY  g.time, g.Distance;
CountAzimuth:2112
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-21 0:4:1' AND e.date<='2024-10-21 23:4:1' AND e.DeviceLoginName='2962' 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-10-20 22:04:01' AND g.time<='2024-10-21 21:04:01' AND g.DeviceLoginName='2962' GROUP BY  g.time, g.Distance;
CountAzimuth:1812
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 0:4:1' AND e.date<='2024-10-22 23:4:1' AND e.DeviceLoginName='2962' 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-10-21 22:04:01' AND g.time<='2024-10-22 21:04:01' AND g.DeviceLoginName='2962' GROUP BY  g.time, g.Distance;
CountAzimuth:23
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 0:4:1' AND e.date<='2024-10-23 23:4:1' AND e.DeviceLoginName='2962' 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-10-21 22:04:01' AND g.time<='2024-10-23 21:04:01' AND g.DeviceLoginName='2962' GROUP BY  g.time, g.Distance;
CountAzimuth:188
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 0:0:45' AND e.date<='2024-10-19 23:0:45' AND e.DeviceLoginName='9020' 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-10-18 22:00:45' AND g.time<='2024-10-19 21:00:45' AND g.DeviceLoginName='9020' GROUP BY  g.time, g.Distance;
CountAzimuth:1395
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-21 0:0:45' AND e.date<='2024-10-21 23:0:45' AND e.DeviceLoginName='9020' 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-10-20 22:00:45' AND g.time<='2024-10-21 21:00:45' AND g.DeviceLoginName='9020' GROUP BY  g.time, g.Distance;
CountAzimuth:2343
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-29 12:57:44' AND e.date<='2024-10-30 12:57:44' AND e.DeviceLoginName='3144' 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-10-29 10:57:44' AND g.time<='2024-10-30 10:57:44' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:1662
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-21 0:57:44' AND e.date<='2024-10-21 23:57:44' AND e.DeviceLoginName='3144' 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-10-20 22:57:44' AND g.time<='2024-10-21 21:57:44' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:2242
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 0:57:44' AND e.date<='2024-10-22 23:57:44' AND e.DeviceLoginName='3144' 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-10-21 22:57:44' AND g.time<='2024-10-22 21:57:44' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:2623
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-23 0:57:44' AND e.date<='2024-10-23 23:57:44' AND e.DeviceLoginName='3144' 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-10-22 22:57:44' AND g.time<='2024-10-23 21:57:44' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:2063
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 0:57:44' AND e.date<='2024-10-01 23:57:44' AND e.DeviceLoginName='3144' 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-09-30 22:57:44' AND g.time<='2024-10-01 21:57:44' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:1658
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 0:57:44' AND e.date<='2024-10-02 23:57:44' AND e.DeviceLoginName='3144' 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-10-01 22:57:44' AND g.time<='2024-10-02 21:57:44' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 0:57:44' AND e.date<='2024-10-03 23:57:44' AND e.DeviceLoginName='3144' 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-10-01 22:57:44' AND g.time<='2024-10-03 21:57:44' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 0:57:44' AND e.date<='2024-10-04 23:57:44' AND e.DeviceLoginName='3144' 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-10-01 22:57:44' AND g.time<='2024-10-04 21:57:44' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:1