Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 4:6:48' AND e.date<='2024-03-20 9:6:48' AND e.DeviceLoginName='2837' 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-03-20 02:06:48' AND g.time<='2024-03-20 07:06:48' AND g.DeviceLoginName='2837' GROUP BY  g.time, g.Distance;
CountAzimuth:722
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 0:13:44' AND e.date<='2024-03-17 23:13:44' AND e.DeviceLoginName='2652' 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-03-15 22:13:44' AND g.time<='2024-03-17 21:13:44' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:545
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 0:13:44' AND e.date<='2024-03-17 23:13:44' AND e.DeviceLoginName='2652' 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-03-16 22:13:44' AND g.time<='2024-03-17 21:13:44' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:108
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 0:13:44' AND e.date<='2024-03-16 23:13:44' AND e.DeviceLoginName='2652' 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-03-15 22:13:44' AND g.time<='2024-03-16 21:13:44' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:437
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-06 0:13:44' AND e.date<='2024-01-07 23:13:44' AND e.DeviceLoginName='2652' 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:13:44' AND g.time<='2024-01-07 21:13:44' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:1573
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-06 0:13:44' AND e.date<='2024-01-06 23:13:44' AND e.DeviceLoginName='2652' 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:13:44' AND g.time<='2024-01-06 21:13:44' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:634
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-13 0:13:44' AND e.date<='2024-01-13 23:13:44' AND e.DeviceLoginName='2652' 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:13:44' AND g.time<='2024-01-13 21:13:44' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:193
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-14 0:13:44' AND e.date<='2024-01-14 23:13:44' AND e.DeviceLoginName='2652' 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-13 22:13:44' AND g.time<='2024-01-14 21:13:44' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:643
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-20 0:13:44' AND e.date<='2024-01-20 23:13:44' AND e.DeviceLoginName='2652' 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-19 22:13:44' AND g.time<='2024-01-20 21:13:44' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:138
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-19 0:13:44' AND e.date<='2024-01-19 23:13:44' AND e.DeviceLoginName='2574' 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 22:13:44' AND g.time<='2024-01-19 21:13:44' AND g.DeviceLoginName='2574' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 0:13:44' AND e.date<='2024-03-19 23:13:44' AND e.DeviceLoginName='2574' 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-03-17 22:13:44' AND g.time<='2024-03-19 21:13:44' AND g.DeviceLoginName='2574' GROUP BY  g.time, g.Distance;
CountAzimuth:519
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 0:13:44' AND e.date<='2024-03-20 23:13:44' AND e.DeviceLoginName='2574' 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-03-17 22:13:44' AND g.time<='2024-03-20 21:13:44' AND g.DeviceLoginName='2574' GROUP BY  g.time, g.Distance;
CountAzimuth:519
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 1:34:39' AND e.date<='2024-03-20 10:34:39' 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-03-19 23:34:39' AND g.time<='2024-03-20 08:34:39' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:388
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 10:56:4' AND e.date<='2024-03-20 10:56:4' AND e.DeviceLoginName='2574' 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-03-19 08:56:04' AND g.time<='2024-03-20 08:56:04' AND g.DeviceLoginName='2574' GROUP BY  g.time, g.Distance;
CountAzimuth:1483
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 2:10:9' AND e.date<='2024-03-20 11:10:9' 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-03-20 00:10:09' AND g.time<='2024-03-20 09:10:09' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:541