Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-24 8:39:25' AND e.date<='2024-06-25 8:39:25' AND e.DeviceLoginName='8987' 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-06-24 05:39:25' AND g.time<='2024-06-25 05:39:25' AND g.DeviceLoginName='8987' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:39:25' AND e.date<='2024-06-21 23:39:25' 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-06-16 21:39:25' AND g.time<='2024-06-21 20:39:25' AND g.DeviceLoginName='356078118085444' GROUP BY  g.time, g.Distance;
CountAzimuth:4379
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-21 0:2:51' AND e.date<='2024-06-21 23:2:51' AND e.DeviceLoginName='2848' 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-06-20 21:02:51' AND g.time<='2024-06-21 20:02:51' AND g.DeviceLoginName='2848' GROUP BY  g.time, g.Distance;
CountAzimuth:1347
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-25 5:28:2' AND e.date<='2024-06-25 9:28:2' AND e.DeviceLoginName='358021081803706' 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-06-25 02:28:02' AND g.time<='2024-06-25 06:28:02' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:101
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-25 0:28:27' AND e.date<='2024-06-25 9:28:27' 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-06-24 21:28:27' AND g.time<='2024-06-25 06:28:27' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:280
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:15:48' AND e.date<='2024-06-21 23:15:48' AND e.DeviceLoginName='353173060488028' 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-06-16 21:15:48' AND g.time<='2024-06-21 20:15:48' AND g.DeviceLoginName='353173060488028' GROUP BY  g.time, g.Distance;
CountAzimuth:2593