Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-13 0:11:13' AND e.date<='2024-01-14 23:11:13' AND e.DeviceLoginName='2470' 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-01-12 22:11:13' AND g.time<='2024-01-14 21:11:13' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:3853
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-06 0:11:13' AND e.date<='2024-01-07 23:11:13' AND e.DeviceLoginName='2470' 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-01-05 22:11:13' AND g.time<='2024-01-07 21:11:13' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:2133
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 11:41:47' AND e.date<='2024-01-18 12:41:47' 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-01-18 09:41:47' AND g.time<='2024-01-18 10:41:47' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 0:42:10' AND e.date<='2024-01-18 12:42:10' 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-01-17 22:42:10' AND g.time<='2024-01-18 10:42:10' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:258
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 5:42:46' AND e.date<='2024-01-18 12:42:46' 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-01-18 03:42:46' AND g.time<='2024-01-18 10:42:46' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:98
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 6:46:5' AND e.date<='2024-01-18 12:46:5' 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-01-18 04:46:05' AND g.time<='2024-01-18 10:46:05' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:603
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 7:47:9' AND e.date<='2024-01-18 12:47:9' AND e.DeviceLoginName='3056' 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-01-18 05:47:09' AND g.time<='2024-01-18 10:47:09' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:425
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 10:54:34' AND e.date<='2024-01-18 12:54:34' 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-01-18 08:54:34' AND g.time<='2024-01-18 10:54:34' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:283
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 9:55:7' AND e.date<='2024-01-18 12:55:7' AND e.DeviceLoginName='3056' 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-01-18 07:55:07' AND g.time<='2024-01-18 10:55:07' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:66
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 10:29:45' AND e.date<='2024-01-18 13:29:45' 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-01-18 08:29:45' AND g.time<='2024-01-18 11:29:45' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 11:30:4' AND e.date<='2024-01-18 13:30:4' 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-01-18 09:30:04' AND g.time<='2024-01-18 11:30:04' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:211
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 12:5:46' AND e.date<='2024-01-18 15:5:46' 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-01-18 10:05:46' AND g.time<='2024-01-18 13:05:46' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:487
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 12:6:10' AND e.date<='2024-01-18 15:6:10' AND e.DeviceLoginName='3056' 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-01-18 10:06:10' AND g.time<='2024-01-18 13:06:10' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:120