Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-01 0:0:56' AND e.date<='2023-12-01 23:0:56' AND e.DeviceLoginName='2898' 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-30 22:00:56' AND g.time<='2023-12-01 21:00:56' AND g.DeviceLoginName='2898' GROUP BY g.time, g.Distance; CountAzimuth:2056 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-02 0:0:56' AND e.date<='2023-12-02 23:0:56' 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>='2023-12-01 22:00:56' AND g.time<='2023-12-02 21:00:56' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:88 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-02 0:6:56' AND e.date<='2023-12-02 23:6:56' AND e.DeviceLoginName='2500' 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-01 22:06:56' AND g.time<='2023-12-02 21:06:56' AND g.DeviceLoginName='2500' GROUP BY g.time, g.Distance; CountAzimuth:148 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-16 0:6:56' AND e.date<='2023-12-16 23:6:56' AND e.DeviceLoginName='3188' 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-15 22:06:56' AND g.time<='2023-12-16 21:06:56' AND g.DeviceLoginName='3188' GROUP BY g.time, g.Distance; CountAzimuth:90 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-16 0:6:56' AND e.date<='2023-12-16 23:6:56' AND e.DeviceLoginName='2876' 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-15 22:06:56' AND g.time<='2023-12-16 21:06:56' AND g.DeviceLoginName='2876' GROUP BY g.time, g.Distance; CountAzimuth:478 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-16 0:6:56' AND e.date<='2023-12-16 23:6:56' 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>='2023-12-15 22:06:56' AND g.time<='2023-12-16 21:06:56' AND g.DeviceLoginName='355234055170423' GROUP BY g.time, g.Distance; CountAzimuth:749 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-25 0:25:28' AND e.date<='2023-11-25 23:25:28' 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>='2023-11-24 22:25:28' AND g.time<='2023-11-25 21:25:28' AND g.DeviceLoginName='2554' GROUP BY g.time, g.Distance; CountAzimuth:264 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-25 0:25:28' AND e.date<='2023-11-25 23:25:28' AND e.DeviceLoginName='3025' 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-24 22:25:28' AND g.time<='2023-11-25 21:25:28' AND g.DeviceLoginName='3025' GROUP BY g.time, g.Distance; CountAzimuth:1417 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-25 0:25:28' AND e.date<='2023-11-25 23:25:28' AND e.DeviceLoginName='3126' 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-24 22:25:28' AND g.time<='2023-11-25 21:25:28' AND g.DeviceLoginName='3126' GROUP BY g.time, g.Distance; CountAzimuth:102 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-25 0:25:28' AND e.date<='2023-11-25 23:25:28' AND e.DeviceLoginName='2743' 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-24 22:25:28' AND g.time<='2023-11-25 21:25:28' AND g.DeviceLoginName='2743' GROUP BY g.time, g.Distance; CountAzimuth:171 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-26 0:25:28' AND e.date<='2023-11-26 23:25:28' 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>='2023-11-25 22:25:28' AND g.time<='2023-11-26 21:25:28' AND g.DeviceLoginName='3187' GROUP BY g.time, g.Distance; CountAzimuth:624 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-26 0:28:41' AND e.date<='2023-11-26 23:28:41' AND e.DeviceLoginName='2756' 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-25 22:28:41' AND g.time<='2023-11-26 21:28:41' AND g.DeviceLoginName='2756' GROUP BY g.time, g.Distance; CountAzimuth:43 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-09 0:28:41' AND e.date<='2023-12-09 23:28:41' AND e.DeviceLoginName='3167' 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-08 22:28:41' AND g.time<='2023-12-09 21:28:41' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:1409 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 0:28:41' AND e.date<='2023-12-23 23:28:41' AND e.DeviceLoginName='352353083473444' 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-22 22:28:41' AND g.time<='2023-12-23 21:28:41' AND g.DeviceLoginName='352353083473444' GROUP BY g.time, g.Distance; CountAzimuth:529 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 0:28:41' AND e.date<='2023-12-24 23:28:41' AND e.DeviceLoginName='352353083473444' 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-23 22:28:41' AND g.time<='2023-12-24 21:28:41' AND g.DeviceLoginName='352353083473444' GROUP BY g.time, g.Distance; CountAzimuth:620 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-16 0:28:41' AND e.date<='2023-12-16 23:28:41' 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>='2023-12-15 22:28:41' AND g.time<='2023-12-16 21:28:41' AND g.DeviceLoginName='3187' GROUP BY g.time, g.Distance; CountAzimuth:681 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-09 0:28:41' AND e.date<='2023-12-09 23:28:41' AND e.DeviceLoginName='3167' 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-08 22:28:41' AND g.time<='2023-12-09 21:28:41' AND g.DeviceLoginName='3167' GROUP BY g.time, g.Distance; CountAzimuth:1409 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-10 0:28:41' AND e.date<='2023-12-10 23:28:41' AND e.DeviceLoginName='352353083473444' 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-09 22:28:41' AND g.time<='2023-12-10 21:28:41' AND g.DeviceLoginName='352353083473444' GROUP BY g.time, g.Distance; CountAzimuth:677 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-25 7:30:20' AND e.date<='2023-12-25 11:30:20' AND e.DeviceLoginName='356078111472417' 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:30:20' AND g.time<='2023-12-25 09:30:20' AND g.DeviceLoginName='356078111472417' GROUP BY g.time, g.Distance; CountAzimuth:372 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 2:40:23' AND e.date<='2023-12-22 23:59:23' AND e.DeviceLoginName='2580' 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-22 00:40:23' AND g.time<='2023-12-22 21:59:23' AND g.DeviceLoginName='2580' GROUP BY g.time, g.Distance; CountAzimuth:3200 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 23:0:0' AND e.date<='2023-12-24 5:0:0' AND e.DeviceLoginName='5130' 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-23 21:00:00' AND g.time<='2023-12-24 03:00:00' AND g.DeviceLoginName='5130' GROUP BY g.time, g.Distance; CountAzimuth:179 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 23:0:0' AND e.date<='2023-12-24 5:0:0' AND e.DeviceLoginName='3079' 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-23 21:00:00' AND g.time<='2023-12-24 03:00:00' AND g.DeviceLoginName='3079' GROUP BY g.time, g.Distance; CountAzimuth:411 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 23:0:0' AND e.date<='2023-12-24 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>='2023-12-23 21:00:00' AND g.time<='2023-12-24 03:00:00' AND g.DeviceLoginName='4964' GROUP BY g.time, g.Distance; CountAzimuth:548 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 23:0:0' AND e.date<='2023-12-24 5:0:0' AND e.DeviceLoginName='5078' 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-23 21:00:00' AND g.time<='2023-12-24 03:00:00' AND g.DeviceLoginName='5078' GROUP BY g.time, g.Distance; CountAzimuth:155 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 23:0:0' AND e.date<='2023-12-24 5:0:0' AND e.DeviceLoginName='3045' 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-23 21:00:00' AND g.time<='2023-12-24 03:00:00' AND g.DeviceLoginName='3045' GROUP BY g.time, g.Distance; CountAzimuth:414 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 23:0:0' AND e.date<='2023-12-25 5:0:0' AND e.DeviceLoginName='5078' 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-24 21:00:00' AND g.time<='2023-12-25 03:00:00' AND g.DeviceLoginName='5078' GROUP BY g.time, g.Distance; CountAzimuth:165 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 23:0:0' AND e.date<='2023-12-25 5:0:0' AND e.DeviceLoginName='3045' 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-24 21:00:00' AND g.time<='2023-12-25 03:00:00' AND g.DeviceLoginName='3045' GROUP BY g.time, g.Distance; CountAzimuth:49 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 23:0:0' AND e.date<='2023-12-25 5:0:0' AND e.DeviceLoginName='3045' 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-24 21:00:00' AND g.time<='2023-12-25 03:00:00' AND g.DeviceLoginName='3045' GROUP BY g.time, g.Distance; CountAzimuth:49 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 23:0:0' AND e.date<='2023-12-25 5:0:0' AND e.DeviceLoginName='354836080152241' 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-24 21:00:00' AND g.time<='2023-12-25 03:00:00' AND g.DeviceLoginName='354836080152241' GROUP BY g.time, g.Distance; CountAzimuth:27 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 23:0:0' AND e.date<='2023-12-25 5: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>='2023-12-24 21:00:00' AND g.time<='2023-12-25 03:00:00' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:290 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 23:0:0' AND e.date<='2023-12-25 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>='2023-12-24 21:00:00' AND g.time<='2023-12-25 03:00:00' AND g.DeviceLoginName='4868' GROUP BY g.time, g.Distance; CountAzimuth:164