Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-16 1:14:49' AND e.date<='2025-01-16 7:14:49' 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>='2025-01-15 23:14:49' AND g.time<='2025-01-16 05:14:49' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:257
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-16 4:36:43' AND e.date<='2025-01-16 7:36:43' 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>='2025-01-16 02:36:43' AND g.time<='2025-01-16 05:36:43' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:93
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-16 5:37:0' AND e.date<='2025-01-16 7:37:0' AND e.DeviceLoginName='354836080167561' 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>='2025-01-16 03:37:00' AND g.time<='2025-01-16 05:37:00' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:95
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-16 6:49:56' AND e.date<='2025-01-16 7:49:56' AND e.DeviceLoginName='354836080167561' 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>='2025-01-16 04:49:56' AND g.time<='2025-01-16 05:49:56' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:158
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-01 0:17:57' AND e.date<='2025-01-01 23:17:57' AND e.DeviceLoginName='2809' 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-12-31 22:17:57' AND g.time<='2025-01-01 21:17:57' AND g.DeviceLoginName='2809' GROUP BY  g.time, g.Distance;
CountAzimuth:1534
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-20 0:17:57' AND e.date<='2024-12-20 23:17:57' AND e.DeviceLoginName='2809' 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-12-19 22:17:57' AND g.time<='2024-12-20 21:17:57' AND g.DeviceLoginName='2809' GROUP BY  g.time, g.Distance;
CountAzimuth:1835
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-03 0:17:57' AND e.date<='2025-01-03 23:17:57' AND e.DeviceLoginName='2809' 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>='2025-01-02 22:17:57' AND g.time<='2025-01-03 21:17:57' AND g.DeviceLoginName='2809' GROUP BY  g.time, g.Distance;
CountAzimuth:1237
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-06 0:17:57' AND e.date<='2025-01-06 23:17:57' AND e.DeviceLoginName='2809' 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>='2025-01-05 22:17:57' AND g.time<='2025-01-06 21:17:57' AND g.DeviceLoginName='2809' GROUP BY  g.time, g.Distance;
CountAzimuth:2484
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-01 0:17:57' AND e.date<='2025-01-01 23:17:57' AND e.DeviceLoginName='2809' 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-12-31 22:17:57' AND g.time<='2025-01-01 21:17:57' AND g.DeviceLoginName='2809' GROUP BY  g.time, g.Distance;
CountAzimuth:1534
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-01 0:17:57' AND e.date<='2025-01-03 23:17:57' AND e.DeviceLoginName='2809' 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-12-31 22:17:57' AND g.time<='2025-01-03 21:17:57' AND g.DeviceLoginName='2809' GROUP BY  g.time, g.Distance;
CountAzimuth:2773
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-15 0:51:7' AND e.date<='2025-01-15 23:51:7' AND e.DeviceLoginName='3206' 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>='2025-01-14 22:51:07' AND g.time<='2025-01-15 21:51:07' AND g.DeviceLoginName='3206' GROUP BY  g.time, g.Distance;
CountAzimuth:1696
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-15 10:48:19' AND e.date<='2025-01-16 10:48:19' AND e.DeviceLoginName='5117' 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>='2025-01-15 08:48:19' AND g.time<='2025-01-16 08:48:19' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:29
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-13 0:48:19' AND e.date<='2025-01-13 23:48:19' AND e.DeviceLoginName='5117' 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>='2025-01-12 22:48:19' AND g.time<='2025-01-13 21:48:19' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:712
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-14 0:48:19' AND e.date<='2025-01-14 23:48:19' AND e.DeviceLoginName='5117' 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>='2025-01-13 22:48:19' AND g.time<='2025-01-14 21:48:19' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:906
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-15 0:48:19' AND e.date<='2025-01-15 23:48:19' AND e.DeviceLoginName='5117' 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>='2025-01-14 22:48:19' AND g.time<='2025-01-15 21:48:19' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:56
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-16 0:48:19' AND e.date<='2025-01-16 23:48:19' AND e.DeviceLoginName='5117' 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>='2025-01-15 22:48:19' AND g.time<='2025-01-16 21:48:19' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:29
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-14 0:29:55' AND e.date<='2025-01-14 23:29:55' AND e.DeviceLoginName='4825' 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>='2025-01-13 22:29:55' AND g.time<='2025-01-14 21:29:55' AND g.DeviceLoginName='4825' GROUP BY  g.time, g.Distance;
CountAzimuth:2336
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-16 5:18:28' AND e.date<='2025-01-16 13:18:28' 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>='2025-01-16 03:18:28' AND g.time<='2025-01-16 11:18:28' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:315
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-16 4:8:23' AND e.date<='2025-01-16 14:8:23' 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>='2025-01-16 02:08:23' AND g.time<='2025-01-16 12:08:23' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:135
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-16 9:28:0' AND e.date<='2025-01-16 14:28:0' 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>='2025-01-16 07:28:00' AND g.time<='2025-01-16 12:28:00' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:105
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-15 15:34:15' AND e.date<='2025-01-16 15:34:15' AND e.DeviceLoginName='356078111471005' 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>='2025-01-15 13:34:15' AND g.time<='2025-01-16 13:34:15' AND g.DeviceLoginName='356078111471005' GROUP BY  g.time, g.Distance;
CountAzimuth:326
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-16 0:52:33' AND e.date<='2025-01-16 15:52:33' AND e.DeviceLoginName='2590' 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>='2025-01-15 22:52:33' AND g.time<='2025-01-16 13:52:33' AND g.DeviceLoginName='2590' GROUP BY  g.time, g.Distance;
CountAzimuth:1006