Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-21 7:26:15' AND e.date<='2024-10-21 23:26:15' 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>='2024-10-21 04:26:15' AND g.time<='2024-10-21 20:26:15' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:813 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 4:27:11' AND e.date<='2024-10-22 7:27:11' 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>='2024-10-22 01:27:11' AND g.time<='2024-10-22 04:27:11' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:285 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 5:27:40' AND e.date<='2024-10-22 7:27:40' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-22 02:27:40' AND g.time<='2024-10-22 04:27:40' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:238 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 5:28:31' AND e.date<='2024-10-22 7:28:31' AND e.DeviceLoginName='2556' 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>='2024-10-22 02:28:31' AND g.time<='2024-10-22 04:28:31' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:2 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 6:28:47' AND e.date<='2024-10-22 7:28:47' AND e.DeviceLoginName='2556' 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>='2024-10-22 03:28:47' AND g.time<='2024-10-22 04:28:47' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 5:0:0' AND e.DeviceLoginName='9376' 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>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='9376' GROUP BY g.time, g.Distance; CountAzimuth:32 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 5:0:0' AND e.DeviceLoginName='4848' 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>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='4848' GROUP BY g.time, g.Distance; CountAzimuth:129 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 5:0:0' AND e.DeviceLoginName='3176' 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>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='3176' GROUP BY g.time, g.Distance; CountAzimuth:175 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 5:0:0' AND e.DeviceLoginName='3184' 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>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='3184' GROUP BY g.time, g.Distance; CountAzimuth:139 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 5:0:0' AND e.DeviceLoginName='4849' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:271 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:71 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='3045' GROUP BY g.time, g.Distance; CountAzimuth:15 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 5:0:0' AND e.DeviceLoginName='2703' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='2703' GROUP BY g.time, g.Distance; CountAzimuth:68 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:6 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 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>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='2947' GROUP BY g.time, g.Distance; CountAzimuth:119 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 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>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='2866' GROUP BY g.time, g.Distance; CountAzimuth:82 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 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>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:264 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='4868' GROUP BY g.time, g.Distance; CountAzimuth:183 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 5:0:0' AND e.DeviceLoginName='352353084176731' 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>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='352353084176731' GROUP BY g.time, g.Distance; CountAzimuth:74 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 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>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='2499' GROUP BY g.time, g.Distance; CountAzimuth:35 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 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>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='2584' GROUP BY g.time, g.Distance; CountAzimuth:99 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 5:0:0' AND e.DeviceLoginName='2964' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='2964' GROUP BY g.time, g.Distance; CountAzimuth:200 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-18 23:0:0' AND e.date<='2024-10-19 5:0:0' AND e.DeviceLoginName='352353084176731' 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>='2024-10-18 20:00:00' AND g.time<='2024-10-19 02:00:00' AND g.DeviceLoginName='352353084176731' GROUP BY g.time, g.Distance; CountAzimuth:74 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='4848' 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='4848' GROUP BY g.time, g.Distance; CountAzimuth:224 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='3184' 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='3184' GROUP BY g.time, g.Distance; CountAzimuth:231 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='5078' GROUP BY g.time, g.Distance; CountAzimuth:70 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='2790' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='2790' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='9375' 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='9375' GROUP BY g.time, g.Distance; CountAzimuth:115 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='353173060537865' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='353173060537865' GROUP BY g.time, g.Distance; CountAzimuth:131 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:361 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='5076' GROUP BY g.time, g.Distance; CountAzimuth:1024 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='3023' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='3023' GROUP BY g.time, g.Distance; CountAzimuth:493 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='3023' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='3023' GROUP BY g.time, g.Distance; CountAzimuth:493 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='862531041041535' GROUP BY g.time, g.Distance; CountAzimuth:9 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='8993' GROUP BY g.time, g.Distance; CountAzimuth:121 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='2947' GROUP BY g.time, g.Distance; CountAzimuth:163 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='4861' GROUP BY g.time, g.Distance; CountAzimuth:963 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='2470' GROUP BY g.time, g.Distance; CountAzimuth:929 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='2866' GROUP BY g.time, g.Distance; CountAzimuth:849 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:23 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='3156' 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='3156' GROUP BY g.time, g.Distance; CountAzimuth:262 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='2556' 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:75 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='2728' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='2728' GROUP BY g.time, g.Distance; CountAzimuth:51 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='2496' 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='2496' GROUP BY g.time, g.Distance; CountAzimuth:7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='2458' 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='2458' GROUP BY g.time, g.Distance; CountAzimuth:15 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='2550' 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='2550' GROUP BY g.time, g.Distance; CountAzimuth:192 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='2499' GROUP BY g.time, g.Distance; CountAzimuth:348 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='2627' 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='2627' GROUP BY g.time, g.Distance; CountAzimuth:61 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='2584' GROUP BY g.time, g.Distance; CountAzimuth:172 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 23:0:0' AND e.date<='2024-10-20 5:0:0' AND e.DeviceLoginName='4819' 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>='2024-10-19 20:00:00' AND g.time<='2024-10-20 02:00:00' AND g.DeviceLoginName='4819' GROUP BY g.time, g.Distance; CountAzimuth:682 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-20 23:0:0' AND e.date<='2024-10-21 5:0:0' AND e.DeviceLoginName='356078111430936' 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>='2024-10-20 20:00:00' AND g.time<='2024-10-21 02:00:00' AND g.DeviceLoginName='356078111430936' GROUP BY g.time, g.Distance; CountAzimuth:2 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-20 23:0:0' AND e.date<='2024-10-21 5:0:0' AND e.DeviceLoginName='3123' 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>='2024-10-20 20:00:00' AND g.time<='2024-10-21 02:00:00' AND g.DeviceLoginName='3123' GROUP BY g.time, g.Distance; CountAzimuth:62 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-20 23:0:0' AND e.date<='2024-10-21 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-20 20:00:00' AND g.time<='2024-10-21 02:00:00' AND g.DeviceLoginName='5078' GROUP BY g.time, g.Distance; CountAzimuth:127 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-20 23:0:0' AND e.date<='2024-10-21 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-20 20:00:00' AND g.time<='2024-10-21 02:00:00' AND g.DeviceLoginName='2883' GROUP BY g.time, g.Distance; CountAzimuth:23 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-20 23:0:0' AND e.date<='2024-10-21 5:0:0' AND e.DeviceLoginName='3188' 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>='2024-10-20 20:00:00' AND g.time<='2024-10-21 02:00:00' AND g.DeviceLoginName='3188' GROUP BY g.time, g.Distance; CountAzimuth:37 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-20 23:0:0' AND e.date<='2024-10-21 5:0:0' AND e.DeviceLoginName='4959' 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>='2024-10-20 20:00:00' AND g.time<='2024-10-21 02:00:00' AND g.DeviceLoginName='4959' GROUP BY g.time, g.Distance; CountAzimuth:341 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-20 23:0:0' AND e.date<='2024-10-21 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>='2024-10-20 20:00:00' AND g.time<='2024-10-21 02:00:00' AND g.DeviceLoginName='862531041041535' GROUP BY g.time, g.Distance; CountAzimuth:132 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-20 23:0:0' AND e.date<='2024-10-21 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-20 20:00:00' AND g.time<='2024-10-21 02:00:00' AND g.DeviceLoginName='3124' GROUP BY g.time, g.Distance; CountAzimuth:236 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-20 23:0:0' AND e.date<='2024-10-21 5:0:0' AND e.DeviceLoginName='2556' 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>='2024-10-20 20:00:00' AND g.time<='2024-10-21 02:00:00' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:6 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-20 23:0:0' AND e.date<='2024-10-21 5:0:0' AND e.DeviceLoginName='3172' 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>='2024-10-20 20:00:00' AND g.time<='2024-10-21 02:00:00' AND g.DeviceLoginName='3172' GROUP BY g.time, g.Distance; CountAzimuth:107 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 7:15:23' AND e.date<='2024-10-22 11:15:23' AND e.DeviceLoginName='3080' 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>='2024-10-22 04:15:23' AND g.time<='2024-10-22 08:15:23' AND g.DeviceLoginName='3080' GROUP BY g.time, g.Distance; CountAzimuth:419 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 6:15:23' AND e.date<='2024-10-22 11:15:23' AND e.DeviceLoginName='3080' 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>='2024-10-22 03:15:23' AND g.time<='2024-10-22 08:15:23' AND g.DeviceLoginName='3080' GROUP BY g.time, g.Distance; CountAzimuth:418 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 5:35:39' AND e.date<='2024-10-22 11:35:39' 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>='2024-10-22 02:35:39' AND g.time<='2024-10-22 08:35:39' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:318 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 4:36:2' AND e.date<='2024-10-22 11:36:2' AND e.DeviceLoginName='2556' 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>='2024-10-22 01:36:02' AND g.time<='2024-10-22 08:36:02' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 8:37:56' AND e.date<='2024-10-22 11:37:56' 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>='2024-10-22 05:37:56' AND g.time<='2024-10-22 08:37:56' 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-10-22 9:38:13' AND e.date<='2024-10-22 11:38:13' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-22 06:38:13' AND g.time<='2024-10-22 08:38:13' 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-10-22 8:36:3' AND e.date<='2024-10-22 12:36:3' 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>='2024-10-22 05:36:03' AND g.time<='2024-10-22 09:36:03' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:133 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 9:36:23' AND e.date<='2024-10-22 12:36:23' 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>='2024-10-22 06:36:23' AND g.time<='2024-10-22 09:36:23' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:133 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 5:45:30' AND e.date<='2024-10-22 13:45:30' AND e.DeviceLoginName='2556' 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>='2024-10-22 02:45:30' AND g.time<='2024-10-22 10:45:30' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:315 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 10:46:18' AND e.date<='2024-10-22 13:46:18' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-22 07:46:18' AND g.time<='2024-10-22 10:46:18' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:124 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 2:46:38' AND e.date<='2024-10-22 13:46:38' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-21 23:46:38' AND g.time<='2024-10-22 10:46:38' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:610 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 13:2:49' AND e.date<='2024-10-22 15:2:49' 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>='2024-10-22 10:02:49' AND g.time<='2024-10-22 12:02:49' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 14:3:7' AND e.date<='2024-10-22 15:3:7' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-22 11:03:07' AND g.time<='2024-10-22 12:03:07' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:200 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-22 6:0:0' AND e.date<='2024-10-22 19:36:59' AND e.DeviceLoginName='356078116291663' 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>='2024-10-22 03:00:00' AND g.time<='2024-10-22 16:36:59' AND g.DeviceLoginName='356078116291663' GROUP BY g.time, g.Distance; CountAzimuth:1159