Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 0:10:21' AND e.date<='2024-10-02 23:10:21' AND e.DeviceLoginName='862531041078313' 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-10-01 21:10:21' AND g.time<='2024-10-02 20:10:21' AND g.DeviceLoginName='862531041078313' GROUP BY  g.time, g.Distance;
CountAzimuth:2222
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 0:10:21' AND e.date<='2024-10-03 23:10:21' AND e.DeviceLoginName='2833' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 21:10:21' AND g.time<='2024-10-03 20:10:21' AND g.DeviceLoginName='2833' GROUP BY  g.time, g.Distance;
CountAzimuth:4828
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 0:10:21' AND e.date<='2024-10-03 23:10:21' AND e.DeviceLoginName='4966' 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-10-02 21:10:21' AND g.time<='2024-10-03 20:10:21' AND g.DeviceLoginName='4966' GROUP BY  g.time, g.Distance;
CountAzimuth:1014
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 0:10:21' AND e.date<='2024-10-03 23:10:21' AND e.DeviceLoginName='2526' 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-10-02 21:10:21' AND g.time<='2024-10-03 20:10:21' AND g.DeviceLoginName='2526' GROUP BY  g.time, g.Distance;
CountAzimuth:1856
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-05 0:10:21' AND e.date<='2024-10-05 23:10:21' AND e.DeviceLoginName='862531041050148' 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-10-04 21:10:21' AND g.time<='2024-10-05 20:10:21' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:492
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 0:10:21' AND e.date<='2024-10-02 23:10:21' AND e.DeviceLoginName='356078116295276' 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-10-01 21:10:21' AND g.time<='2024-10-02 20:10:21' AND g.DeviceLoginName='356078116295276' GROUP BY  g.time, g.Distance;
CountAzimuth:666
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 12:25:8' AND e.date<='2024-10-07 13:11:8' AND e.DeviceLoginName='356078111473761' 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-10-07 09:25:08' AND g.time<='2024-10-07 10:11:08' AND g.DeviceLoginName='356078111473761' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 12:25:8' AND e.date<='2024-10-07 13:11:8' AND e.DeviceLoginName='3135' 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-10-07 09:25:08' AND g.time<='2024-10-07 10:11:08' AND g.DeviceLoginName='3135' GROUP BY  g.time, g.Distance;
CountAzimuth:134