Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:35:43' AND e.date<='2025-04-22 23:35:43' AND e.DeviceLoginName='358021081839700' 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>='2025-04-21 21:35:43' AND g.time<='2025-04-22 20:35:43' AND g.DeviceLoginName='358021081839700' GROUP BY g.time, g.Distance; CountAzimuth:753 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-27 0:35:43' AND e.date<='2025-04-27 23:35:43' AND e.DeviceLoginName='358021081839700' 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>='2025-04-26 21:35:43' AND g.time<='2025-04-27 20:35:43' AND g.DeviceLoginName='358021081839700' GROUP BY g.time, g.Distance; CountAzimuth:1119 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 0:35:43' AND e.date<='2025-04-26 23:35:43' AND e.DeviceLoginName='355234055727404' 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>='2025-04-25 21:35:43' AND g.time<='2025-04-26 20:35:43' AND g.DeviceLoginName='355234055727404' GROUP BY g.time, g.Distance; CountAzimuth:599 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-27 0:35:43' AND e.date<='2025-04-27 23:35:43' AND e.DeviceLoginName='356078111353955' 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>='2025-04-26 21:35:43' AND g.time<='2025-04-27 20:35:43' AND g.DeviceLoginName='356078111353955' GROUP BY g.time, g.Distance; CountAzimuth:458 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:35:43' AND e.date<='2025-04-22 23:35:43' AND e.DeviceLoginName='352353084232922' 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>='2025-04-21 21:35:43' AND g.time<='2025-04-22 20:35:43' AND g.DeviceLoginName='352353084232922' GROUP BY g.time, g.Distance; CountAzimuth:510 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:35:43' AND e.date<='2025-04-22 23:35:43' AND e.DeviceLoginName='5130' 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>='2025-04-21 21:35:43' AND g.time<='2025-04-22 20:35:43' AND g.DeviceLoginName='5130' GROUP BY g.time, g.Distance; CountAzimuth:1601 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:35:43' AND e.date<='2025-04-22 23:35:43' AND e.DeviceLoginName='352353086150999' 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>='2025-04-21 21:35:43' AND g.time<='2025-04-22 20:35:43' AND g.DeviceLoginName='352353086150999' GROUP BY g.time, g.Distance; CountAzimuth:317 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-24 0:35:43' AND e.date<='2025-04-24 23:35:43' AND e.DeviceLoginName='352353086150999' 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>='2025-04-23 21:35:43' AND g.time<='2025-04-24 20:35:43' AND g.DeviceLoginName='352353086150999' GROUP BY g.time, g.Distance; CountAzimuth:1983 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:35:43' AND e.date<='2025-04-22 23:35:43' AND e.DeviceLoginName='356078111446148' 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>='2025-04-21 21:35:43' AND g.time<='2025-04-22 20:35:43' AND g.DeviceLoginName='356078111446148' GROUP BY g.time, g.Distance; CountAzimuth:133 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:35:43' AND e.date<='2025-04-22 23:35:43' AND e.DeviceLoginName='355234055565614' 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>='2025-04-21 21:35:43' AND g.time<='2025-04-22 20:35:43' AND g.DeviceLoginName='355234055565614' GROUP BY g.time, g.Distance; CountAzimuth:1102 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:35:43' AND e.date<='2025-04-22 23:35:43' AND e.DeviceLoginName='356078118143466' 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>='2025-04-21 21:35:43' AND g.time<='2025-04-22 20:35:43' AND g.DeviceLoginName='356078118143466' GROUP BY g.time, g.Distance; CountAzimuth:732 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 0:35:43' AND e.date<='2025-04-25 23:35:43' AND e.DeviceLoginName='355234055189084' 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>='2025-04-24 21:35:43' AND g.time<='2025-04-25 20:35:43' AND g.DeviceLoginName='355234055189084' GROUP BY g.time, g.Distance; CountAzimuth:792 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-24 0:35:43' AND e.date<='2025-04-24 23:35:43' AND e.DeviceLoginName='862531041085110' 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>='2025-04-23 21:35:43' AND g.time<='2025-04-24 20:35:43' AND g.DeviceLoginName='862531041085110' GROUP BY g.time, g.Distance; CountAzimuth:1323 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 0:35:43' AND e.date<='2025-04-25 23:35:43' AND e.DeviceLoginName='862531041085110' 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>='2025-04-24 21:35:43' AND g.time<='2025-04-25 20:35:43' AND g.DeviceLoginName='862531041085110' GROUP BY g.time, g.Distance; CountAzimuth:848 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:35:43' AND e.date<='2025-04-22 23:35:43' AND e.DeviceLoginName='354836080152241' 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>='2025-04-21 21:35:43' AND g.time<='2025-04-22 20:35:43' AND g.DeviceLoginName='354836080152241' GROUP BY g.time, g.Distance; CountAzimuth:867 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-27 0:35:43' AND e.date<='2025-04-27 23:35:43' AND e.DeviceLoginName='354836080152241' 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>='2025-04-26 21:35:43' AND g.time<='2025-04-27 20:35:43' AND g.DeviceLoginName='354836080152241' GROUP BY g.time, g.Distance; CountAzimuth:197 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:35:43' AND e.date<='2025-04-22 23:35:43' AND e.DeviceLoginName='356078111447633' 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>='2025-04-21 21:35:43' AND g.time<='2025-04-22 20:35:43' AND g.DeviceLoginName='356078111447633' GROUP BY g.time, g.Distance; CountAzimuth:270 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:35:43' AND e.date<='2025-04-22 23:35:43' AND e.DeviceLoginName='356078111447633' 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>='2025-04-21 21:35:43' AND g.time<='2025-04-22 20:35:43' AND g.DeviceLoginName='356078111447633' GROUP BY g.time, g.Distance; CountAzimuth:270 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:35:43' AND e.date<='2025-04-22 23:35:43' AND e.DeviceLoginName='352353085039086' 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>='2025-04-21 21:35:43' AND g.time<='2025-04-22 20:35:43' AND g.DeviceLoginName='352353085039086' GROUP BY g.time, g.Distance; CountAzimuth:493 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 0:35:43' AND e.date<='2025-04-26 23:35:43' AND e.DeviceLoginName='352353085039086' 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>='2025-04-25 21:35:43' AND g.time<='2025-04-26 20:35:43' AND g.DeviceLoginName='352353085039086' GROUP BY g.time, g.Distance; CountAzimuth:232 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:35:43' AND e.date<='2025-04-22 23:35:43' AND e.DeviceLoginName='352353086131585' 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>='2025-04-21 21:35:43' AND g.time<='2025-04-22 20:35:43' AND g.DeviceLoginName='352353086131585' GROUP BY g.time, g.Distance; CountAzimuth:897 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 0:35:43' AND e.date<='2025-04-26 23:35:43' AND e.DeviceLoginName='862531041054447' 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>='2025-04-25 21:35:43' AND g.time<='2025-04-26 20:35:43' AND g.DeviceLoginName='862531041054447' GROUP BY g.time, g.Distance; CountAzimuth:172 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 0:35:43' AND e.date<='2025-04-26 23:35:43' AND e.DeviceLoginName='356078111310823' 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>='2025-04-25 21:35:43' AND g.time<='2025-04-26 20:35:43' AND g.DeviceLoginName='356078111310823' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-24 0:35:43' AND e.date<='2025-04-24 23:35:43' AND e.DeviceLoginName='356078111310823' 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>='2025-04-23 21:35:43' AND g.time<='2025-04-24 20:35:43' AND g.DeviceLoginName='356078111310823' GROUP BY g.time, g.Distance; CountAzimuth:1949 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-22 0:35:43' AND e.date<='2025-04-22 23:35:43' AND e.DeviceLoginName='356078116286176' 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>='2025-04-21 21:35:43' AND g.time<='2025-04-22 20:35:43' AND g.DeviceLoginName='356078116286176' GROUP BY g.time, g.Distance; CountAzimuth:1297 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-27 10:25:2' AND e.date<='2025-04-28 10:25:2' AND e.DeviceLoginName='355234055747568' 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>='2025-04-27 07:25:02' AND g.time<='2025-04-28 07:25:02' AND g.DeviceLoginName='355234055747568' GROUP BY g.time, g.Distance; CountAzimuth:23 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 10:25:2' AND e.date<='2025-04-28 10:25:2' AND e.DeviceLoginName='355234055747568' 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>='2025-04-21 07:25:02' AND g.time<='2025-04-28 07:25:02' AND g.DeviceLoginName='355234055747568' GROUP BY g.time, g.Distance; CountAzimuth:199 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 0:25:2' AND e.date<='2025-04-27 23:25:2' AND e.DeviceLoginName='3040' 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>='2025-04-25 21:25:02' AND g.time<='2025-04-27 20:25:02' AND g.DeviceLoginName='3040' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 0:25:2' AND e.date<='2025-04-27 23:25:2' AND e.DeviceLoginName='3040' 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>='2025-04-20 21:25:02' AND g.time<='2025-04-27 20:25:02' AND g.DeviceLoginName='3040' GROUP BY g.time, g.Distance; CountAzimuth:3700 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-27 0:23:10' AND e.date<='2025-04-28 11:23:10' AND e.DeviceLoginName='354836080091142' 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>='2025-04-26 21:23:10' AND g.time<='2025-04-28 08:23:10' AND g.DeviceLoginName='354836080091142' GROUP BY g.time, g.Distance; CountAzimuth:131 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-17 0:23:10' AND e.date<='2025-04-28 11:23:10' AND e.DeviceLoginName='354836080091142' 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>='2025-04-16 21:23:10' AND g.time<='2025-04-28 08:23:10' AND g.DeviceLoginName='354836080091142' GROUP BY g.time, g.Distance; CountAzimuth:242 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 0:25:7' AND e.date<='2025-04-26 22:25:7' 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>='2025-04-25 21:25:07' AND g.time<='2025-04-26 19:25:07' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1172 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-27 2:27:54' AND e.date<='2025-04-28 23:27:54' 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>='2025-04-26 23:27:54' AND g.time<='2025-04-28 20:27:54' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:627 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 11:34:2' AND e.date<='2025-04-28 11:34:2' AND e.DeviceLoginName='352353086150999' 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>='2025-04-18 08:34:02' AND g.time<='2025-04-28 08:34:02' AND g.DeviceLoginName='352353086150999' GROUP BY g.time, g.Distance; CountAzimuth:6470 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 11:34:2' AND e.date<='2025-04-28 11:34:2' AND e.DeviceLoginName='356078111472284' 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>='2025-04-18 08:34:02' AND g.time<='2025-04-28 08:34:02' AND g.DeviceLoginName='356078111472284' GROUP BY g.time, g.Distance; CountAzimuth:6667 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-24 0:42:30' AND e.date<='2025-04-28 11:42:30' AND e.DeviceLoginName='2954' 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>='2025-04-23 21:42:30' AND g.time<='2025-04-28 08:42:30' AND g.DeviceLoginName='2954' GROUP BY g.time, g.Distance; CountAzimuth:5690 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 0:42:30' AND e.date<='2025-04-25 23:42:30' AND e.DeviceLoginName='2954' 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>='2025-04-20 21:42:30' AND g.time<='2025-04-25 20:42:30' AND g.DeviceLoginName='2954' GROUP BY g.time, g.Distance; CountAzimuth:6299 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-14 0:42:30' AND e.date<='2025-04-19 23:42:30' AND e.DeviceLoginName='2954' 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>='2025-04-13 21:42:30' AND g.time<='2025-04-19 20:42:30' AND g.DeviceLoginName='2954' GROUP BY g.time, g.Distance; CountAzimuth:8944 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 0:42:30' AND e.date<='2025-04-28 23:42:30' AND e.DeviceLoginName='2954' 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>='2025-04-27 21:42:30' AND g.time<='2025-04-28 20:42:30' AND g.DeviceLoginName='2954' GROUP BY g.time, g.Distance; CountAzimuth:606 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-27 11:44:24' AND e.date<='2025-04-28 11:44:24' AND e.DeviceLoginName='356078118135272' 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>='2025-04-27 08:44:24' AND g.time<='2025-04-28 08:44:24' AND g.DeviceLoginName='356078118135272' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-24 11:44:24' AND e.date<='2025-04-28 11:44:24' AND e.DeviceLoginName='356078118135272' 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>='2025-04-24 08:44:24' AND g.time<='2025-04-28 08:44:24' AND g.DeviceLoginName='356078118135272' GROUP BY g.time, g.Distance; CountAzimuth:193 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-24 11:44:24' AND e.date<='2025-04-28 11:44:24' AND e.DeviceLoginName='2534' 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>='2025-04-24 08:44:24' AND g.time<='2025-04-28 08:44:24' AND g.DeviceLoginName='2534' GROUP BY g.time, g.Distance; CountAzimuth:2428 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 1:50:49' AND e.date<='2025-04-28 11:50: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>='2025-04-27 22:50:49' AND g.time<='2025-04-28 08:50:49' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:326 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 2:51:29' AND e.date<='2025-04-28 11:51:29' 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>='2025-04-27 23:51:29' AND g.time<='2025-04-28 08:51:29' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:246 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 4:51:53' AND e.date<='2025-04-28 11:51:53' AND e.DeviceLoginName='358021081803706' 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>='2025-04-28 01:51:53' AND g.time<='2025-04-28 08:51:53' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:256 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-27 11:52:23' AND e.date<='2025-04-28 11:52: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>='2025-04-27 08:52:23' AND g.time<='2025-04-28 08:52:23' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:328 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 3:52:36' AND e.date<='2025-04-28 11:52:36' 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>='2025-04-28 00:52:36' AND g.time<='2025-04-28 08:52:36' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:5 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 2:27:26' AND e.date<='2025-04-28 12:27:26' 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>='2025-04-27 23:27:26' AND g.time<='2025-04-28 09:27:26' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:337 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 0:35:8' AND e.date<='2025-04-28 12:35:8' 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>='2025-04-27 21:35:08' AND g.time<='2025-04-28 09:35:08' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:359 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-27 12:47:37' AND e.date<='2025-04-28 12:47:37' AND e.DeviceLoginName='352353083473741' 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>='2025-04-27 09:47:37' AND g.time<='2025-04-28 09:47:37' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:1097 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 0:47:37' AND e.date<='2025-04-25 23:47:37' AND e.DeviceLoginName='352353083473741' 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>='2025-04-24 21:47:37' AND g.time<='2025-04-25 20:47:37' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:4616 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-18 0:47:37' AND e.date<='2025-04-20 23:47:37' AND e.DeviceLoginName='352353083473741' 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>='2025-04-17 21:47:37' AND g.time<='2025-04-20 20:47:37' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:2688 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-11 0:47:37' AND e.date<='2025-04-13 23:47:37' AND e.DeviceLoginName='352353083473741' 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>='2025-04-10 21:47:37' AND g.time<='2025-04-13 20:47:37' AND g.DeviceLoginName='352353083473741' GROUP BY g.time, g.Distance; CountAzimuth:3613 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-23 16:0:49' AND e.date<='2025-04-23 17:52:49' AND e.DeviceLoginName='356078118127741' 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>='2025-04-23 13:00:49' AND g.time<='2025-04-23 14:52:49' AND g.DeviceLoginName='356078118127741' GROUP BY g.time, g.Distance; CountAzimuth:397 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 12:53:21' AND e.date<='2025-04-28 12:53:21' AND e.DeviceLoginName='353173066816669' 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>='2025-04-21 09:53:21' AND g.time<='2025-04-28 09:53:21' AND g.DeviceLoginName='353173066816669' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-23 16:30:49' AND e.date<='2025-04-23 17:0:49' AND e.DeviceLoginName='356078118127741' 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>='2025-04-23 13:30:49' AND g.time<='2025-04-23 14:00:49' AND g.DeviceLoginName='356078118127741' GROUP BY g.time, g.Distance; CountAzimuth:136 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-23 16:11:49' AND e.date<='2025-04-23 17:0:49' AND e.DeviceLoginName='356078118127741' 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>='2025-04-23 13:11:49' AND g.time<='2025-04-23 14:00:49' AND g.DeviceLoginName='356078118127741' GROUP BY g.time, g.Distance; CountAzimuth:203 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 4:30:20' AND e.date<='2025-04-26 23:30:20' 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>='2025-04-26 01:30:20' AND g.time<='2025-04-26 20:30:20' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1172 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-27 21:00:00' AND g.time<='2025-04-28 10:35:59' AND g.DeviceLoginName='864866053465430' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='864866053465430' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2025-04-27 21:00:00' AND e.date<='2025-04-28 10:35:59' Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 13:35:47' AND e.date<='2025-04-28 13:35:47' AND e.DeviceLoginName='2594' 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>='2025-04-25 10:35:47' AND g.time<='2025-04-28 10:35:47' AND g.DeviceLoginName='2594' GROUP BY g.time, g.Distance; CountAzimuth:264 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 13:35:47' AND e.date<='2025-04-27 13:35:47' AND e.DeviceLoginName='2594' 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>='2025-04-25 10:35:47' AND g.time<='2025-04-27 10:35:47' AND g.DeviceLoginName='2594' GROUP BY g.time, g.Distance; CountAzimuth:127 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 2:35:47' AND e.date<='2025-04-27 13:35:47' AND e.DeviceLoginName='2594' 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>='2025-04-27 23:35:47' AND g.time<='2025-04-27 10:35:47' AND g.DeviceLoginName='2594' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 2:35:47' AND e.date<='2025-04-28 13:35:47' AND e.DeviceLoginName='2594' 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>='2025-04-27 23:35:47' AND g.time<='2025-04-28 10:35:47' AND g.DeviceLoginName='2594' GROUP BY g.time, g.Distance; CountAzimuth:137 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 0:39:49' AND e.date<='2025-04-28 13:39: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>='2025-04-27 21:39:49' AND g.time<='2025-04-28 10:39:49' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:326 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 5:40:7' AND e.date<='2025-04-28 13:40: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>='2025-04-28 02:40:07' AND g.time<='2025-04-28 10:40:07' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:624 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:701 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 5:0:0' AND e.DeviceLoginName='3238' 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='3238' GROUP BY g.time, g.Distance; CountAzimuth:174 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 5:0:0' AND e.DeviceLoginName='3238' 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='3238' GROUP BY g.time, g.Distance; CountAzimuth:174 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='5078' GROUP BY g.time, g.Distance; CountAzimuth:161 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 5:0:0' AND e.DeviceLoginName='355234055221853' 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='355234055221853' GROUP BY g.time, g.Distance; CountAzimuth:245 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 5:0:0' AND e.DeviceLoginName='356078111430837' 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:15 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 5:0:0' AND e.DeviceLoginName='2876' 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='2876' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='3045' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='2703' GROUP BY g.time, g.Distance; CountAzimuth:34 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 5:0:0' AND e.DeviceLoginName='3191' 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='3191' GROUP BY g.time, g.Distance; CountAzimuth:4 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 5:0:0' AND e.DeviceLoginName='2773' 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='2773' GROUP BY g.time, g.Distance; CountAzimuth:67 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='862531041041535' GROUP BY g.time, g.Distance; CountAzimuth:85 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 5:0:0' AND e.DeviceLoginName='9000' 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='9000' GROUP BY g.time, g.Distance; CountAzimuth:205 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:237 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='2728' GROUP BY g.time, g.Distance; CountAzimuth:108 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 5:0:0' AND e.DeviceLoginName='3132' 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='3132' GROUP BY g.time, g.Distance; CountAzimuth:67 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 5:0:0' AND e.DeviceLoginName='3088' 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='3088' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='2499' GROUP BY g.time, g.Distance; CountAzimuth:119 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='3197' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='2964' GROUP BY g.time, g.Distance; CountAzimuth:377 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 23:0:0' AND e.date<='2025-04-26 5:0:0' AND e.DeviceLoginName='356078111294241' 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>='2025-04-25 20:00:00' AND g.time<='2025-04-26 02:00:00' AND g.DeviceLoginName='356078111294241' GROUP BY g.time, g.Distance; CountAzimuth:239 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 5:0:0' AND e.DeviceLoginName='9011' 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='9011' GROUP BY g.time, g.Distance; CountAzimuth:213 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 5:0:0' AND e.DeviceLoginName='356078118125679' 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='356078118125679' GROUP BY g.time, g.Distance; CountAzimuth:106 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:129 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 5:0:0' AND e.DeviceLoginName='2759' 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='2759' GROUP BY g.time, g.Distance; CountAzimuth:147 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:333 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 5:0:0' AND e.DeviceLoginName='862531041085110' 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='862531041085110' GROUP BY g.time, g.Distance; CountAzimuth:15 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 5:0:0' AND e.DeviceLoginName='2876' 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='2876' GROUP BY g.time, g.Distance; CountAzimuth:23 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 5:0:0' AND e.DeviceLoginName='354836080168387' 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='354836080168387' GROUP BY g.time, g.Distance; CountAzimuth:7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 5:0:0' AND e.DeviceLoginName='862531041078289' 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='862531041078289' GROUP BY g.time, g.Distance; CountAzimuth:10 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 5:0:0' AND e.DeviceLoginName='2722' 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='2722' GROUP BY g.time, g.Distance; CountAzimuth:138 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 5:0:0' AND e.DeviceLoginName='2773' 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='2773' GROUP BY g.time, g.Distance; CountAzimuth:28 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:179 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 5:0:0' AND e.DeviceLoginName='3043' 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='3043' GROUP BY g.time, g.Distance; CountAzimuth:144 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 5:0:0' 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='352353084195392' GROUP BY g.time, g.Distance; CountAzimuth:106 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 5:0:0' AND e.DeviceLoginName='2495' 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='2495' GROUP BY g.time, g.Distance; CountAzimuth:7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='2499' GROUP BY g.time, g.Distance; CountAzimuth:139 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 23:0:0' AND e.date<='2025-04-27 5:0:0' AND e.DeviceLoginName='356078118125679' 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>='2025-04-26 20:00:00' AND g.time<='2025-04-27 02:00:00' AND g.DeviceLoginName='356078118125679' GROUP BY g.time, g.Distance; CountAzimuth:106 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-27 23:0:0' AND e.date<='2025-04-28 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>='2025-04-27 20:00:00' AND g.time<='2025-04-28 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:317 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-27 23:0:0' AND e.date<='2025-04-28 5:0:0' AND e.DeviceLoginName='4883' 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>='2025-04-27 20:00:00' AND g.time<='2025-04-28 02:00:00' AND g.DeviceLoginName='4883' GROUP BY g.time, g.Distance; CountAzimuth:433 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 18:15:38' AND e.date<='2025-04-25 18:33:38' AND e.DeviceLoginName='2962' 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>='2025-04-25 15:15:38' AND g.time<='2025-04-25 15:33:38' AND g.DeviceLoginName='2962' GROUP BY g.time, g.Distance; CountAzimuth:181 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-23 11:40:38' AND e.date<='2025-04-23 11:50:38' AND e.DeviceLoginName='2953' 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>='2025-04-23 08:40:38' AND g.time<='2025-04-23 08:50:38' AND g.DeviceLoginName='2953' GROUP BY g.time, g.Distance; CountAzimuth:120 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-23 11:45:38' AND e.date<='2025-04-23 11:55:38' 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>='2025-04-23 08:45:38' AND g.time<='2025-04-23 08:55:38' AND g.DeviceLoginName='862531041078313' GROUP BY g.time, g.Distance; CountAzimuth:43 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 14:50:38' AND e.date<='2025-04-26 14:59:38' AND e.DeviceLoginName='352353084290888' 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>='2025-04-26 11:50:38' AND g.time<='2025-04-26 11:59:38' AND g.DeviceLoginName='352353084290888' GROUP BY g.time, g.Distance; CountAzimuth:96 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-26 14:55:38' AND e.date<='2025-04-26 14:59:38' AND e.DeviceLoginName='352353084290888' 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>='2025-04-26 11:55:38' AND g.time<='2025-04-26 11:59:38' AND g.DeviceLoginName='352353084290888' GROUP BY g.time, g.Distance; CountAzimuth:38 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 16:25:38' AND e.date<='2025-04-25 16:35:38' AND e.DeviceLoginName='352353084314373' 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>='2025-04-25 13:25:38' AND g.time<='2025-04-25 13:35:38' AND g.DeviceLoginName='352353084314373' GROUP BY g.time, g.Distance; CountAzimuth:61 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 0:25:38' AND e.date<='2025-04-28 16:35:38' AND e.DeviceLoginName='355234055727404' 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>='2025-04-27 21:25:38' AND g.time<='2025-04-28 13:35:38' AND g.DeviceLoginName='355234055727404' GROUP BY g.time, g.Distance; CountAzimuth:429 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-25 0:25:38' AND e.date<='2025-04-25 23:35:38' AND e.DeviceLoginName='355234055727404' 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>='2025-04-24 21:25:38' AND g.time<='2025-04-25 20:35:38' AND g.DeviceLoginName='355234055727404' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 0:54:55' AND e.date<='2025-04-28 15:54:55' 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>='2025-04-27 21:54:55' AND g.time<='2025-04-28 12:54:55' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:830 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 7:29:50' AND e.date<='2025-04-28 16:29:50' 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>='2025-04-28 04:29:50' AND g.time<='2025-04-28 13:29:50' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:710 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 9:30:56' AND e.date<='2025-04-28 16:30:56' AND e.DeviceLoginName='358021081803706' 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>='2025-04-28 06:30:56' AND g.time<='2025-04-28 13:30:56' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:994 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 6:35:57' AND e.date<='2025-04-28 16:35:57' 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>='2025-04-28 03:35:57' AND g.time<='2025-04-28 13:35:57' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:899 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-21 0:39:18' AND e.date<='2025-04-25 23:39:18' AND e.DeviceLoginName='354836080405763' 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>='2025-04-20 21:39:18' AND g.time<='2025-04-25 20:39:18' AND g.DeviceLoginName='354836080405763' GROUP BY g.time, g.Distance; CountAzimuth:3260 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-28 6:52:3' AND e.date<='2025-04-28 16:52:3' 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>='2025-04-28 03:52:03' AND g.time<='2025-04-28 13:52:03' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:970