Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 0:34:40' AND e.date<='2023-12-27 11:34:40' AND e.DeviceLoginName='352353083458635' 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>='2023-12-26 22:34:40' AND g.time<='2023-12-27 09:34:40' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:326
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 7:44:33' AND e.date<='2023-12-27 12:44:33' AND e.DeviceLoginName='358021081803706' 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>='2023-12-27 05:44:33' AND g.time<='2023-12-27 10:44:33' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:252
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 7:44:59' AND e.date<='2023-12-27 12:44:59' AND e.DeviceLoginName='2556' 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>='2023-12-27 05:44:59' AND g.time<='2023-12-27 10:44:59' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:142
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 3:52:38' AND e.date<='2023-12-27 12:52:38' AND e.DeviceLoginName='2473' 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>='2023-12-27 01:52:38' AND g.time<='2023-12-27 10:52:38' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:538
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 6:56:37' AND e.date<='2023-12-27 13:56:37' AND e.DeviceLoginName='356078111301566' 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>='2023-12-27 04:56:37' AND g.time<='2023-12-27 11:56:37' AND g.DeviceLoginName='356078111301566' GROUP BY  g.time, g.Distance;
CountAzimuth:1058
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 0:1:59' AND e.date<='2023-12-27 14:1:59' AND e.DeviceLoginName='352353086185144' 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>='2023-12-26 22:01:59' AND g.time<='2023-12-27 12:01:59' AND g.DeviceLoginName='352353086185144' GROUP BY  g.time, g.Distance;
CountAzimuth:917
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-27 1:21:48' AND e.date<='2023-12-27 15:21:48' AND e.DeviceLoginName='2556' 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>='2023-12-26 23:21:48' AND g.time<='2023-12-27 13:21:48' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:434