Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 0:48:24' AND e.date<='2025-04-21 23:48:24' AND e.DeviceLoginName='354836080173346' 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>='2025-04-20 21:48:24' AND g.time<='2025-04-21 20:48:24' AND g.DeviceLoginName='354836080173346' GROUP BY  g.time, g.Distance;
CountAzimuth:1075
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 0:51:6' AND e.date<='2025-04-21 23:51:6' AND e.DeviceLoginName='3144' 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>='2025-04-20 21:51:06' AND g.time<='2025-04-21 20:51:06' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 0:52:40' AND e.date<='2025-04-21 23:52:40' AND e.DeviceLoginName='2749' 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>='2025-04-20 21:52:40' AND g.time<='2025-04-21 20:52:40' AND g.DeviceLoginName='2749' GROUP BY  g.time, g.Distance;
CountAzimuth:1854
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 0:55:45' AND e.date<='2025-04-21 23:55:45' AND e.DeviceLoginName='3209' 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>='2025-04-20 21:55:45' AND g.time<='2025-04-21 20:55:45' AND g.DeviceLoginName='3209' GROUP BY  g.time, g.Distance;
CountAzimuth:2487
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 0:58:12' AND e.date<='2025-04-21 23:58:12' AND e.DeviceLoginName='358021081816773' 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>='2025-04-20 21:58:12' AND g.time<='2025-04-21 20:58:12' AND g.DeviceLoginName='358021081816773' GROUP BY  g.time, g.Distance;
CountAzimuth:2390
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 0:0:12' AND e.date<='2025-04-21 23:0:12' AND e.DeviceLoginName='9022' 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>='2025-04-20 21:00:12' AND g.time<='2025-04-21 20:00:12' AND g.DeviceLoginName='9022' GROUP BY  g.time, g.Distance;
CountAzimuth:2759
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 0:3:58' AND e.date<='2025-04-21 23:3:58' AND e.DeviceLoginName='3060' 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>='2025-04-20 21:03:58' AND g.time<='2025-04-21 20:03:58' AND g.DeviceLoginName='3060' GROUP BY  g.time, g.Distance;
CountAzimuth:2911
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 9:20:49' AND e.date<='2025-04-22 9:20:49' AND e.DeviceLoginName='356078118129507' 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>='2025-04-21 06:20:49' AND g.time<='2025-04-22 06:20:49' AND g.DeviceLoginName='356078118129507' GROUP BY  g.time, g.Distance;
CountAzimuth:829
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-14 0:22:46' AND e.date<='2025-04-14 23:22:46' AND e.DeviceLoginName='352353086186647' 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>='2025-04-13 21:22:46' AND g.time<='2025-04-14 20:22:46' AND g.DeviceLoginName='352353086186647' GROUP BY  g.time, g.Distance;
CountAzimuth:1296
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-14 0:22:46' AND e.date<='2025-04-14 23:22:46' AND e.DeviceLoginName='352353083338704' 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>='2025-04-13 21:22:46' AND g.time<='2025-04-14 20:22:46' AND g.DeviceLoginName='352353083338704' GROUP BY  g.time, g.Distance;
CountAzimuth:2050
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-15 0:22:46' AND e.date<='2025-04-15 23:22:46' AND e.DeviceLoginName='352353083338704' 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>='2025-04-14 21:22:46' AND g.time<='2025-04-15 20:22:46' AND g.DeviceLoginName='352353083338704' GROUP BY  g.time, g.Distance;
CountAzimuth:1700
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-16 0:22:46' AND e.date<='2025-04-16 23:22:46' AND e.DeviceLoginName='352353083338704' 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>='2025-04-15 21:22:46' AND g.time<='2025-04-16 20:22:46' AND g.DeviceLoginName='352353083338704' GROUP BY  g.time, g.Distance;
CountAzimuth:6
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-17 0:22:46' AND e.date<='2025-04-17 23:22:46' AND e.DeviceLoginName='352353083338704' 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>='2025-04-16 21:22:46' AND g.time<='2025-04-17 20:22:46' AND g.DeviceLoginName='352353083338704' GROUP BY  g.time, g.Distance;
CountAzimuth:2097
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 0:22:46' AND e.date<='2025-04-18 23:22:46' AND e.DeviceLoginName='352353083338704' 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>='2025-04-17 21:22:46' AND g.time<='2025-04-18 20:22:46' AND g.DeviceLoginName='352353083338704' GROUP BY  g.time, g.Distance;
CountAzimuth:842
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 0:32:34' AND e.date<='2025-04-21 23:32:34' AND e.DeviceLoginName='2906' 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>='2025-04-20 21:32:34' AND g.time<='2025-04-21 20:32:34' AND g.DeviceLoginName='2906' GROUP BY  g.time, g.Distance;
CountAzimuth:1266
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 0:34:37' AND e.date<='2025-04-21 23:34:37' AND e.DeviceLoginName='2906' 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>='2025-04-20 21:34:37' AND g.time<='2025-04-21 20:34:37' AND g.DeviceLoginName='2906' GROUP BY  g.time, g.Distance;
CountAzimuth:1266
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2025-04-21 21:00:00' AND g.time<='2025-04-22 06:39:08' AND g.DeviceLoginName='2709'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-21 21:28:11' AND TIME<='2025-04-21 21:38:11' AND DeviceLoginName='2709' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-21 22:23:36' AND TIME<='2025-04-21 22:33:36' AND DeviceLoginName='2709' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-22 00:45:01' AND TIME<='2025-04-22 00:55:01' AND DeviceLoginName='2709' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-22 04:21:51' AND TIME<='2025-04-22 04:31:51' AND DeviceLoginName='2709' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-22 04:46:21' AND TIME<='2025-04-22 04:56:21' AND DeviceLoginName='2709' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-22 06:20:21' AND TIME<='2025-04-22 06:30:21' AND DeviceLoginName='2709' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2709' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2025-04-21 21:00:00' AND e.date<='2025-04-22 06:39:08'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-21 21:28:11' AND TIME<='2025-04-21 21:38:11' AND DeviceLoginName='2709' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-21 22:23:36' AND TIME<='2025-04-21 22:33:36' AND DeviceLoginName='2709' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-22 00:45:01' AND TIME<='2025-04-22 00:55:01' AND DeviceLoginName='2709' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-22 04:21:51' AND TIME<='2025-04-22 04:31:51' AND DeviceLoginName='2709' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-22 04:46:21' AND TIME<='2025-04-22 04:56:21' AND DeviceLoginName='2709' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-22 06:20:21' AND TIME<='2025-04-22 06:30:21' AND DeviceLoginName='2709' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:38:49' AND e.date<='2025-04-18 23:38:49' AND e.DeviceLoginName='3055' 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>='2025-04-18 20:38:49' AND g.time<='2025-04-18 20:38:49' AND g.DeviceLoginName='3055' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:38:49' AND e.date<='2025-04-18 23:38:49' AND e.DeviceLoginName='3055' 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>='2025-04-18 20:38:49' AND g.time<='2025-04-18 20:38:49' AND g.DeviceLoginName='3055' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:38:49' AND e.date<='2025-04-21 23:38:49' AND e.DeviceLoginName='3055' 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>='2025-04-18 20:38:49' AND g.time<='2025-04-21 20:38:49' AND g.DeviceLoginName='3055' GROUP BY  g.time, g.Distance;
CountAzimuth:3317
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-14 0:47:59' AND e.date<='2025-04-18 23:47:59' AND e.DeviceLoginName='3023' 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>='2025-04-13 21:47:59' AND g.time<='2025-04-18 20:47:59' AND g.DeviceLoginName='3023' GROUP BY  g.time, g.Distance;
CountAzimuth:19986
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-17 0:22:46' AND e.date<='2025-04-17 23:22:46' AND e.DeviceLoginName='2908' 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>='2025-04-16 21:22:46' AND g.time<='2025-04-17 20:22:46' AND g.DeviceLoginName='2908' GROUP BY  g.time, g.Distance;
CountAzimuth:4045
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-17 0:53:9' AND e.date<='2025-04-17 23:53:9' AND e.DeviceLoginName='356078118129507' 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>='2025-04-16 21:53:09' AND g.time<='2025-04-17 20:53:09' AND g.DeviceLoginName='356078118129507' GROUP BY  g.time, g.Distance;
CountAzimuth:9
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-20 0:54:52' AND e.date<='2025-04-20 23:54:52' AND e.DeviceLoginName='356078118129507' 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>='2025-04-19 21:54:52' AND g.time<='2025-04-20 20:54:52' AND g.DeviceLoginName='356078118129507' GROUP BY  g.time, g.Distance;
CountAzimuth:902
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='3057' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='3057' GROUP BY  g.time, g.Distance;
CountAzimuth:202
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='4849' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:83
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='2703' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='2703' GROUP BY  g.time, g.Distance;
CountAzimuth:68
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='3263' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='3263' GROUP BY  g.time, g.Distance;
CountAzimuth:37
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='2677' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='2677' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='2773' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='2773' GROUP BY  g.time, g.Distance;
CountAzimuth:258
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='862531041041535' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='862531041041535' GROUP BY  g.time, g.Distance;
CountAzimuth:28
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='352353085648530' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='352353085648530' GROUP BY  g.time, g.Distance;
CountAzimuth:80
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='2728' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='2728' GROUP BY  g.time, g.Distance;
CountAzimuth:29
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='2610' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='2610' GROUP BY  g.time, g.Distance;
CountAzimuth:52
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='2495' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='2495' GROUP BY  g.time, g.Distance;
CountAzimuth:6
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='2676' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:78
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='3197' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='3197' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 23:0:0' AND e.date<='2025-04-19 5:0:0' AND e.DeviceLoginName='2964' 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>='2025-04-18 20:00:00' AND g.time<='2025-04-19 02:00:00' AND g.DeviceLoginName='2964' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-19 23:0:0' AND e.date<='2025-04-20 5:0:0' AND e.DeviceLoginName='2790' 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>='2025-04-19 20:00:00' AND g.time<='2025-04-20 02:00:00' AND g.DeviceLoginName='2790' GROUP BY  g.time, g.Distance;
CountAzimuth:46
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-19 23:0:0' AND e.date<='2025-04-20 5:0:0' AND e.DeviceLoginName='356078111430837' 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>='2025-04-19 20:00:00' AND g.time<='2025-04-20 02:00:00' AND g.DeviceLoginName='356078111430837' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-19 23:0:0' AND e.date<='2025-04-20 5:0:0' AND e.DeviceLoginName='2676' 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>='2025-04-19 20:00:00' AND g.time<='2025-04-20 02:00:00' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:116
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 10:43:57' AND e.date<='2025-04-22 10:43:57' AND e.DeviceLoginName='356078118141502' 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>='2025-04-21 07:43:57' AND g.time<='2025-04-22 07:43:57' AND g.DeviceLoginName='356078118141502' GROUP BY  g.time, g.Distance;
CountAzimuth:3253
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 10:43:57' AND e.date<='2025-04-22 10:43:57' AND e.DeviceLoginName='2781' 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>='2025-04-21 07:43:57' AND g.time<='2025-04-22 07:43:57' AND g.DeviceLoginName='2781' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-13 0:43:57' AND e.date<='2025-04-22 10:43:57' AND e.DeviceLoginName='2781' 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>='2025-04-12 21:43:57' AND g.time<='2025-04-22 07:43:57' AND g.DeviceLoginName='2781' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-13 0:43:57' AND e.date<='2025-04-22 10:43:57' AND e.DeviceLoginName='2781' 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>='2025-04-12 21:43:57' AND g.time<='2025-04-22 07:43:57' AND g.DeviceLoginName='2781' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 2:6:1' AND e.date<='2025-04-22 12:6:1' AND e.DeviceLoginName='352353083458635' 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>='2025-04-21 23:06:01' AND g.time<='2025-04-22 09:06:01' 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>='2025-04-21 0:40:53' AND e.date<='2025-04-22 12:40:53' AND e.DeviceLoginName='352353085039086' 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>='2025-04-20 21:40:53' AND g.time<='2025-04-22 09:40:53' AND g.DeviceLoginName='352353085039086' GROUP BY  g.time, g.Distance;
CountAzimuth:1937
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-20 23:0:0' AND e.date<='2025-04-21 5:0:0' AND e.DeviceLoginName='4849' 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>='2025-04-20 20:00:00' AND g.time<='2025-04-21 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:361
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-20 23:0:0' AND e.date<='2025-04-21 5:0:0' AND e.DeviceLoginName='353173060537865' 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>='2025-04-20 20:00:00' AND g.time<='2025-04-21 02:00:00' AND g.DeviceLoginName='353173060537865' GROUP BY  g.time, g.Distance;
CountAzimuth:55
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 2:14:13' AND e.date<='2025-04-22 13:14:13' AND e.DeviceLoginName='352353083458635' 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>='2025-04-21 23:14:13' AND g.time<='2025-04-22 10:14:13' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:640
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 6:50:13' AND e.date<='2025-04-18 7:5:13' AND e.DeviceLoginName='2971' 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>='2025-04-18 03:50:13' AND g.time<='2025-04-18 04:05:13' AND g.DeviceLoginName='2971' GROUP BY  g.time, g.Distance;
CountAzimuth:26
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-15 12:25:13' AND e.date<='2025-04-15 12:40:13' AND e.DeviceLoginName='352353084234167' 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>='2025-04-15 09:25:13' AND g.time<='2025-04-15 09:40:13' AND g.DeviceLoginName='352353084234167' GROUP BY  g.time, g.Distance;
CountAzimuth:168
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:20:55' AND e.date<='2025-04-22 14:20:55' AND e.DeviceLoginName='352353083458635' 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>='2025-04-21 21:20:55' AND g.time<='2025-04-22 11:20:55' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:738
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 4:22:16' AND e.date<='2025-04-22 14:22:16' AND e.DeviceLoginName='354836080167561' 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>='2025-04-22 01:22:16' AND g.time<='2025-04-22 11:22:16' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:346
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 4:29:51' AND e.date<='2025-04-22 14:29:51' AND e.DeviceLoginName='354836080167561' 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>='2025-04-22 01:29:51' AND g.time<='2025-04-22 11:29:51' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:346
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 6:50:37' AND e.date<='2025-04-22 14:50:37' AND e.DeviceLoginName='352353083458635' 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>='2025-04-22 03:50:37' AND g.time<='2025-04-22 11:50:37' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:515
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 4:50:53' AND e.date<='2025-04-22 14:50:53' AND e.DeviceLoginName='354836080167561' 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>='2025-04-22 01:50:53' AND g.time<='2025-04-22 11:50:53' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:346
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 4:7:36' AND e.date<='2025-04-22 16:7:36' AND e.DeviceLoginName='354836080167561' 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>='2025-04-22 01:07:36' AND g.time<='2025-04-22 13:07:36' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:588