Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-01 0:0:53' AND e.date<='2024-07-03 9:0:53' AND e.DeviceLoginName='3186' 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-30 21:00:53' AND g.time<='2024-07-03 06:00:53' AND g.DeviceLoginName='3186' GROUP BY  g.time, g.Distance;
CountAzimuth:305
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-24 0:0:53' AND e.date<='2024-06-28 23:0:53' AND e.DeviceLoginName='2762' 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-23 21:00:53' AND g.time<='2024-06-28 20:00:53' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:9160
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-25 0:14:24' AND e.date<='2024-06-25 23:14:24' AND e.DeviceLoginName='2762' 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:14:24' AND g.time<='2024-06-25 20:14:24' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:1593
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-26 0:14:24' AND e.date<='2024-06-26 23:14:24' AND e.DeviceLoginName='2762' 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 21:14:24' AND g.time<='2024-06-26 20:14:24' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:4694
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-27 0:14:24' AND e.date<='2024-06-27 23:14:24' AND e.DeviceLoginName='2762' 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-26 21:14:24' AND g.time<='2024-06-27 20:14:24' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:2873
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-28 0:14:24' AND e.date<='2024-06-28 23:14:24' AND e.DeviceLoginName='2762' 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-27 21:14:24' AND g.time<='2024-06-28 20:14:24' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-24 0:14:24' AND e.date<='2024-06-24 23:14:24' AND e.DeviceLoginName='2762' 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-23 21:14:24' AND g.time<='2024-06-24 20:14:24' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-01 0:14:24' AND e.date<='2024-07-03 23:14:24' AND e.DeviceLoginName='2762' 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-30 21:14:24' AND g.time<='2024-07-03 20:14:24' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-29 0:18:41' AND e.date<='2024-06-30 23:18:41' AND e.DeviceLoginName='352353086167449' 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-28 21:18:41' AND g.time<='2024-06-30 20:18:41' AND g.DeviceLoginName='352353086167449' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-06 0:37:6' AND e.date<='2024-07-07 23:37:6' AND e.DeviceLoginName='355234055747170' 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-07-05 21:37:06' AND g.time<='2024-07-07 20:37:06' AND g.DeviceLoginName='355234055747170' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-06 0:37:6' AND e.date<='2024-07-07 23:37:6' AND e.DeviceLoginName='9374' 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-07-05 21:37:06' AND g.time<='2024-07-07 20:37:06' AND g.DeviceLoginName='9374' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-29 0:37:6' AND e.date<='2024-06-30 23:37:6' AND e.DeviceLoginName='9374' 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-28 21:37:06' AND g.time<='2024-06-30 20:37:06' AND g.DeviceLoginName='9374' GROUP BY  g.time, g.Distance;
CountAzimuth:1214
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-22 0:37:6' AND e.date<='2024-06-23 23:37:6' AND e.DeviceLoginName='9374' 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-21 21:37:06' AND g.time<='2024-06-23 20:37:06' AND g.DeviceLoginName='9374' GROUP BY  g.time, g.Distance;
CountAzimuth:1078
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-29 0:37:6' AND e.date<='2024-06-30 23:37:6' AND e.DeviceLoginName='9374' 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-28 21:37:06' AND g.time<='2024-06-30 20:37:06' AND g.DeviceLoginName='9374' GROUP BY  g.time, g.Distance;
CountAzimuth:1214
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-01 0:26:33' AND e.date<='2024-06-02 23:26:33' AND e.DeviceLoginName='2546' 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-31 21:26:33' AND g.time<='2024-06-02 20:26:33' AND g.DeviceLoginName='2546' GROUP BY  g.time, g.Distance;
CountAzimuth:218
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-08 0:26:33' AND e.date<='2024-06-09 23:26:33' AND e.DeviceLoginName='2546' 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-07 21:26:33' AND g.time<='2024-06-09 20:26:33' AND g.DeviceLoginName='2546' GROUP BY  g.time, g.Distance;
CountAzimuth:10
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 0:26:33' AND e.date<='2024-06-16 23:26:33' AND e.DeviceLoginName='2546' 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-14 21:26:33' AND g.time<='2024-06-16 20:26:33' AND g.DeviceLoginName='2546' GROUP BY  g.time, g.Distance;
CountAzimuth:10
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-22 0:26:33' AND e.date<='2024-06-23 23:26:33' AND e.DeviceLoginName='2546' 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-21 21:26:33' AND g.time<='2024-06-23 20:26:33' AND g.DeviceLoginName='2546' GROUP BY  g.time, g.Distance;
CountAzimuth:31
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-29 0:26:33' AND e.date<='2024-06-30 23:26:33' AND e.DeviceLoginName='2546' 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-28 21:26:33' AND g.time<='2024-06-30 20:26:33' AND g.DeviceLoginName='2546' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-01 0:26:33' AND e.date<='2024-06-02 23:26:33' AND e.DeviceLoginName='2546' 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-31 21:26:33' AND g.time<='2024-06-02 20:26:33' AND g.DeviceLoginName='2546' GROUP BY  g.time, g.Distance;
CountAzimuth:218