Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-17 5:23:56' AND e.date<='2024-05-17 9:23: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-05-17 02:23:56' AND g.time<='2024-05-17 06:23:56' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:380 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-11 0:0:28' AND e.date<='2024-05-12 23:0:28' AND e.DeviceLoginName='356078118085311' 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-05-10 21:00:28' AND g.time<='2024-05-12 20:00:28' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:1721 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-11 0:0:28' AND e.date<='2024-05-11 23:0:28' AND e.DeviceLoginName='356078118085311' 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-05-10 21:00:28' AND g.time<='2024-05-11 20:00:28' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:784 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-12 0:0:28' AND e.date<='2024-05-12 23:0:28' AND e.DeviceLoginName='356078118085311' 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-05-11 21:00:28' AND g.time<='2024-05-12 20:00:28' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:934 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-17 0:0:28' AND e.date<='2024-05-17 23:0:28' AND e.DeviceLoginName='356078118085311' 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-05-16 21:00:28' AND g.time<='2024-05-17 20:00:28' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:341 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-16 0:0:28' AND e.date<='2024-05-16 23:0:28' AND e.DeviceLoginName='356078118085311' 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-05-15 21:00:28' AND g.time<='2024-05-16 20:00:28' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:2355 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-15 0:0:28' AND e.date<='2024-05-15 23:0:28' AND e.DeviceLoginName='356078118085311' 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-05-14 21:00:28' AND g.time<='2024-05-15 20:00:28' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:1871 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-06 0:0:28' AND e.date<='2024-05-06 23:0:28' AND e.DeviceLoginName='356078118085311' 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-05-05 21:00:28' AND g.time<='2024-05-06 20:00:28' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:1199 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-04 0:0:28' AND e.date<='2024-05-04 23:0:28' AND e.DeviceLoginName='356078118085311' 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-05-03 21:00:28' AND g.time<='2024-05-04 20:00:28' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:1268 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-05 0:0:28' AND e.date<='2024-05-05 23:0:28' AND e.DeviceLoginName='356078118085311' 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-05-04 21:00:28' AND g.time<='2024-05-05 20:00:28' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:986 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-08 0:0:28' AND e.date<='2024-05-08 23:0:28' AND e.DeviceLoginName='356078118085311' 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-05-07 21:00:28' AND g.time<='2024-05-08 20:00:28' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:1697 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-16 10:4:41' AND e.date<='2024-05-17 10:4:41' AND e.DeviceLoginName='2667' 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-05-16 07:04:41' AND g.time<='2024-05-17 07:04:41' AND g.DeviceLoginName='2667' GROUP BY g.time, g.Distance; CountAzimuth:8839 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-16 10:4:41' AND e.date<='2024-05-17 10:4:41' AND e.DeviceLoginName='2667' 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-05-16 07:04:41' AND g.time<='2024-05-17 07:04:41' AND g.DeviceLoginName='2667' GROUP BY g.time, g.Distance; CountAzimuth:8869 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-16 10:4:41' AND e.date<='2024-05-17 23:4:41' AND e.DeviceLoginName='2667' 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-05-16 07:04:41' AND g.time<='2024-05-17 20:04:41' AND g.DeviceLoginName='2667' GROUP BY g.time, g.Distance; CountAzimuth:9086 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-16 10:4:41' AND e.date<='2024-05-17 23:4:41' AND e.DeviceLoginName='2667' 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-05-16 07:04:41' AND g.time<='2024-05-17 20:04:41' AND g.DeviceLoginName='2667' GROUP BY g.time, g.Distance; CountAzimuth:9104 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-16 10:4:41' AND e.date<='2024-05-17 23:4:41' AND e.DeviceLoginName='2667' 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-05-16 07:04:41' AND g.time<='2024-05-17 20:04:41' AND g.DeviceLoginName='2667' GROUP BY g.time, g.Distance; CountAzimuth:9162 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-16 10:4:41' AND e.date<='2024-05-17 23:4:41' AND e.DeviceLoginName='2667' 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-05-16 07:04:41' AND g.time<='2024-05-17 20:04:41' AND g.DeviceLoginName='2667' GROUP BY g.time, g.Distance; CountAzimuth:9163 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-16 0:51:59' AND e.date<='2024-05-16 23:51:59' AND e.DeviceLoginName='352353084195392' 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-05-15 21:51:59' AND g.time<='2024-05-16 20:51:59' AND g.DeviceLoginName='352353084195392' GROUP BY g.time, g.Distance; CountAzimuth:1279 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-17 0:51:59' AND e.date<='2024-05-17 23:51:59' AND e.DeviceLoginName='352353084195392' 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-05-16 21:51:59' AND g.time<='2024-05-17 20:51:59' AND g.DeviceLoginName='352353084195392' GROUP BY g.time, g.Distance; CountAzimuth:1195 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-17 0:46:46' AND e.date<='2024-05-17 16:46:46' AND e.DeviceLoginName='4884' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-05-16 21:46:46' AND g.time<='2024-05-17 13:46:46' AND g.DeviceLoginName='4884' GROUP BY g.time, g.Distance; CountAzimuth:9 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-13 23:0:0' AND e.date<='2024-05-14 5:0:0' AND e.DeviceLoginName='9010' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-05-13 20:00:00' AND g.time<='2024-05-14 02:00:00' AND g.DeviceLoginName='9010' GROUP BY g.time, g.Distance; CountAzimuth:182 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-13 23:0:0' AND e.date<='2024-05-14 5:0:0' AND e.DeviceLoginName='862531041078313' 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-05-13 20:00:00' AND g.time<='2024-05-14 02:00:00' AND g.DeviceLoginName='862531041078313' GROUP BY g.time, g.Distance; CountAzimuth:10 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-13 23:0:0' AND e.date<='2024-05-14 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-05-13 20:00:00' AND g.time<='2024-05-14 02:00:00' AND g.DeviceLoginName='3176' GROUP BY g.time, g.Distance; CountAzimuth:213 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-13 23:0:0' AND e.date<='2024-05-14 5:0:0' AND e.DeviceLoginName='357804048849149' 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-05-13 20:00:00' AND g.time<='2024-05-14 02:00:00' AND g.DeviceLoginName='357804048849149' GROUP BY g.time, g.Distance; CountAzimuth:49 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-13 23:0:0' AND e.date<='2024-05-14 5:0:0' AND e.DeviceLoginName='353173060487970' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-05-13 20:00:00' AND g.time<='2024-05-14 02:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY g.time, g.Distance; CountAzimuth:77 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-13 23:0:0' AND e.date<='2024-05-14 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-05-13 20:00:00' AND g.time<='2024-05-14 02:00:00' AND g.DeviceLoginName='2585' GROUP BY g.time, g.Distance; CountAzimuth:24 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-13 23:0:0' AND e.date<='2024-05-14 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-05-13 20:00:00' AND g.time<='2024-05-14 02:00:00' AND g.DeviceLoginName='2496' GROUP BY g.time, g.Distance; CountAzimuth:23 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-13 23:0:0' AND e.date<='2024-05-14 5:0:0' AND e.DeviceLoginName='3032' 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-05-13 20:00:00' AND g.time<='2024-05-14 02:00:00' AND g.DeviceLoginName='3032' GROUP BY g.time, g.Distance; CountAzimuth:2 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-13 23:0:0' AND e.date<='2024-05-14 5:0:0' AND e.DeviceLoginName='3115' 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-05-13 20:00:00' AND g.time<='2024-05-14 02:00:00' AND g.DeviceLoginName='3115' GROUP BY g.time, g.Distance; CountAzimuth:38 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 23:0:0' AND e.date<='2024-05-15 5:0:0' AND e.DeviceLoginName='9010' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-05-14 20:00:00' AND g.time<='2024-05-15 02:00:00' AND g.DeviceLoginName='9010' GROUP BY g.time, g.Distance; CountAzimuth:173 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 23:0:0' AND e.date<='2024-05-15 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-05-14 20:00:00' AND g.time<='2024-05-15 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:474 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 23:0:0' AND e.date<='2024-05-15 5:0:0' AND e.DeviceLoginName='3081' 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-05-14 20:00:00' AND g.time<='2024-05-15 02:00:00' AND g.DeviceLoginName='3081' GROUP BY g.time, g.Distance; CountAzimuth:63 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 23:0:0' AND e.date<='2024-05-15 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-05-14 20:00:00' AND g.time<='2024-05-15 02:00:00' AND g.DeviceLoginName='352353084234167' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 23:0:0' AND e.date<='2024-05-15 5:0:0' AND e.DeviceLoginName='353173060487970' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-05-14 20:00:00' AND g.time<='2024-05-15 02:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY g.time, g.Distance; CountAzimuth:52 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 23:0:0' AND e.date<='2024-05-15 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-05-14 20:00:00' AND g.time<='2024-05-15 02:00:00' AND g.DeviceLoginName='2585' GROUP BY g.time, g.Distance; CountAzimuth:35 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 23:0:0' AND e.date<='2024-05-15 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-05-14 20:00:00' AND g.time<='2024-05-15 02:00:00' AND g.DeviceLoginName='3156' GROUP BY g.time, g.Distance; CountAzimuth:416 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 23:0:0' AND e.date<='2024-05-15 5:0:0' AND e.DeviceLoginName='3032' 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-05-14 20:00:00' AND g.time<='2024-05-15 02:00:00' AND g.DeviceLoginName='3032' GROUP BY g.time, g.Distance; CountAzimuth:11