Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-01 7:30:19' AND e.date<='2024-08-18 9:30:19' AND e.DeviceLoginName='356078116281466' 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-08-01 04:30:19' AND g.time<='2024-08-18 06:30:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:4736 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-01 7:30:19' AND e.date<='2024-08-18 23:30:19' AND e.DeviceLoginName='356078116281466' 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-08-01 04:30:19' AND g.time<='2024-08-18 20:30:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:4736 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-19 0:32:44' AND e.date<='2024-08-23 23:32:44' AND e.DeviceLoginName='356078118085444' 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-08-18 21:32:44' AND g.time<='2024-08-23 20:32:44' AND g.DeviceLoginName='356078118085444' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-01 7:30:19' AND e.date<='2024-08-01 23:30:19' AND e.DeviceLoginName='356078116281466' 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-08-01 04:30:19' AND g.time<='2024-08-01 20:30:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:743 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-05 7:30:19' AND e.date<='2024-08-05 23:30:19' AND e.DeviceLoginName='356078116281466' 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-08-05 04:30:19' AND g.time<='2024-08-05 20:30:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:333 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-06 7:30:19' AND e.date<='2024-08-06 23:30:19' AND e.DeviceLoginName='356078116281466' 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-08-06 04:30:19' AND g.time<='2024-08-06 20:30:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:361 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-07 7:30:19' AND e.date<='2024-08-07 23:30:19' AND e.DeviceLoginName='356078116281466' 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-08-07 04:30:19' AND g.time<='2024-08-07 20:30:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:409 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-08 7:30:19' AND e.date<='2024-08-08 23:30:19' AND e.DeviceLoginName='356078116281466' 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-08-08 04:30:19' AND g.time<='2024-08-08 20:30:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:41 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-08 6:30:19' AND e.date<='2024-08-08 23:55:19' AND e.DeviceLoginName='356078116281466' 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-08-08 03:30:19' AND g.time<='2024-08-08 20:55:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:41 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-19 0:32:44' AND e.date<='2024-08-23 23:32:44' AND e.DeviceLoginName='2871' 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-08-18 21:32:44' AND g.time<='2024-08-23 20:32:44' AND g.DeviceLoginName='2871' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-10 6:30:19' AND e.date<='2024-08-10 23:55:19' AND e.DeviceLoginName='356078116281466' 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-08-10 03:30:19' AND g.time<='2024-08-10 20:55:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:85 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-11 6:30:19' AND e.date<='2024-08-11 23:55:19' AND e.DeviceLoginName='356078116281466' 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-08-11 03:30:19' AND g.time<='2024-08-11 20:55:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:417 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-12 6:30:19' AND e.date<='2024-08-12 23:55:19' AND e.DeviceLoginName='356078116281466' 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-08-12 03:30:19' AND g.time<='2024-08-12 20:55:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:558 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-13 6:30:19' AND e.date<='2024-08-13 23:55:19' AND e.DeviceLoginName='356078116281466' 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-08-13 03:30:19' AND g.time<='2024-08-13 20:55:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:477 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-14 6:30:19' AND e.date<='2024-08-14 23:55:19' AND e.DeviceLoginName='356078116281466' 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-08-14 03:30:19' AND g.time<='2024-08-14 20:55:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:228 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-15 6:30:19' AND e.date<='2024-08-15 23:55:19' AND e.DeviceLoginName='356078116281466' 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-08-15 03:30:19' AND g.time<='2024-08-15 20:55:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:878 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-17 6:30:19' AND e.date<='2024-08-17 23:55:19' AND e.DeviceLoginName='356078116281466' 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-08-17 03:30:19' AND g.time<='2024-08-17 20:55:19' AND g.DeviceLoginName='356078116281466' GROUP BY g.time, g.Distance; CountAzimuth:206 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 2:59:44' AND e.date<='2024-08-27 9:59:44' 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-08-26 23:59:44' AND g.time<='2024-08-27 06:59:44' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:264 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 2:3:1' AND e.date<='2024-08-27 10:3:1' 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-08-26 23:03:01' AND g.time<='2024-08-27 07:03:01' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:264 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 0:7:19' AND e.date<='2024-08-27 23:7:19' AND e.DeviceLoginName='2871' 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-08-25 21:07:19' AND g.time<='2024-08-27 20:07:19' AND g.DeviceLoginName='2871' GROUP BY g.time, g.Distance; CountAzimuth:4 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 0:7:19' AND e.date<='2024-08-27 23:7:19' AND e.DeviceLoginName='3203' 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-08-25 21:07:19' AND g.time<='2024-08-27 20:07:19' AND g.DeviceLoginName='3203' GROUP BY g.time, g.Distance; CountAzimuth:640 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 0:8:24' AND e.date<='2024-08-27 14:8:24' 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-08-26 21:08:24' AND g.time<='2024-08-27 11:08:24' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:358 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 8:8:58' AND e.date<='2024-08-27 12:8:58' 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-08-27 05:08:58' AND g.time<='2024-08-27 09:08:58' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:105 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 6:49:14' AND e.date<='2024-08-27 12:49:14' 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-08-27 03:49:14' AND g.time<='2024-08-27 09:49:14' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:290 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-19 23:0:0' AND e.date<='2024-08-20 5:0:0' AND e.DeviceLoginName='356078118074109' 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-08-19 20:00:00' AND g.time<='2024-08-20 02:00:00' AND g.DeviceLoginName='356078118074109' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-19 23:0:0' AND e.date<='2024-08-20 5:0:0' AND e.DeviceLoginName='2783' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-08-19 20:00:00' AND g.time<='2024-08-20 02:00:00' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:113 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-19 23:0:0' AND e.date<='2024-08-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-08-19 20:00:00' AND g.time<='2024-08-20 02:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:342 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-19 23:0:0' AND e.date<='2024-08-20 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-08-19 20:00:00' AND g.time<='2024-08-20 02:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:253 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-19 23:0:0' AND e.date<='2024-08-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-08-19 20:00:00' AND g.time<='2024-08-20 02:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:149 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-19 23:0:0' AND e.date<='2024-08-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-08-19 20:00:00' AND g.time<='2024-08-20 02:00:00' AND g.DeviceLoginName='2584' GROUP BY g.time, g.Distance; CountAzimuth:90 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 23:0:0' AND e.date<='2024-08-21 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-08-20 20:00:00' AND g.time<='2024-08-21 02:00:00' AND g.DeviceLoginName='9376' GROUP BY g.time, g.Distance; CountAzimuth:146 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 23:0:0' AND e.date<='2024-08-21 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-08-20 20:00:00' AND g.time<='2024-08-21 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:280 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 23:0:0' AND e.date<='2024-08-21 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-08-20 20:00:00' AND g.time<='2024-08-21 02:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:4 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 23:0:0' AND e.date<='2024-08-21 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-08-20 20:00:00' AND g.time<='2024-08-21 02:00:00' AND g.DeviceLoginName='2947' GROUP BY g.time, g.Distance; CountAzimuth:60 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 23:0:0' AND e.date<='2024-08-21 5:0:0' AND e.DeviceLoginName='2504' 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-08-20 20:00:00' AND g.time<='2024-08-21 02:00:00' AND g.DeviceLoginName='2504' GROUP BY g.time, g.Distance; CountAzimuth:50 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 23:0:0' AND e.date<='2024-08-21 5:0:0' AND e.DeviceLoginName='2735' 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-08-20 20:00:00' AND g.time<='2024-08-21 02:00:00' AND g.DeviceLoginName='2735' GROUP BY g.time, g.Distance; CountAzimuth:55 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 23:0:0' AND e.date<='2024-08-21 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-08-20 20:00:00' AND g.time<='2024-08-21 02:00:00' AND g.DeviceLoginName='2584' GROUP BY g.time, g.Distance; CountAzimuth:83 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 23:0:0' AND e.date<='2024-08-21 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>='2024-08-20 20:00:00' AND g.time<='2024-08-21 02:00:00' AND g.DeviceLoginName='3197' GROUP BY g.time, g.Distance; CountAzimuth:123 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-20 23:0:0' AND e.date<='2024-08-21 5:0:0' AND e.DeviceLoginName='2752' 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-08-20 20:00:00' AND g.time<='2024-08-21 02:00:00' AND g.DeviceLoginName='2752' GROUP BY g.time, g.Distance; CountAzimuth:34 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 23:0:0' AND e.date<='2024-08-22 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>='2024-08-21 20:00:00' AND g.time<='2024-08-22 02:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:23 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 23:0:0' AND e.date<='2024-08-22 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-08-21 20:00:00' AND g.time<='2024-08-22 02:00:00' AND g.DeviceLoginName='3081' GROUP BY g.time, g.Distance; CountAzimuth:71 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 23:0:0' AND e.date<='2024-08-22 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-08-21 20:00:00' AND g.time<='2024-08-22 02:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:165 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 23:0:0' AND e.date<='2024-08-22 5:0:0' AND e.DeviceLoginName='3091' 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-08-21 20:00:00' AND g.time<='2024-08-22 02:00:00' AND g.DeviceLoginName='3091' GROUP BY g.time, g.Distance; CountAzimuth:8 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 23:0:0' AND e.date<='2024-08-22 5:0:0' AND e.DeviceLoginName='2454' 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-08-21 20:00:00' AND g.time<='2024-08-22 02:00:00' AND g.DeviceLoginName='2454' GROUP BY g.time, g.Distance; CountAzimuth:84 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 23:0:0' AND e.date<='2024-08-22 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-08-21 20:00:00' AND g.time<='2024-08-22 02:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:225 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-21 23:0:0' AND e.date<='2024-08-22 5:0:0' AND e.DeviceLoginName='2735' 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-08-21 20:00:00' AND g.time<='2024-08-22 02:00:00' AND g.DeviceLoginName='2735' GROUP BY g.time, g.Distance; CountAzimuth:50 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-22 23:0:0' AND e.date<='2024-08-23 5:0:0' AND e.DeviceLoginName='4846' 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-08-22 20:00:00' AND g.time<='2024-08-23 02:00:00' AND g.DeviceLoginName='4846' GROUP BY g.time, g.Distance; CountAzimuth:178 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-22 23:0:0' AND e.date<='2024-08-23 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-08-22 20:00:00' AND g.time<='2024-08-23 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:186 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-22 23:0:0' AND e.date<='2024-08-23 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-08-22 20:00:00' AND g.time<='2024-08-23 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-08-22 23:0:0' AND e.date<='2024-08-23 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-08-22 20:00:00' AND g.time<='2024-08-23 02:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:302 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-22 23:0:0' AND e.date<='2024-08-23 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-08-22 20:00:00' AND g.time<='2024-08-23 02:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:30 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-22 23:0:0' AND e.date<='2024-08-23 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-08-22 20:00:00' AND g.time<='2024-08-23 02:00:00' AND g.DeviceLoginName='3156' GROUP BY g.time, g.Distance; CountAzimuth:271 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-22 23:0:0' AND e.date<='2024-08-23 5:0:0' AND e.DeviceLoginName='2735' 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-08-22 20:00:00' AND g.time<='2024-08-23 02:00:00' AND g.DeviceLoginName='2735' GROUP BY g.time, g.Distance; CountAzimuth:50 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-23 23:0:0' AND e.date<='2024-08-24 5:0:0' AND e.DeviceLoginName='4846' 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-08-23 20:00:00' AND g.time<='2024-08-24 02:00:00' AND g.DeviceLoginName='4846' GROUP BY g.time, g.Distance; CountAzimuth:201 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-23 23:0:0' AND e.date<='2024-08-24 5:0:0' AND e.DeviceLoginName='3079' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-08-23 20:00:00' AND g.time<='2024-08-24 02:00:00' AND g.DeviceLoginName='3079' GROUP BY g.time, g.Distance; CountAzimuth:8 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-23 23:0:0' AND e.date<='2024-08-24 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-08-23 20:00:00' AND g.time<='2024-08-24 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:430 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-23 23:0:0' AND e.date<='2024-08-24 5:0:0' AND e.DeviceLoginName='5078' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-08-23 20:00:00' AND g.time<='2024-08-24 02:00:00' AND g.DeviceLoginName='5078' GROUP BY g.time, g.Distance; CountAzimuth:26 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-23 23:0:0' AND e.date<='2024-08-24 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-08-23 20:00:00' AND g.time<='2024-08-24 02:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:5 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-23 23:0:0' AND e.date<='2024-08-24 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-08-23 20:00:00' AND g.time<='2024-08-24 02:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:159 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-23 23:0:0' AND e.date<='2024-08-24 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-08-23 20:00:00' AND g.time<='2024-08-24 02:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:67 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-23 23:0:0' AND e.date<='2024-08-24 5:0:0' AND e.DeviceLoginName='352353085652458' 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-08-23 20:00:00' AND g.time<='2024-08-24 02:00:00' AND g.DeviceLoginName='352353085652458' GROUP BY g.time, g.Distance; CountAzimuth:117 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-23 23:0:0' AND e.date<='2024-08-24 5:0:0' AND e.DeviceLoginName='352353086171979' 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-08-23 20:00:00' AND g.time<='2024-08-24 02:00:00' AND g.DeviceLoginName='352353086171979' GROUP BY g.time, g.Distance; CountAzimuth:157 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-23 23:0:0' AND e.date<='2024-08-24 5:0:0' AND e.DeviceLoginName='2735' 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-08-23 20:00:00' AND g.time<='2024-08-24 02:00:00' AND g.DeviceLoginName='2735' GROUP BY g.time, g.Distance; CountAzimuth:48 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 0:56:6' AND e.date<='2024-08-27 14:56:6' AND e.DeviceLoginName='3178' 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-08-25 21:56:06' AND g.time<='2024-08-27 11:56:06' AND g.DeviceLoginName='3178' GROUP BY g.time, g.Distance; CountAzimuth:2348 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-24 23:0:0' AND e.date<='2024-08-25 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-08-24 20:00:00' AND g.time<='2024-08-25 02:00:00' AND g.DeviceLoginName='9376' GROUP BY g.time, g.Distance; CountAzimuth:170 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-24 23:0:0' AND e.date<='2024-08-25 5:0:0' AND e.DeviceLoginName='2565' 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-08-24 20:00:00' AND g.time<='2024-08-25 02:00:00' AND g.DeviceLoginName='2565' GROUP BY g.time, g.Distance; CountAzimuth:373 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-24 23:0:0' AND e.date<='2024-08-25 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-08-24 20:00:00' AND g.time<='2024-08-25 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:261 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-24 23:0:0' AND e.date<='2024-08-25 5:0:0' AND e.DeviceLoginName='9004' 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-08-24 20:00:00' AND g.time<='2024-08-25 02:00:00' AND g.DeviceLoginName='9004' GROUP BY g.time, g.Distance; CountAzimuth:364 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-24 23:0:0' AND e.date<='2024-08-25 5:0:0' AND e.DeviceLoginName='2974' 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-08-24 20:00:00' AND g.time<='2024-08-25 02:00:00' AND g.DeviceLoginName='2974' GROUP BY g.time, g.Distance; CountAzimuth:136 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-24 23:0:0' AND e.date<='2024-08-25 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-08-24 20:00:00' AND g.time<='2024-08-25 02:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:5 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-24 23:0:0' AND e.date<='2024-08-25 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-08-24 20:00:00' AND g.time<='2024-08-25 02:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:229 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-24 23:0:0' AND e.date<='2024-08-25 5:0:0' AND e.DeviceLoginName='4868' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-08-24 20:00:00' AND g.time<='2024-08-25 02:00:00' AND g.DeviceLoginName='4868' GROUP BY g.time, g.Distance; CountAzimuth:148 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-25 23:0:0' AND e.date<='2024-08-26 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-08-25 20:00:00' AND g.time<='2024-08-26 02:00:00' AND g.DeviceLoginName='9376' GROUP BY g.time, g.Distance; CountAzimuth:201 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-25 23:0:0' AND e.date<='2024-08-26 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>='2024-08-25 20:00:00' AND g.time<='2024-08-26 02:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:23 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-25 23:0:0' AND e.date<='2024-08-26 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-08-25 20:00:00' AND g.time<='2024-08-26 02:00:00' AND g.DeviceLoginName='3123' GROUP BY g.time, g.Distance; CountAzimuth:330 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-25 23:0:0' AND e.date<='2024-08-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>='2024-08-25 20:00:00' AND g.time<='2024-08-26 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:354 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-25 23:0:0' AND e.date<='2024-08-26 5:0:0' AND e.DeviceLoginName='2913' 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-08-25 20:00:00' AND g.time<='2024-08-26 02:00:00' AND g.DeviceLoginName='2913' GROUP BY g.time, g.Distance; CountAzimuth:19 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-25 23:0:0' AND e.date<='2024-08-26 5:0:0' AND e.DeviceLoginName='5080' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-08-25 20:00:00' AND g.time<='2024-08-26 02:00:00' AND g.DeviceLoginName='5080' GROUP BY g.time, g.Distance; CountAzimuth:103 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-25 23:0:0' AND e.date<='2024-08-26 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-08-25 20:00:00' AND g.time<='2024-08-26 02:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY g.time, g.Distance; CountAzimuth:63 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-25 23:0:0' AND e.date<='2024-08-26 5:0:0' AND e.DeviceLoginName='2633' 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-08-25 20:00:00' AND g.time<='2024-08-26 02:00:00' AND g.DeviceLoginName='2633' GROUP BY g.time, g.Distance; CountAzimuth:14 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-25 23:0:0' AND e.date<='2024-08-26 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-08-25 20:00:00' AND g.time<='2024-08-26 02:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:287 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-25 23:0:0' AND e.date<='2024-08-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>='2024-08-25 20:00:00' AND g.time<='2024-08-26 02:00:00' AND g.DeviceLoginName='2773' GROUP BY g.time, g.Distance; CountAzimuth:44 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-25 23:0:0' AND e.date<='2024-08-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>='2024-08-25 20:00:00' AND g.time<='2024-08-26 02:00:00' AND g.DeviceLoginName='2728' GROUP BY g.time, g.Distance; CountAzimuth:100 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-25 23:0:0' AND e.date<='2024-08-26 5:0:0' AND e.DeviceLoginName='2735' 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-08-25 20:00:00' AND g.time<='2024-08-26 02:00:00' AND g.DeviceLoginName='2735' GROUP BY g.time, g.Distance; CountAzimuth:43 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-25 23:0:0' AND e.date<='2024-08-26 5:0:0' AND e.DeviceLoginName='2466' 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-08-25 20:00:00' AND g.time<='2024-08-26 02:00:00' AND g.DeviceLoginName='2466' GROUP BY g.time, g.Distance; CountAzimuth:71 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 0:26:42' AND e.date<='2024-08-27 16:26:42' AND e.DeviceLoginName='356078118082904' 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-08-26 21:26:42' AND g.time<='2024-08-27 13:26:42' AND g.DeviceLoginName='356078118082904' GROUP BY g.time, g.Distance; CountAzimuth:1572