Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:6:59' AND e.date<='2024-06-17 23:6:59' AND e.DeviceLoginName='862531041080715' 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-16 21:06:59' AND g.time<='2024-06-17 20:06:59' AND g.DeviceLoginName='862531041080715' GROUP BY  g.time, g.Distance;
CountAzimuth:1057
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:6:59' AND e.date<='2024-06-17 23:6:59' AND e.DeviceLoginName='3203' 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-16 21:06:59' AND g.time<='2024-06-17 20:06:59' AND g.DeviceLoginName='3203' GROUP BY  g.time, g.Distance;
CountAzimuth:1158
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:39:56' AND e.date<='2024-06-17 23:39:56' AND e.DeviceLoginName='3203' 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-16 21:39:56' AND g.time<='2024-06-17 20:39:56' AND g.DeviceLoginName='3203' GROUP BY  g.time, g.Distance;
CountAzimuth:1158
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 0:16:21' AND e.date<='2024-06-14 23:16: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-09 21:16:21' AND g.time<='2024-06-14 20:16:21' AND g.DeviceLoginName='3032' GROUP BY  g.time, g.Distance;
CountAzimuth:10
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-07 0:33:25' AND e.date<='2024-06-18 23:33:25' AND e.DeviceLoginName='355234055189084' 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-06 21:33:25' AND g.time<='2024-06-18 20:33:25' AND g.DeviceLoginName='355234055189084' GROUP BY  g.time, g.Distance;
CountAzimuth:4852
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 0:33:25' AND e.date<='2024-06-07 23:33:25' AND e.DeviceLoginName='355234055189084' 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:33:25' AND g.time<='2024-06-07 20:33:25' AND g.DeviceLoginName='355234055189084' GROUP BY  g.time, g.Distance;
CountAzimuth:2529
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-01 0:36:33' AND e.date<='2024-06-02 23:36:33' AND e.DeviceLoginName='355234055189084' 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:36:33' AND g.time<='2024-06-02 20:36:33' AND g.DeviceLoginName='355234055189084' GROUP BY  g.time, g.Distance;
CountAzimuth:598
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-08 0:36:33' AND e.date<='2024-06-09 23:36:33' AND e.DeviceLoginName='355234055189084' 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:36:33' AND g.time<='2024-06-09 20:36:33' AND g.DeviceLoginName='355234055189084' GROUP BY  g.time, g.Distance;
CountAzimuth:324
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 0:36:33' AND e.date<='2024-06-14 23:36:33' AND e.DeviceLoginName='355234055189084' 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-09 21:36:33' AND g.time<='2024-06-14 20:36:33' AND g.DeviceLoginName='355234055189084' GROUP BY  g.time, g.Distance;
CountAzimuth:1121
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 0:36:33' AND e.date<='2024-06-16 23:36:33' AND e.DeviceLoginName='355234055189084' 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:36:33' AND g.time<='2024-06-16 20:36:33' AND g.DeviceLoginName='355234055189084' GROUP BY  g.time, g.Distance;
CountAzimuth:618
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-01 0:9:0' AND e.date<='2024-06-16 23:9:0' AND e.DeviceLoginName='355234055189084' 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:09:00' AND g.time<='2024-06-16 20:09:00' AND g.DeviceLoginName='355234055189084' GROUP BY  g.time, g.Distance;
CountAzimuth:5190
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:9:0' AND e.date<='2024-06-18 23:9:0' AND e.DeviceLoginName='355234055189084' 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-16 21:09:00' AND g.time<='2024-06-18 20:09:00' AND g.DeviceLoginName='355234055189084' GROUP BY  g.time, g.Distance;
CountAzimuth:2152
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-01 0:23:52' AND e.date<='2024-06-16 23:23:52' AND e.DeviceLoginName='355234055189084' 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:23:52' AND g.time<='2024-06-16 20:23:52' AND g.DeviceLoginName='355234055189084' GROUP BY  g.time, g.Distance;
CountAzimuth:5190
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:23:52' AND e.date<='2024-06-18 23:23:52' AND e.DeviceLoginName='355234055189084' 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-16 21:23:52' AND g.time<='2024-06-18 20:23:52' AND g.DeviceLoginName='355234055189084' GROUP BY  g.time, g.Distance;
CountAzimuth:2152
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 15:13:26' AND e.date<='2024-06-18 15:13:26' AND e.DeviceLoginName='2829' 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-17 12:13:26' AND g.time<='2024-06-18 12:13:26' AND g.DeviceLoginName='2829' GROUP BY  g.time, g.Distance;
CountAzimuth:1806
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 0:13:26' AND e.date<='2024-06-16 23:13:26' AND e.DeviceLoginName='355234055189084' 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:13:26' AND g.time<='2024-06-16 20:13:26' AND g.DeviceLoginName='355234055189084' GROUP BY  g.time, g.Distance;
CountAzimuth:618