Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 7:44:56' AND e.date<='2024-03-15 23:44:56' 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-03-15 05:44:56' AND g.time<='2024-03-15 21:44:56' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:399 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 7:45:38' AND e.date<='2024-03-15 23:45:38' 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-03-15 05:45:38' AND g.time<='2024-03-15 21:45:38' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:1325 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 7:46:30' AND e.date<='2024-03-15 23:46:30' 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-03-15 05:46:30' AND g.time<='2024-03-15 21:46:30' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:470 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 7:47:21' AND e.date<='2024-03-15 23:47:21' AND e.DeviceLoginName='352353086131601' 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-03-15 05:47:21' AND g.time<='2024-03-15 21:47:21' AND g.DeviceLoginName='352353086131601' GROUP BY g.time, g.Distance; CountAzimuth:578 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 7:48:2' AND e.date<='2024-03-18 7:48:2' 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-03-15 05:48:02' AND g.time<='2024-03-18 05:48:02' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:1189 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 7:48:56' AND e.date<='2024-03-18 7:48:56' 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-03-17 05:48:56' AND g.time<='2024-03-18 05:48:56' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:432 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 6:2:25' AND e.date<='2024-03-18 8:2:25' 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-03-18 04:02:25' AND g.time<='2024-03-18 06:02:25' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:162 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 7:2:42' AND e.date<='2024-03-18 8:2:42' 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-03-18 05:02:42' AND g.time<='2024-03-18 06:02:42' AND g.DeviceLoginName='3056' GROUP BY g.time, g.Distance; CountAzimuth:70 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 8:2:57' AND e.date<='2024-03-17 8:2:57' 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-03-15 06:02:57' AND g.time<='2024-03-17 06:02:57' AND g.DeviceLoginName='3056' GROUP BY g.time, g.Distance; CountAzimuth:1211 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 7:45:45' AND e.date<='2024-03-18 11:45:45' AND e.DeviceLoginName='2510' 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-03-17 05:45:45' AND g.time<='2024-03-18 09:45:45' AND g.DeviceLoginName='2510' GROUP BY g.time, g.Distance; CountAzimuth:1348 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 0:4:37' AND e.date<='2024-03-18 12:4:37' 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-03-17 22:04:37' AND g.time<='2024-03-18 10:04:37' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:449 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 7:20:46' AND e.date<='2024-03-18 13:20:46' 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-03-18 05:20:46' AND g.time<='2024-03-18 11:20:46' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:226 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 0:21:7' AND e.date<='2024-03-18 13:21:7' 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-03-17 22:21:07' AND g.time<='2024-03-18 11:21:07' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:408 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 3:21:51' AND e.date<='2024-03-18 13:21:51' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-18 01:21:51' AND g.time<='2024-03-18 11:21:51' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:525 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='9010' GROUP BY g.time, g.Distance; CountAzimuth:134 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 5:0:0' AND e.DeviceLoginName='5131' 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='5131' GROUP BY g.time, g.Distance; CountAzimuth:252 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='4964' GROUP BY g.time, g.Distance; CountAzimuth:278 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:216 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 5:0:0' AND e.DeviceLoginName='2508' 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='2508' GROUP BY g.time, g.Distance; CountAzimuth:151 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 5:0:0' AND e.DeviceLoginName='353173060512918' 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='353173060512918' GROUP BY g.time, g.Distance; CountAzimuth:100 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 5:0:0' AND e.DeviceLoginName='862531041050148' 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:111 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 5:0:0' AND e.DeviceLoginName='3063' 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='3063' GROUP BY g.time, g.Distance; CountAzimuth:124 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='3124' GROUP BY g.time, g.Distance; CountAzimuth:90 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='2662' GROUP BY g.time, g.Distance; CountAzimuth:156 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 5:0:0' AND e.DeviceLoginName='2536' 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='2536' GROUP BY g.time, g.Distance; CountAzimuth:120 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 5:0:0' AND e.DeviceLoginName='4868' 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='4868' GROUP BY g.time, g.Distance; CountAzimuth:156 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 5:0:0' AND e.DeviceLoginName='2585' 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='2585' GROUP BY g.time, g.Distance; CountAzimuth:33 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 5:0:0' AND e.DeviceLoginName='353173060497698' 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY g.time, g.Distance; CountAzimuth:71 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 5:0:0' AND e.DeviceLoginName='2630' 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:95 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-15 23:0:0' AND e.date<='2024-03-16 5:0:0' AND e.DeviceLoginName='2908' 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-03-15 21:00:00' AND g.time<='2024-03-16 03:00:00' AND g.DeviceLoginName='2908' GROUP BY g.time, g.Distance; CountAzimuth:194 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 5:0:0' AND e.DeviceLoginName='353173060485131' 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-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:54 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 5:0:0' AND e.DeviceLoginName='3185' 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-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='3185' GROUP BY g.time, g.Distance; CountAzimuth:74 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 5: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-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='3154' GROUP BY g.time, g.Distance; CountAzimuth:18 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 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-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='4964' GROUP BY g.time, g.Distance; CountAzimuth:220 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 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-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:343 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 5:0:0' AND e.DeviceLoginName='864866053465646' 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-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='864866053465646' GROUP BY g.time, g.Distance; CountAzimuth:46 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 5:0:0' AND e.DeviceLoginName='2966' 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-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='2966' GROUP BY g.time, g.Distance; CountAzimuth:55 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 5:0:0' AND e.DeviceLoginName='4966' 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-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:29 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 5:0:0' AND e.DeviceLoginName='5080' 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-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='5080' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 5:0:0' AND e.DeviceLoginName='862531041050148' 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-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:83 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 5:0:0' AND e.DeviceLoginName='8993' 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-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='8993' GROUP BY g.time, g.Distance; CountAzimuth:50 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='2662' GROUP BY g.time, g.Distance; CountAzimuth:153 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 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-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:142 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 5:0:0' AND e.DeviceLoginName='353173060497698' 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-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY g.time, g.Distance; CountAzimuth:29 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 23:0:0' AND e.date<='2024-03-17 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-16 21:00:00' AND g.time<='2024-03-17 03:00:00' AND g.DeviceLoginName='3197' GROUP BY g.time, g.Distance; CountAzimuth:25 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 23:0:0' AND e.date<='2024-03-18 5:0:0' AND e.DeviceLoginName='353173060485131' 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-03-17 21:00:00' AND g.time<='2024-03-18 03:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:53 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 23:0:0' AND e.date<='2024-03-18 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-03-17 21:00:00' AND g.time<='2024-03-18 03:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:230 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 23:0:0' AND e.date<='2024-03-18 5:0:0' AND e.DeviceLoginName='864866053467873' 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-03-17 21:00:00' AND g.time<='2024-03-18 03:00:00' AND g.DeviceLoginName='864866053467873' GROUP BY g.time, g.Distance; CountAzimuth:40 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 23:0:0' AND e.date<='2024-03-18 5:0:0' AND e.DeviceLoginName='353173060512918' 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-03-17 21:00:00' AND g.time<='2024-03-18 03:00:00' AND g.DeviceLoginName='353173060512918' GROUP BY g.time, g.Distance; CountAzimuth:87 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 23:0:0' AND e.date<='2024-03-18 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-03-17 21:00:00' AND g.time<='2024-03-18 03:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY g.time, g.Distance; CountAzimuth:124 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 23:0:0' AND e.date<='2024-03-18 5:0:0' AND e.DeviceLoginName='356078111473472' 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-03-17 21:00:00' AND g.time<='2024-03-18 03:00:00' AND g.DeviceLoginName='356078111473472' GROUP BY g.time, g.Distance; CountAzimuth:417 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 23:0:0' AND e.date<='2024-03-18 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-17 21:00:00' AND g.time<='2024-03-18 03:00:00' AND g.DeviceLoginName='2662' GROUP BY g.time, g.Distance; CountAzimuth:184 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 23:0:0' AND e.date<='2024-03-18 5:0:0' AND e.DeviceLoginName='2871' 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-03-17 21:00:00' AND g.time<='2024-03-18 03:00:00' AND g.DeviceLoginName='2871' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 23:0:0' AND e.date<='2024-03-18 5:0:0' AND e.DeviceLoginName='353173060497698' 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-03-17 21:00:00' AND g.time<='2024-03-18 03:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY g.time, g.Distance; CountAzimuth:24 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 23:0:0' AND e.date<='2024-03-18 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-17 21:00:00' AND g.time<='2024-03-18 03:00:00' AND g.DeviceLoginName='3187' GROUP BY g.time, g.Distance; CountAzimuth:371 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-16 5:15:9' AND e.date<='2024-03-16 23:15:9' AND e.DeviceLoginName='8987' 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-03-16 03:15:09' AND g.time<='2024-03-16 21:15:09' AND g.DeviceLoginName='8987' GROUP BY g.time, g.Distance; CountAzimuth:2173 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-12 19:0:45' AND e.date<='2024-03-12 20:0:45' AND e.DeviceLoginName='355234055304584' 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-03-12 17:00:45' AND g.time<='2024-03-12 18:00:45' AND g.DeviceLoginName='355234055304584' GROUP BY g.time, g.Distance; CountAzimuth:254 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-17 15:52:19' AND e.date<='2024-03-18 15:52:19' AND e.DeviceLoginName='4819' 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-03-17 13:52:19' AND g.time<='2024-03-18 13:52:19' AND g.DeviceLoginName='4819' GROUP BY g.time, g.Distance; CountAzimuth:11