Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-19 0:39:30' AND e.date<='2024-02-19 23:39:30' AND e.DeviceLoginName='3070' 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>='2024-02-18 22:39:30' AND g.time<='2024-02-19 21:39:30' AND g.DeviceLoginName='3070' GROUP BY  g.time, g.Distance;
CountAzimuth:1745
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-20 0:40:19' AND e.date<='2024-02-20 23:40:19' AND e.DeviceLoginName='3070' 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>='2024-02-19 22:40:19' AND g.time<='2024-02-20 21:40:19' AND g.DeviceLoginName='3070' GROUP BY  g.time, g.Distance;
CountAzimuth:1981
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 5:40:49' AND e.date<='2024-02-27 23:40:49' AND e.DeviceLoginName='2754' 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>='2024-02-27 03:40:49' AND g.time<='2024-02-27 21:40:49' AND g.DeviceLoginName='2754' GROUP BY  g.time, g.Distance;
CountAzimuth:1822
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-21 0:41:15' AND e.date<='2024-02-21 23:41:15' AND e.DeviceLoginName='3070' 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>='2024-02-20 22:41:15' AND g.time<='2024-02-21 21:41:15' AND g.DeviceLoginName='3070' GROUP BY  g.time, g.Distance;
CountAzimuth:1887
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-22 0:42:40' AND e.date<='2024-02-22 23:42:40' AND e.DeviceLoginName='3070' 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>='2024-02-21 22:42:40' AND g.time<='2024-02-22 21:42:40' AND g.DeviceLoginName='3070' GROUP BY  g.time, g.Distance;
CountAzimuth:2431
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-23 0:45:20' AND e.date<='2024-02-23 23:45:20' AND e.DeviceLoginName='3070' 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>='2024-02-22 22:45:20' AND g.time<='2024-02-23 21:45:20' AND g.DeviceLoginName='3070' GROUP BY  g.time, g.Distance;
CountAzimuth:1806
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-24 0:47:12' AND e.date<='2024-02-24 23:47:12' AND e.DeviceLoginName='3070' 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>='2024-02-23 22:47:12' AND g.time<='2024-02-24 21:47:12' AND g.DeviceLoginName='3070' GROUP BY  g.time, g.Distance;
CountAzimuth:61
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-25 0:47:52' AND e.date<='2024-02-25 23:47:52' AND e.DeviceLoginName='3070' 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>='2024-02-24 22:47:52' AND g.time<='2024-02-25 21:47:52' AND g.DeviceLoginName='3070' GROUP BY  g.time, g.Distance;
CountAzimuth:573
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 0:24:36' AND e.date<='2024-02-27 23:24:36' AND e.DeviceLoginName='352353083499175' 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>='2024-02-26 22:24:36' AND g.time<='2024-02-27 21:24:36' AND g.DeviceLoginName='352353083499175' GROUP BY  g.time, g.Distance;
CountAzimuth:1457
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-28 11:1:55' AND e.date<='2024-02-28 11:1:55' AND e.DeviceLoginName='2754' 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>='2024-02-28 09:01:55' AND g.time<='2024-02-28 09:01:55' AND g.DeviceLoginName='2754' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-28 3:14:48' AND e.date<='2024-02-28 12:14: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>='2024-02-28 01:14:48' AND g.time<='2024-02-28 10:14:48' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:424
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-28 8:15:16' AND e.date<='2024-02-28 12:15:16' 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>='2024-02-28 06:15:16' AND g.time<='2024-02-28 10:15:16' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:452
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-28 5:15:56' AND e.date<='2024-02-28 12:15:56' 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>='2024-02-28 03:15:56' AND g.time<='2024-02-28 10:15:56' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:871
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-28 3:38:10' AND e.date<='2024-02-28 12:38:10' 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>='2024-02-28 01:38:10' AND g.time<='2024-02-28 10:38:10' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 12:38:27' AND e.date<='2024-02-28 12:38:27' 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>='2024-02-27 10:38:27' AND g.time<='2024-02-28 10:38:27' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:992
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-28 2:39:5' AND e.date<='2024-02-28 12:39:5' 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>='2024-02-28 00:39:05' AND g.time<='2024-02-28 10:39:05' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:443
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-28 0:37:7' AND e.date<='2024-02-28 13:37:7' 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>='2024-02-27 22:37:07' AND g.time<='2024-02-28 11:37:07' AND g.DeviceLoginName='356078111301566' GROUP BY  g.time, g.Distance;
CountAzimuth:628
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-28 3:37:54' AND e.date<='2024-02-28 13:37:54' 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>='2024-02-28 01:37:54' AND g.time<='2024-02-28 11:37:54' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:473
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-28 5:11:10' AND e.date<='2024-02-28 14:11:10' 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>='2024-02-28 03:11:10' AND g.time<='2024-02-28 12:11:10' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:710
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-28 7:40:23' AND e.date<='2024-02-28 15:40:23' 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>='2024-02-28 05:40:23' AND g.time<='2024-02-28 13:40:23' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:406
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-28 9:41:6' AND e.date<='2024-02-28 15:41:6' 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>='2024-02-28 07:41:06' AND g.time<='2024-02-28 13:41:06' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-28 10:41:20' AND e.date<='2024-02-28 15:41:20' 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>='2024-02-28 08:41:20' AND g.time<='2024-02-28 13:41:20' AND g.DeviceLoginName='356078111301566' GROUP BY  g.time, g.Distance;
CountAzimuth:585