Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 0:1:8' AND e.date<='2024-02-05 8:1:8' AND e.DeviceLoginName='358021081803706' 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-02-04 22:01:08' AND g.time<='2024-02-05 06:01:08' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:146 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-03 8:1:36' AND e.date<='2024-02-05 8:1:36' 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>='2024-02-03 06:01:36' AND g.time<='2024-02-05 06:01:36' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:372 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 6:36:20' AND e.date<='2024-02-05 8:36:20' AND e.DeviceLoginName='2473' 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-02-05 04:36:20' AND g.time<='2024-02-05 06:36:20' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 6:36:35' AND e.date<='2024-02-05 8:36:35' AND e.DeviceLoginName='3056' 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-02-05 04:36:35' AND g.time<='2024-02-05 06:36:35' AND g.DeviceLoginName='3056' GROUP BY g.time, g.Distance; CountAzimuth:233 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-03 0:34:3' AND e.date<='2024-02-04 23:34:3' AND e.DeviceLoginName='352353085645312' 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-02-02 22:34:03' AND g.time<='2024-02-04 21:34:03' AND g.DeviceLoginName='352353085645312' GROUP BY g.time, g.Distance; CountAzimuth:943 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 0:27:34' AND e.date<='2024-02-05 11:27:34' AND e.DeviceLoginName='358021081803706' 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-02-04 22:27:34' AND g.time<='2024-02-05 09:27:34' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:455 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 7:28:37' AND e.date<='2024-02-05 11:28:37' AND e.DeviceLoginName='2473' 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-02-05 05:28:37' AND g.time<='2024-02-05 09:28:37' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:126 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 4:33:4' AND e.date<='2024-02-05 12:33:4' AND e.DeviceLoginName='358021081803706' 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-02-05 02:33:04' AND g.time<='2024-02-05 10:33:04' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:733 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-29 13:3:40' AND e.date<='2024-02-02 13:3:40' AND e.DeviceLoginName='4844' 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-01-29 11:03:40' AND g.time<='2024-02-02 11:03:40' AND g.DeviceLoginName='4844' GROUP BY g.time, g.Distance; CountAzimuth:2161 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 7:11:0' AND e.date<='2024-02-05 13:11:0' AND e.DeviceLoginName='2473' 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-02-05 05:11:00' AND g.time<='2024-02-05 11:11:00' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:205 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 6:11:19' AND e.date<='2024-02-05 13:11:19' 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>='2024-02-05 04:11:19' AND g.time<='2024-02-05 11:11:19' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:551 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 1:11:48' AND e.date<='2024-02-05 13:11:48' AND e.DeviceLoginName='358021081803706' 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-02-04 23:11:48' AND g.time<='2024-02-05 11:11:48' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:733 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-06 5:21:22' AND e.date<='2024-02-05 13:21:22' 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>='2024-02-06 03:21:22' AND g.time<='2024-02-05 11:21:22' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 4:21:42' AND e.date<='2024-02-05 13:21:42' 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>='2024-02-05 02:21:42' AND g.time<='2024-02-05 11:21:42' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:613 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-02 23:0:0' AND e.date<='2024-02-03 5:0:0' AND e.DeviceLoginName='4964' 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-02-02 21:00:00' AND g.time<='2024-02-03 03:00:00' AND g.DeviceLoginName='4964' GROUP BY g.time, g.Distance; CountAzimuth:702 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-02 23:0:0' AND e.date<='2024-02-03 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-02-02 21:00:00' AND g.time<='2024-02-03 03:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:214 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-02 23:0:0' AND e.date<='2024-02-03 5:0:0' AND e.DeviceLoginName='352353084234167' 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-02-02 21:00:00' AND g.time<='2024-02-03 03:00:00' AND g.DeviceLoginName='352353084234167' GROUP BY g.time, g.Distance; CountAzimuth:15 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-02 23:0:0' AND e.date<='2024-02-03 5:0:0' AND e.DeviceLoginName='5082' 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-02-02 21:00:00' AND g.time<='2024-02-03 03:00:00' AND g.DeviceLoginName='5082' GROUP BY g.time, g.Distance; CountAzimuth:86 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-02 23:0:0' AND e.date<='2024-02-03 5:0:0' AND e.DeviceLoginName='4869' 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-02-02 21:00:00' AND g.time<='2024-02-03 03:00:00' AND g.DeviceLoginName='4869' GROUP BY g.time, g.Distance; CountAzimuth:221 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-02 23:0:0' AND e.date<='2024-02-03 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-02-02 21:00:00' AND g.time<='2024-02-03 03:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:276 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-02 23:0:0' AND e.date<='2024-02-03 5:0:0' AND e.DeviceLoginName='3179' 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-02-02 21:00:00' AND g.time<='2024-02-03 03:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:144 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-02 23:0:0' AND e.date<='2024-02-03 5:0:0' AND e.DeviceLoginName='2997' 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-02-02 21:00:00' AND g.time<='2024-02-03 03:00:00' AND g.DeviceLoginName='2997' GROUP BY g.time, g.Distance; CountAzimuth:69 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-03 23:0:0' AND e.date<='2024-02-04 5:0:0' AND e.DeviceLoginName='352353084234167' 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-02-03 21:00:00' AND g.time<='2024-02-04 03:00:00' AND g.DeviceLoginName='352353084234167' GROUP BY g.time, g.Distance; CountAzimuth:14 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-03 23:0:0' AND e.date<='2024-02-04 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-02-03 21:00:00' AND g.time<='2024-02-04 03:00:00' AND g.DeviceLoginName='353173060537865' GROUP BY g.time, g.Distance; CountAzimuth:38 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-03 23:0:0' AND e.date<='2024-02-04 5:0:0' 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>='2024-02-03 21:00:00' AND g.time<='2024-02-04 03:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:185 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-03 23:0:0' AND e.date<='2024-02-04 5:0:0' AND e.DeviceLoginName='3030' 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-02-03 21:00:00' AND g.time<='2024-02-04 03:00:00' AND g.DeviceLoginName='3030' GROUP BY g.time, g.Distance; CountAzimuth:93 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-03 23:0:0' AND e.date<='2024-02-04 5:0:0' AND e.DeviceLoginName='3118' 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-02-03 21:00:00' AND g.time<='2024-02-04 03:00:00' AND g.DeviceLoginName='3118' GROUP BY g.time, g.Distance; CountAzimuth:80 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-04 23:0:0' AND e.date<='2024-02-05 5:0:0' AND e.DeviceLoginName='2652' 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-02-04 21:00:00' AND g.time<='2024-02-05 03:00:00' AND g.DeviceLoginName='2652' GROUP BY g.time, g.Distance; CountAzimuth:55 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-04 23:0:0' AND e.date<='2024-02-05 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-02-04 21:00:00' AND g.time<='2024-02-05 03:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:223 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-04 23:0:0' AND e.date<='2024-02-05 5:0:0' AND e.DeviceLoginName='2883' 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-02-04 21:00:00' AND g.time<='2024-02-05 03:00:00' AND g.DeviceLoginName='2883' GROUP BY g.time, g.Distance; CountAzimuth:220 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-04 23:0:0' AND e.date<='2024-02-05 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-02-04 21:00:00' AND g.time<='2024-02-05 03:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY g.time, g.Distance; CountAzimuth:68 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-04 23:0:0' AND e.date<='2024-02-05 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-02-04 21:00:00' AND g.time<='2024-02-05 03:00:00' AND g.DeviceLoginName='2947' GROUP BY g.time, g.Distance; CountAzimuth:83 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-04 23:0:0' AND e.date<='2024-02-05 5:0:0' AND e.DeviceLoginName='3124' 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-02-04 21:00:00' AND g.time<='2024-02-05 03:00:00' AND g.DeviceLoginName='3124' GROUP BY g.time, g.Distance; CountAzimuth:111 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-04 23:0:0' AND e.date<='2024-02-05 5:0:0' AND e.DeviceLoginName='3118' 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-02-04 21:00:00' AND g.time<='2024-02-05 03:00:00' AND g.DeviceLoginName='3118' GROUP BY g.time, g.Distance; CountAzimuth:86 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 8:6:34' AND e.date<='2024-02-05 14:6:34' 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>='2024-02-05 06:06:34' AND g.time<='2024-02-05 12:06:34' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:261 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-31 19:0:0' AND e.date<='2024-01-31 20:0:0' AND e.DeviceLoginName='862531041078313' 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-01-31 17:00:00' AND g.time<='2024-01-31 18:00:00' AND g.DeviceLoginName='862531041078313' GROUP BY g.time, g.Distance; CountAzimuth:22 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-31 9:0:0' AND e.date<='2024-01-31 10:0:0' AND e.DeviceLoginName='3154' 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-01-31 07:00:00' AND g.time<='2024-01-31 08:00:00' AND g.DeviceLoginName='3154' GROUP BY g.time, g.Distance; CountAzimuth:640 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-01 8:0:0' AND e.date<='2024-02-01 9:0:0' AND e.DeviceLoginName='352353086157176' 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-02-01 06:00:00' AND g.time<='2024-02-01 07:00:00' AND g.DeviceLoginName='352353086157176' GROUP BY g.time, g.Distance; CountAzimuth:138 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-02 18:0:0' AND e.date<='2024-02-02 19:0:0' AND e.DeviceLoginName='2833' 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-02-02 16:00:00' AND g.time<='2024-02-02 17:00:00' AND g.DeviceLoginName='2833' GROUP BY g.time, g.Distance; CountAzimuth:562 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 1:12:47' AND e.date<='2024-02-05 14:12:47' 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>='2024-02-04 23:12:47' AND g.time<='2024-02-05 12:12:47' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:800 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-30 16:0:0' AND e.date<='2024-01-30 17:0:0' AND e.DeviceLoginName='862531041080715' 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-01-30 14:00:00' AND g.time<='2024-01-30 15:00:00' AND g.DeviceLoginName='862531041080715' GROUP BY g.time, g.Distance; CountAzimuth:166 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-30 17:0:0' AND e.date<='2024-01-30 18:0:0' AND e.DeviceLoginName='2505' 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-01-30 15:00:00' AND g.time<='2024-01-30 16:00:00' AND g.DeviceLoginName='2505' GROUP BY g.time, g.Distance; CountAzimuth:177 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-29 17:0:0' AND e.date<='2024-01-29 18:0:0' AND e.DeviceLoginName='2783' 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-01-29 15:00:00' AND g.time<='2024-01-29 16:00:00' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:425 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-29 10:0:0' AND e.date<='2024-01-29 11:0:0' AND e.DeviceLoginName='2783' 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-01-29 08:00:00' AND g.time<='2024-01-29 09:00:00' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:564 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-29 11:0:0' AND e.date<='2024-01-29 12:0:0' AND e.DeviceLoginName='2783' 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-01-29 09:00:00' AND g.time<='2024-01-29 10:00:00' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:673 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-02 13:0:0' AND e.date<='2024-02-02 14:0:0' AND e.DeviceLoginName='355234055170423' 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-02-02 11:00:00' AND g.time<='2024-02-02 12:00:00' AND g.DeviceLoginName='355234055170423' GROUP BY g.time, g.Distance; CountAzimuth:145 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-01 9:0:0' AND e.date<='2024-02-01 10:0:0' AND e.DeviceLoginName='355234055170423' 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-02-01 07:00:00' AND g.time<='2024-02-01 08:00:00' AND g.DeviceLoginName='355234055170423' GROUP BY g.time, g.Distance; CountAzimuth:31 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-03 16:0:0' AND e.date<='2024-02-03 17:0:0' AND e.DeviceLoginName='358021081839668' 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-02-03 14:00:00' AND g.time<='2024-02-03 15:00:00' AND g.DeviceLoginName='358021081839668' GROUP BY g.time, g.Distance; CountAzimuth:165 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-31 14:0:0' AND e.date<='2024-01-31 15:0:0' AND e.DeviceLoginName='354836080357964' 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-01-31 12:00:00' AND g.time<='2024-01-31 13:00:00' AND g.DeviceLoginName='354836080357964' GROUP BY g.time, g.Distance; CountAzimuth:85 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 4:28:49' AND e.date<='2024-02-05 14:28:49' AND e.DeviceLoginName='358021081803706' 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-02-05 02:28:49' AND g.time<='2024-02-05 12:28:49' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:938 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 7:29:21' AND e.date<='2024-02-05 14:29:21' 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>='2024-02-05 05:29:21' AND g.time<='2024-02-05 12:29:21' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:308 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 9:30:13' AND e.date<='2024-02-05 14:30:13' AND e.DeviceLoginName='2473' 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-02-05 07:30:13' AND g.time<='2024-02-05 12:30:13' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:80 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 0:30:28' AND e.date<='2024-02-05 14:30:28' AND e.DeviceLoginName='2473' 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-02-04 22:30:28' AND g.time<='2024-02-05 12:30:28' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:206 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-30 17:0:0' AND e.date<='2024-01-30 18:0:0' AND e.DeviceLoginName='2505' 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-01-30 15:00:00' AND g.time<='2024-01-30 16:00:00' AND g.DeviceLoginName='2505' GROUP BY g.time, g.Distance; CountAzimuth:177 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-04 14:39:57' AND e.date<='2024-02-05 14:39:57' AND e.DeviceLoginName='4844' 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-02-04 12:39:57' AND g.time<='2024-02-05 12:39:57' AND g.DeviceLoginName='4844' GROUP BY g.time, g.Distance; CountAzimuth:5 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-29 0:44:3' AND e.date<='2024-01-29 23:44:3' AND e.DeviceLoginName='3070' 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-01-28 22:44:03' AND g.time<='2024-01-29 21:44:03' AND g.DeviceLoginName='3070' GROUP BY g.time, g.Distance; CountAzimuth:204 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-30 0:44:3' AND e.date<='2024-01-30 23:44:3' AND e.DeviceLoginName='3070' 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-01-29 22:44:03' AND g.time<='2024-01-30 21:44:03' AND g.DeviceLoginName='3070' GROUP BY g.time, g.Distance; CountAzimuth:2983 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-31 0:44:3' AND e.date<='2024-01-31 23:44:3' AND e.DeviceLoginName='3070' 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-01-30 22:44:03' AND g.time<='2024-01-31 21:44:03' AND g.DeviceLoginName='3070' GROUP BY g.time, g.Distance; CountAzimuth:1506 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-01 0:44:3' AND e.date<='2024-02-01 23:44:3' AND e.DeviceLoginName='3070' 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-01-31 22:44:03' AND g.time<='2024-02-01 21:44:03' AND g.DeviceLoginName='3070' GROUP BY g.time, g.Distance; CountAzimuth:1562 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-02 0:44:3' AND e.date<='2024-02-02 23:44:3' AND e.DeviceLoginName='3070' 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-02-01 22:44:03' AND g.time<='2024-02-02 21:44:03' AND g.DeviceLoginName='3070' GROUP BY g.time, g.Distance; CountAzimuth:2570 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-20 7:48:41' AND e.date<='2023-12-24 23:48:41' AND e.DeviceLoginName='2494' 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>='2023-11-20 05:48:41' AND g.time<='2023-12-24 21:48:41' AND g.DeviceLoginName='2494' GROUP BY g.time, g.Distance; CountAzimuth:19898 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-02 0:44:3' AND e.date<='2024-02-02 23:44:3' AND e.DeviceLoginName='2843' 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-02-01 22:44:03' AND g.time<='2024-02-02 21:44:03' AND g.DeviceLoginName='2843' GROUP BY g.time, g.Distance; CountAzimuth:85 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-29 0:44:3' AND e.date<='2024-01-29 23:44:3' AND e.DeviceLoginName='2843' 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-01-28 22:44:03' AND g.time<='2024-01-29 21:44:03' AND g.DeviceLoginName='2843' GROUP BY g.time, g.Distance; CountAzimuth:61 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-25 7:48:41' AND e.date<='2024-01-21 23:48:41' AND e.DeviceLoginName='2494' 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>='2023-12-25 05:48:41' AND g.time<='2024-01-21 21:48:41' AND g.DeviceLoginName='2494' GROUP BY g.time, g.Distance; CountAzimuth:13933 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-29 0:54:41' AND e.date<='2024-01-29 23:54:41' AND e.DeviceLoginName='2837' 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-01-28 22:54:41' AND g.time<='2024-01-29 21:54:41' AND g.DeviceLoginName='2837' GROUP BY g.time, g.Distance; CountAzimuth:3803 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-30 0:54:41' AND e.date<='2024-01-30 23:54:41' AND e.DeviceLoginName='2837' 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-01-29 22:54:41' AND g.time<='2024-01-30 21:54:41' AND g.DeviceLoginName='2837' GROUP BY g.time, g.Distance; CountAzimuth:3738 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-31 0:54:41' AND e.date<='2024-01-31 23:54:41' AND e.DeviceLoginName='2837' 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-01-30 22:54:41' AND g.time<='2024-01-31 21:54:41' AND g.DeviceLoginName='2837' GROUP BY g.time, g.Distance; CountAzimuth:2210 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-01 0:54:41' AND e.date<='2024-02-01 23:54:41' AND e.DeviceLoginName='2837' 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-01-31 22:54:41' AND g.time<='2024-02-01 21:54:41' AND g.DeviceLoginName='2837' GROUP BY g.time, g.Distance; CountAzimuth:2837 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-02 0:54:41' AND e.date<='2024-02-02 23:54:41' AND e.DeviceLoginName='2837' 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-02-01 22:54:41' AND g.time<='2024-02-02 21:54:41' AND g.DeviceLoginName='2837' GROUP BY g.time, g.Distance; CountAzimuth:1613 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 0:54:41' AND e.date<='2024-02-05 23:54:41' AND e.DeviceLoginName='2837' 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-02-04 22:54:41' AND g.time<='2024-02-05 21:54:41' AND g.DeviceLoginName='2837' GROUP BY g.time, g.Distance; CountAzimuth:609 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-04 15:21:6' AND e.date<='2024-02-05 15:21:6' AND e.DeviceLoginName='4844' 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-02-04 13:21:06' AND g.time<='2024-02-05 13:21:06' AND g.DeviceLoginName='4844' GROUP BY g.time, g.Distance; CountAzimuth:218 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-06 15:26:57' AND e.date<='2024-02-06 15:26:57' AND e.DeviceLoginName='2554' 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-01-06 13:26:57' AND g.time<='2024-02-06 13:26:57' AND g.DeviceLoginName='2554' GROUP BY g.time, g.Distance; CountAzimuth:11776 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-27 0:26:57' AND e.date<='2024-01-27 23:26:57' AND e.DeviceLoginName='2554' 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-01-26 22:26:57' AND g.time<='2024-01-27 21:26:57' AND g.DeviceLoginName='2554' GROUP BY g.time, g.Distance; CountAzimuth:29 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-29 0:34:11' AND e.date<='2024-01-29 23:34:11' AND e.DeviceLoginName='3070' 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-01-28 22:34:11' AND g.time<='2024-01-29 21:34:11' AND g.DeviceLoginName='3070' GROUP BY g.time, g.Distance; CountAzimuth:204 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-29 0:34:11' AND e.date<='2024-01-30 23:34:11' AND e.DeviceLoginName='3070' 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-01-28 22:34:11' AND g.time<='2024-01-30 21:34:11' AND g.DeviceLoginName='3070' GROUP BY g.time, g.Distance; CountAzimuth:3187 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-26 11:58:5' AND e.date<='2024-02-05 15:58:5' AND e.DeviceLoginName='3070' 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-01-26 09:58:05' AND g.time<='2024-02-05 13:58:05' AND g.DeviceLoginName='3070' GROUP BY g.time, g.Distance; CountAzimuth:12414 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 17:1:20' AND e.date<='2024-02-05 19:1:20' 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>='2024-02-05 15:01:20' AND g.time<='2024-02-05 17:01:20' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:40 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 13:2:33' AND e.date<='2024-02-05 19:2: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>='2024-02-05 11:02:33' AND g.time<='2024-02-05 17:02:33' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:464 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 12:4:11' AND e.date<='2024-02-05 19:4:11' AND e.DeviceLoginName='358021081803706' 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-02-05 10:04:11' AND g.time<='2024-02-05 17:04:11' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:718 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 2:4:43' AND e.date<='2024-02-05 19:4: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>='2024-02-05 00:04:43' AND g.time<='2024-02-05 17:04:43' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:121 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-05 10:6:14' AND e.date<='2024-02-05 19:6: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>='2024-02-05 08:06:14' AND g.time<='2024-02-05 17:06:14' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:507