Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 9:1:21' AND e.date<='2024-06-07 9:1:21' AND e.DeviceLoginName='3032' 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-03 06:01:21' AND g.time<='2024-06-07 06:01:21' AND g.DeviceLoginName='3032' GROUP BY  g.time, g.Distance;
CountAzimuth:416
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-08 9:1:21' AND e.date<='2024-06-09 9:1:21' 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-06-08 06:01:21' AND g.time<='2024-06-09 06:01:21' AND g.DeviceLoginName='3135' GROUP BY  g.time, g.Distance;
CountAzimuth:1654
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 0:1:21' AND e.date<='2024-06-11 23:1:21' AND e.DeviceLoginName='355234055744904' 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-10 21:01:21' AND g.time<='2024-06-11 20:01:21' AND g.DeviceLoginName='355234055744904' GROUP BY  g.time, g.Distance;
CountAzimuth:718
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 0:1:21' AND e.date<='2024-06-11 5:1:21' AND e.DeviceLoginName='355234055744904' 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-10 21:01:21' AND g.time<='2024-06-11 02:01:21' AND g.DeviceLoginName='355234055744904' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 0:1:21' AND e.date<='2024-06-11 6:1:21' AND e.DeviceLoginName='355234055744904' 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-10 21:01:21' AND g.time<='2024-06-11 03:01:21' AND g.DeviceLoginName='355234055744904' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 0:1:21' AND e.date<='2024-06-11 7:1:21' AND e.DeviceLoginName='355234055744904' 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-10 21:01:21' AND g.time<='2024-06-11 04:01:21' AND g.DeviceLoginName='355234055744904' GROUP BY  g.time, g.Distance;
CountAzimuth:163
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 6:30:21' AND e.date<='2024-06-11 6:40:21' AND e.DeviceLoginName='355234055744904' 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-11 03:30:21' AND g.time<='2024-06-11 03:40:21' AND g.DeviceLoginName='355234055744904' GROUP BY  g.time, g.Distance;
CountAzimuth:69
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 6:25:21' AND e.date<='2024-06-11 6:30:21' AND e.DeviceLoginName='355234055744904' 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-11 03:25:21' AND g.time<='2024-06-11 03:30:21' AND g.DeviceLoginName='355234055744904' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 6:30:21' AND e.date<='2024-06-11 6:35:21' AND e.DeviceLoginName='355234055744904' 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-11 03:30:21' AND g.time<='2024-06-11 03:35:21' AND g.DeviceLoginName='355234055744904' GROUP BY  g.time, g.Distance;
CountAzimuth:42
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 0:30:21' AND e.date<='2024-06-07 19:35:21' AND e.DeviceLoginName='3210' 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-02 21:30:21' AND g.time<='2024-06-07 16:35:21' AND g.DeviceLoginName='3210' GROUP BY  g.time, g.Distance;
CountAzimuth:5190
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 6:52:59' AND e.date<='2024-06-11 14:52:59' AND e.DeviceLoginName='2837' 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-03 03:52:59' AND g.time<='2024-06-11 11:52:59' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:157
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-27 5:54:8' AND e.date<='2024-06-11 14:54:8' AND e.DeviceLoginName='354836080120826' 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-27 02:54:08' AND g.time<='2024-06-11 11:54:08' AND g.DeviceLoginName='354836080120826' GROUP BY  g.time, g.Distance;
CountAzimuth:228
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 12:22:2' AND e.date<='2024-06-11 15:22:2' AND e.DeviceLoginName='3056' 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-11 09:22:02' AND g.time<='2024-06-11 12:22:02' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:821
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 11:22:34' AND e.date<='2024-06-11 15:22:34' AND e.DeviceLoginName='356078116278207' 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-11 08:22:34' AND g.time<='2024-06-11 12:22:34' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:583