Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-11 0:53:33' AND e.date<='2025-02-11 7:53:33' 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-02-10 22:53:33' AND g.time<='2025-02-11 05:53:33' 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-02-10 7:54:15' AND e.date<='2025-02-10 23:54:15' 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-02-10 05:54:15' AND g.time<='2025-02-10 21:54:15' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:863
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-10 7:55:6' AND e.date<='2025-02-10 23:55:6' 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-02-10 05:55:06' AND g.time<='2025-02-10 21:55:06' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1797
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-10 8:28:58' AND e.date<='2025-02-11 8:28:58' 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-02-10 06:28:58' AND g.time<='2025-02-11 06:28:58' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:977
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-10 0:29:23' AND e.date<='2025-02-10 23:29:23' AND e.DeviceLoginName='2674' 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-02-09 22:29:23' AND g.time<='2025-02-10 21:29:23' AND g.DeviceLoginName='2674' GROUP BY  g.time, g.Distance;
CountAzimuth:1647
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-10 0:43:36' AND e.date<='2025-02-10 23:43:36' AND e.DeviceLoginName='2674' 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-02-09 22:43:36' AND g.time<='2025-02-10 21:43:36' AND g.DeviceLoginName='2674' GROUP BY  g.time, g.Distance;
CountAzimuth:1647
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2025-02-10 22:00:00' AND g.time<='2025-02-11 06:50:04' AND g.DeviceLoginName='352353084656807'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-11 06:29:02' AND TIME<='2025-02-11 06:39:02' AND DeviceLoginName='352353084656807' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353084656807' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2025-02-10 22:00:00' AND e.date<='2025-02-11 06:50:04'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-11 04:43:01' AND TIME<='2025-02-11 04:53:01' AND DeviceLoginName='352353084656807' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-11 06:29:02' AND TIME<='2025-02-11 06:39:02' AND DeviceLoginName='352353084656807' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-10 0:58:23' AND e.date<='2025-02-10 23:58:23' AND e.DeviceLoginName='5046' 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-02-09 22:58:23' AND g.time<='2025-02-10 21:58:23' AND g.DeviceLoginName='5046' GROUP BY  g.time, g.Distance;
CountAzimuth:2759
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2025-02-10 22:00:00' AND g.time<='2025-02-11 07:04:19' AND g.DeviceLoginName='2674'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-10 22:43:27' AND TIME<='2025-02-10 22:53:27' AND DeviceLoginName='2674' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-11 03:59:11' AND TIME<='2025-02-11 04:09:11' AND DeviceLoginName='2674' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-11 06:05:11' AND TIME<='2025-02-11 06:15:11' AND DeviceLoginName='2674' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-11 06:27:41' AND TIME<='2025-02-11 06:37:41' AND DeviceLoginName='2674' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2674' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2025-02-10 22:00:00' AND e.date<='2025-02-11 07:04:19'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-10 22:43:27' AND TIME<='2025-02-10 22:53:27' AND DeviceLoginName='2674' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-11 03:59:11' AND TIME<='2025-02-11 04:09:11' AND DeviceLoginName='2674' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-11 06:05:11' AND TIME<='2025-02-11 06:15:11' AND DeviceLoginName='2674' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-02-11 06:27:41' AND TIME<='2025-02-11 06:37:41' AND DeviceLoginName='2674' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-10 0:11:59' AND e.date<='2025-02-10 23:11:59' AND e.DeviceLoginName='3122' 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-02-09 22:11:59' AND g.time<='2025-02-10 21:11:59' AND g.DeviceLoginName='3122' GROUP BY  g.time, g.Distance;
CountAzimuth:3040
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-11 0:21:58' AND e.date<='2025-02-11 11:21:58' 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-02-10 22:21:58' AND g.time<='2025-02-11 09:21:58' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:480
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-11 6:6:11' AND e.date<='2025-02-11 12:6:11' 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-02-11 04:06:11' AND g.time<='2025-02-11 10:06:11' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:498
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-23 0:20:48' AND e.date<='2025-01-19 23:20:48' AND e.DeviceLoginName='352353084149035' 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-22 22:20:48' AND g.time<='2025-01-19 21:20:48' AND g.DeviceLoginName='352353084149035' GROUP BY  g.time, g.Distance;
CountAzimuth:15203
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-11 2:34:55' AND e.date<='2025-02-11 12:34:55' 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-02-11 00:34:55' AND g.time<='2025-02-11 10:34:55' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:249
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-11 0:36:51' AND e.date<='2025-02-11 12:36:51' 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-02-10 22:36:51' AND g.time<='2025-02-11 10:36:51' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:794
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-24 0:43:0' AND e.date<='2024-12-24 23:43:0' AND e.DeviceLoginName='352353084149035' 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-23 22:43:00' AND g.time<='2024-12-24 21:43:00' AND g.DeviceLoginName='352353084149035' GROUP BY  g.time, g.Distance;
CountAzimuth:609
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-30 0:43:0' AND e.date<='2025-01-02 23:43:0' AND e.DeviceLoginName='352353084149035' 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-29 22:43:00' AND g.time<='2025-01-02 21:43:00' AND g.DeviceLoginName='352353084149035' GROUP BY  g.time, g.Distance;
CountAzimuth:1539
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-28 0:57:18' AND e.date<='2024-12-29 23:57:18' AND e.DeviceLoginName='356078111320111' 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-27 22:57:18' AND g.time<='2024-12-29 21:57:18' AND g.DeviceLoginName='356078111320111' GROUP BY  g.time, g.Distance;
CountAzimuth:1650
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-04 0:57:18' AND e.date<='2025-01-05 23:57:18' AND e.DeviceLoginName='356078111320111' 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-03 22:57:18' AND g.time<='2025-01-05 21:57:18' AND g.DeviceLoginName='356078111320111' GROUP BY  g.time, g.Distance;
CountAzimuth:3319
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-11 0:57:18' AND e.date<='2025-01-12 23:57:18' AND e.DeviceLoginName='356078111320111' 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-10 22:57:18' AND g.time<='2025-01-12 21:57:18' AND g.DeviceLoginName='356078111320111' GROUP BY  g.time, g.Distance;
CountAzimuth:2815
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-11 4:16:16' AND e.date<='2025-02-11 13:16:16' 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-02-11 02:16:16' AND g.time<='2025-02-11 11:16:16' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:251
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-11 1:16:33' AND e.date<='2025-02-11 13:16:33' 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-02-10 23:16:33' AND g.time<='2025-02-11 11:16:33' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:870
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-01 0:27:38' AND e.date<='2025-02-02 23:27:38' AND e.DeviceLoginName='352353084149035' 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-31 22:27:38' AND g.time<='2025-02-02 21:27:38' AND g.DeviceLoginName='352353084149035' GROUP BY  g.time, g.Distance;
CountAzimuth:1190
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-04 0:27:38' AND e.date<='2025-01-05 23:27:38' AND e.DeviceLoginName='352353084149035' 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-03 22:27:38' AND g.time<='2025-01-05 21:27:38' AND g.DeviceLoginName='352353084149035' GROUP BY  g.time, g.Distance;
CountAzimuth:1517
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-11 0:27:38' AND e.date<='2025-01-12 23:27:38' AND e.DeviceLoginName='352353084149035' 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-10 22:27:38' AND g.time<='2025-01-12 21:27:38' AND g.DeviceLoginName='352353084149035' GROUP BY  g.time, g.Distance;
CountAzimuth:405
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-18 0:27:38' AND e.date<='2025-01-19 23:27:38' AND e.DeviceLoginName='352353084149035' 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-17 22:27:38' AND g.time<='2025-01-19 21:27:38' AND g.DeviceLoginName='352353084149035' GROUP BY  g.time, g.Distance;
CountAzimuth:2230
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-25 0:27:38' AND e.date<='2025-01-26 23:27:38' AND e.DeviceLoginName='352353084149035' 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-24 22:27:38' AND g.time<='2025-01-26 21:27:38' AND g.DeviceLoginName='352353084149035' GROUP BY  g.time, g.Distance;
CountAzimuth:2708
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-11 6:34:14' AND e.date<='2025-02-11 13:34:14' 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-02-11 04:34:14' AND g.time<='2025-02-11 11:34:14' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:747
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-28 0:27:38' AND e.date<='2024-12-29 23:27:38' AND e.DeviceLoginName='352353084149035' 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-27 22:27:38' AND g.time<='2024-12-29 21:27:38' AND g.DeviceLoginName='352353084149035' GROUP BY  g.time, g.Distance;
CountAzimuth:758
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-11 5:34:48' AND e.date<='2025-02-11 13:34:48' 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-02-11 03:34:48' AND g.time<='2025-02-11 11:34:48' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:886
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-11 0:57:18' AND e.date<='2025-01-12 23:57:18' AND e.DeviceLoginName='352353084149035' 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-10 22:57:18' AND g.time<='2025-01-12 21:57:18' AND g.DeviceLoginName='352353084149035' GROUP BY  g.time, g.Distance;
CountAzimuth:405
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-06 0:57:18' AND e.date<='2025-01-12 23:57:18' AND e.DeviceLoginName='352353084149035' 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:57:18' AND g.time<='2025-01-12 21:57:18' AND g.DeviceLoginName='352353084149035' GROUP BY  g.time, g.Distance;
CountAzimuth:2373
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-30 0:57:18' AND e.date<='2025-01-05 23:57:18' AND e.DeviceLoginName='352353084149035' 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-29 22:57:18' AND g.time<='2025-01-05 21:57:18' AND g.DeviceLoginName='352353084149035' GROUP BY  g.time, g.Distance;
CountAzimuth:3273
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-03 0:58:3' AND e.date<='2025-02-07 23:58:3' AND e.DeviceLoginName='3144' 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-02-02 22:58:03' AND g.time<='2025-02-07 21:58:03' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:763
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-11 1:29:25' AND e.date<='2025-02-11 15:29:25' 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-02-10 23:29:25' AND g.time<='2025-02-11 13:29:25' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1106