Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 7:10:22' AND e.date<='2025-04-11 22:10:22' 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-11 04:10:22' AND g.time<='2025-04-11 19:10:22' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:19 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-13 7:10:41' AND e.date<='2025-04-14 7:10:41' 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-13 04:10:41' AND g.time<='2025-04-14 04:10:41' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:208 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-13 7:29:17' AND e.date<='2025-04-14 7:29:17' 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-13 04:29:17' AND g.time<='2025-04-14 04:29:17' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:208 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-14 0:45:20' AND e.date<='2025-04-14 7:45:20' 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-13 21:45:20' AND g.time<='2025-04-14 04:45:20' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:331 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-14 0:54:10' AND e.date<='2025-04-14 8:54:10' 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-13 21:54:10' AND g.time<='2025-04-14 05:54:10' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:331 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 0:6:23' AND e.date<='2025-04-11 23:6:23' AND e.DeviceLoginName='2833' 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-10 21:06:23' AND g.time<='2025-04-11 20:06:23' AND g.DeviceLoginName='2833' GROUP BY g.time, g.Distance; CountAzimuth:4695 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-13 10:10:12' AND e.date<='2025-04-14 10:10:12' 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-13 07:10:12' AND g.time<='2025-04-14 07:10:12' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:538 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-13 10:13:46' AND e.date<='2025-04-14 10:13:46' 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-13 07:13:46' AND g.time<='2025-04-14 07:13:46' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:538 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-05 0:25:59' AND e.date<='2025-04-13 23:25:59' AND e.DeviceLoginName='4884' 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-04 21:25:59' AND g.time<='2025-04-13 20:25:59' AND g.DeviceLoginName='4884' GROUP BY g.time, g.Distance; CountAzimuth:8796 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:25:59' AND e.date<='2025-04-06 23:25:59' AND e.DeviceLoginName='4884' 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-03-28 21:25:59' AND g.time<='2025-04-06 20:25:59' AND g.DeviceLoginName='4884' GROUP BY g.time, g.Distance; CountAzimuth:9373 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-13 10:41:49' AND e.date<='2025-04-14 10:41:49' AND e.DeviceLoginName='3092' 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 07:41:49' AND g.time<='2025-04-14 07:41:49' AND g.DeviceLoginName='3092' GROUP BY g.time, g.Distance; CountAzimuth:1265 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-08 0:41:49' AND e.date<='2025-04-08 23:41:49' AND e.DeviceLoginName='3092' 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-07 21:41:49' AND g.time<='2025-04-08 20:41:49' AND g.DeviceLoginName='3092' GROUP BY g.time, g.Distance; CountAzimuth:4115 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-09 0:41:49' AND e.date<='2025-04-09 23:41:49' AND e.DeviceLoginName='3092' 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-08 21:41:49' AND g.time<='2025-04-09 20:41:49' AND g.DeviceLoginName='3092' GROUP BY g.time, g.Distance; CountAzimuth:3056 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-13 11:44:34' AND e.date<='2025-04-14 11:44:34' 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-13 08:44:34' AND g.time<='2025-04-14 08:44:34' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1257 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-13 11:56:30' AND e.date<='2025-04-14 11:56:30' 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-13 08:56:30' AND g.time<='2025-04-14 08:56:30' AND g.DeviceLoginName='352353084234167' GROUP BY g.time, g.Distance; CountAzimuth:928 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-07 0:56:30' AND e.date<='2025-04-07 23:56:30' 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-06 21:56:30' AND g.time<='2025-04-07 20:56:30' AND g.DeviceLoginName='352353084234167' GROUP BY g.time, g.Distance; CountAzimuth:1977 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-08 0:56:30' AND e.date<='2025-04-08 23:56:30' 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-07 21:56:30' AND g.time<='2025-04-08 20:56:30' AND g.DeviceLoginName='352353084234167' GROUP BY g.time, g.Distance; CountAzimuth:877 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-09 0:56:30' AND e.date<='2025-04-09 23:56:30' 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-08 21:56:30' AND g.time<='2025-04-09 20:56:30' AND g.DeviceLoginName='352353084234167' GROUP BY g.time, g.Distance; CountAzimuth:1252 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 0:56:30' AND e.date<='2025-04-10 23:56:30' 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-09 21:56:30' AND g.time<='2025-04-10 20:56:30' AND g.DeviceLoginName='352353084234167' GROUP BY g.time, g.Distance; CountAzimuth:1935 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-14 1:59:1' AND e.date<='2025-04-14 11:59: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-13 22:59:01' AND g.time<='2025-04-14 08:59:01' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1052 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-07 0:31:27' AND e.date<='2025-04-13 23:31:27' AND e.DeviceLoginName='2833' 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-06 21:31:27' AND g.time<='2025-04-13 20:31:27' AND g.DeviceLoginName='2833' GROUP BY g.time, g.Distance; CountAzimuth:16665 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 23:0:0' AND e.date<='2025-04-12 5:0:0' AND e.DeviceLoginName='9010' 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-11 20:00:00' AND g.time<='2025-04-12 02:00:00' AND g.DeviceLoginName='9010' GROUP BY g.time, g.Distance; CountAzimuth:380 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 23:0:0' AND e.date<='2025-04-12 5:0:0' AND e.DeviceLoginName='3158' 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-11 20:00:00' AND g.time<='2025-04-12 02:00:00' AND g.DeviceLoginName='3158' GROUP BY g.time, g.Distance; CountAzimuth:162 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 23:0:0' AND e.date<='2025-04-12 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-11 20:00:00' AND g.time<='2025-04-12 02:00:00' AND g.DeviceLoginName='2703' GROUP BY g.time, g.Distance; CountAzimuth:112 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 23:0:0' AND e.date<='2025-04-12 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-11 20:00:00' AND g.time<='2025-04-12 02:00:00' AND g.DeviceLoginName='3263' GROUP BY g.time, g.Distance; CountAzimuth:24 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 23:0:0' AND e.date<='2025-04-12 5:0:0' AND e.DeviceLoginName='353173060487970' 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-11 20:00:00' AND g.time<='2025-04-12 02:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY g.time, g.Distance; CountAzimuth:2 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 23:0:0' AND e.date<='2025-04-12 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-11 20:00:00' AND g.time<='2025-04-12 02:00:00' AND g.DeviceLoginName='862531041041535' GROUP BY g.time, g.Distance; CountAzimuth:10 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 23:0:0' AND e.date<='2025-04-12 5:0:0' AND e.DeviceLoginName='2947' 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-11 20:00:00' AND g.time<='2025-04-12 02:00:00' AND g.DeviceLoginName='2947' GROUP BY g.time, g.Distance; CountAzimuth:127 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 23:0:0' AND e.date<='2025-04-12 5:0:0' AND e.DeviceLoginName='4862' 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-11 20:00:00' AND g.time<='2025-04-12 02:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:200 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 23:0:0' AND e.date<='2025-04-12 5:0:0' AND e.DeviceLoginName='2743' 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-11 20:00:00' AND g.time<='2025-04-12 02:00:00' AND g.DeviceLoginName='2743' GROUP BY g.time, g.Distance; CountAzimuth:6 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 23:0:0' AND e.date<='2025-04-12 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-11 20:00:00' AND g.time<='2025-04-12 02:00:00' AND g.DeviceLoginName='2676' GROUP BY g.time, g.Distance; CountAzimuth:39 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 23:0:0' AND e.date<='2025-04-12 5:0:0' AND e.DeviceLoginName='2499' 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-11 20:00:00' AND g.time<='2025-04-12 02:00:00' AND g.DeviceLoginName='2499' GROUP BY g.time, g.Distance; CountAzimuth:136 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 23:0:0' AND e.date<='2025-04-12 5:0:0' AND e.DeviceLoginName='2584' 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-11 20:00:00' AND g.time<='2025-04-12 02:00:00' AND g.DeviceLoginName='2584' GROUP BY g.time, g.Distance; CountAzimuth:117 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 23:0:0' AND e.date<='2025-04-12 5:0:0' AND e.DeviceLoginName='3205' 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-11 20:00:00' AND g.time<='2025-04-12 02:00:00' AND g.DeviceLoginName='3205' GROUP BY g.time, g.Distance; CountAzimuth:118 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 5:0:0' AND e.DeviceLoginName='356078116266236' 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 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='356078116266236' GROUP BY g.time, g.Distance; CountAzimuth:13 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 5:0:0' AND e.DeviceLoginName='3021' 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 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='3021' GROUP BY g.time, g.Distance; CountAzimuth:368 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 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-12 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:187 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 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-12 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='2790' GROUP BY g.time, g.Distance; CountAzimuth:73 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 5:0:0' AND e.DeviceLoginName='9014' 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 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='9014' GROUP BY g.time, g.Distance; CountAzimuth:26 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 5:0:0' AND e.DeviceLoginName='5076' 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 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='5076' GROUP BY g.time, g.Distance; CountAzimuth:33 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 5:0:0' AND e.DeviceLoginName='2454' 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 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='2454' GROUP BY g.time, g.Distance; CountAzimuth:13 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 5:0:0' AND e.DeviceLoginName='4861' 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 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='4861' GROUP BY g.time, g.Distance; CountAzimuth:19 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 5:0:0' AND e.DeviceLoginName='3013' 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 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='3013' GROUP BY g.time, g.Distance; CountAzimuth:88 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 5:0:0' AND e.DeviceLoginName='2470' 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 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='2470' GROUP BY g.time, g.Distance; CountAzimuth:73 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 5:0:0' AND e.DeviceLoginName='2662' 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 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='2662' GROUP BY g.time, g.Distance; CountAzimuth:36 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 5:0:0' AND e.DeviceLoginName='2866' 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 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='2866' GROUP BY g.time, g.Distance; CountAzimuth:33 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 5:0:0' AND e.DeviceLoginName='8983' 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 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='8983' GROUP BY g.time, g.Distance; CountAzimuth:184 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 5:0:0' AND e.DeviceLoginName='2499' 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 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='2499' GROUP BY g.time, g.Distance; CountAzimuth:22 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 23:0:0' AND e.date<='2025-04-13 5:0:0' AND e.DeviceLoginName='2584' 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 20:00:00' AND g.time<='2025-04-13 02:00:00' AND g.DeviceLoginName='2584' GROUP BY g.time, g.Distance; CountAzimuth:25 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-13 23:0:0' AND e.date<='2025-04-14 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-13 20:00:00' AND g.time<='2025-04-14 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:188 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-13 23:0:0' AND e.date<='2025-04-14 5:0:0' AND e.DeviceLoginName='2768' 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 20:00:00' AND g.time<='2025-04-14 02:00:00' AND g.DeviceLoginName='2768' GROUP BY g.time, g.Distance; CountAzimuth:14 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-13 23:0:0' AND e.date<='2025-04-14 5:0:0' AND e.DeviceLoginName='3187' 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 20:00:00' AND g.time<='2025-04-14 02:00:00' AND g.DeviceLoginName='3187' GROUP BY g.time, g.Distance; CountAzimuth:7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-09 0:50:43' AND e.date<='2025-04-09 23:50:43' AND e.DeviceLoginName='358021081839700' 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-08 21:50:43' AND g.time<='2025-04-09 20:50:43' AND g.DeviceLoginName='358021081839700' GROUP BY g.time, g.Distance; CountAzimuth:1429