Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-20 0:59:53' AND e.date<='2024-05-20 23:59:53' AND e.DeviceLoginName='8990' 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-05-19 21:59:53' AND g.time<='2024-05-20 20:59:53' AND g.DeviceLoginName='8990' GROUP BY  g.time, g.Distance;
CountAzimuth:4130
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-21 0:59:53' AND e.date<='2024-05-21 23:59:53' AND e.DeviceLoginName='8990' 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-05-20 21:59:53' AND g.time<='2024-05-21 20:59:53' AND g.DeviceLoginName='8990' GROUP BY  g.time, g.Distance;
CountAzimuth:2697
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-22 0:59:53' AND e.date<='2024-05-22 23:59:53' AND e.DeviceLoginName='8990' 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-05-21 21:59:53' AND g.time<='2024-05-22 20:59:53' AND g.DeviceLoginName='8990' GROUP BY  g.time, g.Distance;
CountAzimuth:3096
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-23 0:59:53' AND e.date<='2024-05-23 23:59:53' AND e.DeviceLoginName='8990' 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-05-22 21:59:53' AND g.time<='2024-05-23 20:59:53' AND g.DeviceLoginName='8990' GROUP BY  g.time, g.Distance;
CountAzimuth:2720
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-24 0:59:53' AND e.date<='2024-05-24 23:59:53' AND e.DeviceLoginName='8990' 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-05-23 21:59:53' AND g.time<='2024-05-24 20:59:53' AND g.DeviceLoginName='8990' GROUP BY  g.time, g.Distance;
CountAzimuth:2910
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-24 0:59:53' AND e.date<='2024-05-24 23:59:53' AND e.DeviceLoginName='8990' 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-05-23 21:59:53' AND g.time<='2024-05-24 20:59:53' AND g.DeviceLoginName='8990' GROUP BY  g.time, g.Distance;
CountAzimuth:2910
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-24 0:9:16' AND e.date<='2024-05-24 23:9:16' AND e.DeviceLoginName='8990' 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-05-23 21:09:16' AND g.time<='2024-05-24 20:09:16' AND g.DeviceLoginName='8990' GROUP BY  g.time, g.Distance;
CountAzimuth:2910