Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-11 0:19:50' AND e.date<='2024-04-11 9:19:50' AND e.DeviceLoginName='2556' 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-04-10 21:19:50' AND g.time<='2024-04-11 06:19:50' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:494
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-11 0:55:17' AND e.date<='2024-04-11 10:55:17' 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-04-10 21:55:17' AND g.time<='2024-04-11 07:55:17' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:262
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-11 1:9:53' AND e.date<='2024-04-11 12:9:53' 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-04-10 22:09:53' AND g.time<='2024-04-11 09:09:53' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:346
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-04 0:52:31' AND e.date<='2024-04-04 23:52:31' AND e.DeviceLoginName='3089' 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-04-03 21:52:31' AND g.time<='2024-04-04 20:52:31' AND g.DeviceLoginName='3089' GROUP BY  g.time, g.Distance;
CountAzimuth:187
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-11 6:3:48' AND e.date<='2024-04-11 15:3:48' 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-04-11 03:03:48' AND g.time<='2024-04-11 12:03:48' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:619
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-11 7:38:44' AND e.date<='2024-04-11 16:38:44' 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-04-11 04:38:44' AND g.time<='2024-04-11 13:38:44' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:646
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-11 6:0:14' AND e.date<='2024-04-11 17:0:14' 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-04-11 03:00:14' AND g.time<='2024-04-11 14:00:14' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:912
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-11 0:0:0' AND e.date<='2024-04-11 22:15:49' AND e.DeviceLoginName='3179' 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-04-10 21:00:00' AND g.time<='2024-04-11 19:15:49' AND g.DeviceLoginName='3179' GROUP BY  g.time, g.Distance;
CountAzimuth:1781
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-09 0:0:0' AND e.date<='2024-04-09 22:15:49' AND e.DeviceLoginName='3179' 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-04-08 21:00:00' AND g.time<='2024-04-09 19:15:49' AND g.DeviceLoginName='3179' GROUP BY  g.time, g.Distance;
CountAzimuth:581
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-04 0:0:0' AND e.date<='2024-04-04 22:15:49' AND e.DeviceLoginName='3179' 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-04-03 21:00:00' AND g.time<='2024-04-04 19:15:49' AND g.DeviceLoginName='3179' GROUP BY  g.time, g.Distance;
CountAzimuth:4314
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-02 0:0:0' AND e.date<='2024-04-02 22:15:49' AND e.DeviceLoginName='3179' 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-04-01 21:00:00' AND g.time<='2024-04-02 19:15:49' AND g.DeviceLoginName='3179' GROUP BY  g.time, g.Distance;
CountAzimuth:2045
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-09 0:0:0' AND e.date<='2024-04-09 22:15:49' AND e.DeviceLoginName='3179' 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-04-08 21:00:00' AND g.time<='2024-04-09 19:15:49' AND g.DeviceLoginName='3179' GROUP BY  g.time, g.Distance;
CountAzimuth:581
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-11 0:0:0' AND e.date<='2024-04-11 22:15:49' AND e.DeviceLoginName='3179' 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-04-10 21:00:00' AND g.time<='2024-04-11 19:15:49' AND g.DeviceLoginName='3179' GROUP BY  g.time, g.Distance;
CountAzimuth:1781