Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 0:45:14' AND e.date<='2024-04-15 8:45: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-04-12 21:45:14' AND g.time<='2024-04-15 05:45:14' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:747 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-09 0:49:47' AND e.date<='2024-04-09 23:49:47' AND e.DeviceLoginName='9382' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-08 21:49:47' AND g.time<='2024-04-09 20:49:47' AND g.DeviceLoginName='9382' GROUP BY g.time, g.Distance; CountAzimuth:4112 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-09 0:49:47' AND e.date<='2024-04-09 23:49:47' AND e.DeviceLoginName='2557' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-08 21:49:47' AND g.time<='2024-04-09 20:49:47' AND g.DeviceLoginName='2557' GROUP BY g.time, g.Distance; CountAzimuth:6667 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 0:49:47' AND e.date<='2024-04-12 23:49:47' AND e.DeviceLoginName='9018' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-11 21:49:47' AND g.time<='2024-04-12 20:49:47' AND g.DeviceLoginName='9018' GROUP BY g.time, g.Distance; CountAzimuth:5519 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-09 0:49:47' AND e.date<='2024-04-09 23:49:47' AND e.DeviceLoginName='3028' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-08 21:49:47' AND g.time<='2024-04-09 20:49:47' AND g.DeviceLoginName='3028' GROUP BY g.time, g.Distance; CountAzimuth:4673 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 0:49:47' AND e.date<='2024-04-13 23:49:47' 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-04-12 21:49:47' AND g.time<='2024-04-13 20:49:47' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:1348 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-09 0:49:47' AND e.date<='2024-04-09 23:49:47' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-08 21:49:47' AND g.time<='2024-04-09 20:49:47' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:2301 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-10 0:49:47' AND e.date<='2024-04-10 23:49:47' AND e.DeviceLoginName='2535' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-09 21:49:47' AND g.time<='2024-04-10 20:49:47' AND g.DeviceLoginName='2535' GROUP BY g.time, g.Distance; CountAzimuth:1559 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 0:49:47' AND e.date<='2024-04-12 23:49:47' 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-04-11 21:49:47' AND g.time<='2024-04-12 20:49:47' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:2029 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-09 0:49:47' AND e.date<='2024-04-09 23:49:47' AND e.DeviceLoginName='3028' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-08 21:49:47' AND g.time<='2024-04-09 20:49:47' AND g.DeviceLoginName='3028' GROUP BY g.time, g.Distance; CountAzimuth:4673 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 1:4:10' AND e.date<='2024-04-15 9:4:10' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-12 22:04:10' AND g.time<='2024-04-15 06:04:10' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:238 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-01 0:49:47' AND e.date<='2024-04-09 23:49:47' AND e.DeviceLoginName='2883' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-31 21:49:47' AND g.time<='2024-04-09 20:49:47' AND g.DeviceLoginName='2883' GROUP BY g.time, g.Distance; CountAzimuth:36015 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-08 0:2:49' AND e.date<='2024-04-08 23:2:49' AND e.DeviceLoginName='9008' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-07 21:02:49' AND g.time<='2024-04-08 20:02:49' AND g.DeviceLoginName='9008' GROUP BY g.time, g.Distance; CountAzimuth:1475 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-09 0:2:49' AND e.date<='2024-04-09 23:2:49' AND e.DeviceLoginName='9008' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-08 21:02:49' AND g.time<='2024-04-09 20:02:49' AND g.DeviceLoginName='9008' GROUP BY g.time, g.Distance; CountAzimuth:563 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-10 0:2:49' AND e.date<='2024-04-10 23:2:49' AND e.DeviceLoginName='9008' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-09 21:02:49' AND g.time<='2024-04-10 20:02:49' AND g.DeviceLoginName='9008' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-11 0:2:49' AND e.date<='2024-04-11 23:2:49' AND e.DeviceLoginName='9008' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-10 21:02:49' AND g.time<='2024-04-11 20:02:49' AND g.DeviceLoginName='9008' GROUP BY g.time, g.Distance; CountAzimuth:5 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 0:2:49' AND e.date<='2024-04-12 23:2:49' AND e.DeviceLoginName='9008' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-11 21:02:49' AND g.time<='2024-04-12 20:02:49' AND g.DeviceLoginName='9008' GROUP BY g.time, g.Distance; CountAzimuth:6 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-15 7:35:46' AND e.date<='2024-04-15 11:35:46' 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-04-15 04:35:46' AND g.time<='2024-04-15 08:35:46' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:317 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-15 0:14:30' AND e.date<='2024-04-15 12:14:30' 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-04-14 21:14:30' AND g.time<='2024-04-15 09:14:30' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:584 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 23:0:0' AND e.date<='2024-04-13 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-04-12 20:00:00' AND g.time<='2024-04-13 02:00:00' AND g.DeviceLoginName='3079' GROUP BY g.time, g.Distance; CountAzimuth:134 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 23:0:0' AND e.date<='2024-04-13 5:0:0' AND e.DeviceLoginName='2966' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-12 20:00:00' AND g.time<='2024-04-13 02:00:00' AND g.DeviceLoginName='2966' GROUP BY g.time, g.Distance; CountAzimuth:16 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 23:0:0' AND e.date<='2024-04-13 5:0:0' AND e.DeviceLoginName='9018' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-12 20:00:00' AND g.time<='2024-04-13 02:00:00' AND g.DeviceLoginName='9018' GROUP BY g.time, g.Distance; CountAzimuth:831 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 23:0:0' AND e.date<='2024-04-13 5:0:0' AND e.DeviceLoginName='5082' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-12 20:00:00' AND g.time<='2024-04-13 02:00:00' AND g.DeviceLoginName='5082' GROUP BY g.time, g.Distance; CountAzimuth:54 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 23:0:0' AND e.date<='2024-04-13 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-04-12 20:00:00' AND g.time<='2024-04-13 02:00:00' AND g.DeviceLoginName='2773' GROUP BY g.time, g.Distance; CountAzimuth:332 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 23:0:0' AND e.date<='2024-04-13 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-04-12 20:00:00' AND g.time<='2024-04-13 02:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:241 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 23:0:0' AND e.date<='2024-04-13 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-04-12 20:00:00' AND g.time<='2024-04-13 02:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:420 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 23:0:0' AND e.date<='2024-04-13 5:0:0' AND e.DeviceLoginName='352353085630363' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-12 20:00:00' AND g.time<='2024-04-13 02:00:00' AND g.DeviceLoginName='352353085630363' GROUP BY g.time, g.Distance; CountAzimuth:320 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 23:0:0' AND e.date<='2024-04-13 5:0:0' AND e.DeviceLoginName='353173060497698' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-12 20:00:00' AND g.time<='2024-04-13 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY g.time, g.Distance; CountAzimuth:244 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 23:0:0' AND e.date<='2024-04-13 5:0:0' AND e.DeviceLoginName='352353084344826' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-12 20:00:00' AND g.time<='2024-04-13 02:00:00' AND g.DeviceLoginName='352353084344826' GROUP BY g.time, g.Distance; CountAzimuth:154 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 23:0:0' AND e.date<='2024-04-13 5:0:0' AND e.DeviceLoginName='352353083500956' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-12 20:00:00' AND g.time<='2024-04-13 02:00:00' AND g.DeviceLoginName='352353083500956' GROUP BY g.time, g.Distance; CountAzimuth:36 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 23:0:0' AND e.date<='2024-04-14 5:0:0' AND e.DeviceLoginName='9010' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-13 20:00:00' AND g.time<='2024-04-14 02:00:00' AND g.DeviceLoginName='9010' GROUP BY g.time, g.Distance; CountAzimuth:113 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 23:0:0' AND e.date<='2024-04-14 5:0:0' AND e.DeviceLoginName='8997' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-13 20:00:00' AND g.time<='2024-04-14 02:00:00' AND g.DeviceLoginName='8997' GROUP BY g.time, g.Distance; CountAzimuth:675 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 23:0:0' AND e.date<='2024-04-14 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-04-13 20:00:00' AND g.time<='2024-04-14 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:351 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 23:0:0' AND e.date<='2024-04-14 5:0:0' AND e.DeviceLoginName='2729' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-13 20:00:00' AND g.time<='2024-04-14 02:00:00' AND g.DeviceLoginName='2729' GROUP BY g.time, g.Distance; CountAzimuth:94 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-19 0:0:0' AND e.date<='2024-02-19 23:0:0' AND e.DeviceLoginName='356078111277071' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-18 21:00:00' AND g.time<='2024-02-19 20:00:00' AND g.DeviceLoginName='356078111277071' GROUP BY g.time, g.Distance; CountAzimuth:146 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-20 0:0:0' AND e.date<='2024-02-20 23:0:0' AND e.DeviceLoginName='356078111277071' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-19 21:00:00' AND g.time<='2024-02-20 20:00:00' AND g.DeviceLoginName='356078111277071' GROUP BY g.time, g.Distance; CountAzimuth:825 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 23:0:0' AND e.date<='2024-04-14 5:0:0' AND e.DeviceLoginName='3188' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-13 20:00:00' AND g.time<='2024-04-14 02:00:00' AND g.DeviceLoginName='3188' GROUP BY g.time, g.Distance; CountAzimuth:30 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 23:0:0' AND e.date<='2024-04-14 5:0:0' AND e.DeviceLoginName='352353084314407' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-13 20:00:00' AND g.time<='2024-04-14 02:00:00' AND g.DeviceLoginName='352353084314407' GROUP BY g.time, g.Distance; CountAzimuth:141 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 23:0:0' AND e.date<='2024-04-14 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-04-13 20:00:00' AND g.time<='2024-04-14 02:00:00' AND g.DeviceLoginName='2773' GROUP BY g.time, g.Distance; CountAzimuth:240 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 23:0:0' AND e.date<='2024-04-14 5:0:0' AND e.DeviceLoginName='2470' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-13 20:00:00' AND g.time<='2024-04-14 02:00:00' AND g.DeviceLoginName='2470' GROUP BY g.time, g.Distance; CountAzimuth:253 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 23:0:0' AND e.date<='2024-04-14 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-04-13 20:00:00' AND g.time<='2024-04-14 02:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:504 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 23:0:0' AND e.date<='2024-04-14 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-04-13 20:00:00' AND g.time<='2024-04-14 02:00:00' AND g.DeviceLoginName='3156' GROUP BY g.time, g.Distance; CountAzimuth:126 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 23:0:0' AND e.date<='2024-04-14 5:0:0' AND e.DeviceLoginName='8983' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-13 20:00:00' AND g.time<='2024-04-14 02:00:00' AND g.DeviceLoginName='8983' GROUP BY g.time, g.Distance; CountAzimuth:254 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-14 23:0:0' AND e.date<='2024-04-15 5:0:0' AND e.DeviceLoginName='2652' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-14 20:00:00' AND g.time<='2024-04-15 02:00:00' AND g.DeviceLoginName='2652' GROUP BY g.time, g.Distance; CountAzimuth:82 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-14 23:0:0' AND e.date<='2024-04-15 5:0:0' AND e.DeviceLoginName='4849' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-14 20:00:00' AND g.time<='2024-04-15 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:176 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-14 23:0:0' AND e.date<='2024-04-15 5:0:0' AND e.DeviceLoginName='353173060487970' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-14 20:00:00' AND g.time<='2024-04-15 02:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY g.time, g.Distance; CountAzimuth:107 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-14 23:0:0' AND e.date<='2024-04-15 5:0:0' AND e.DeviceLoginName='2789' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-14 20:00:00' AND g.time<='2024-04-15 02:00:00' AND g.DeviceLoginName='2789' GROUP BY g.time, g.Distance; CountAzimuth:115 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-14 23:0:0' AND e.date<='2024-04-15 5:0:0' AND e.DeviceLoginName='8993' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-14 20:00:00' AND g.time<='2024-04-15 02:00:00' AND g.DeviceLoginName='8993' GROUP BY g.time, g.Distance; CountAzimuth:52 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-14 23:0:0' AND e.date<='2024-04-15 5:0:0' 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-04-14 20:00:00' AND g.time<='2024-04-15 02:00:00' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:351 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-14 23:0:0' AND e.date<='2024-04-15 5:0:0' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-14 20:00:00' AND g.time<='2024-04-15 02:00:00' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:10 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-14 23:0:0' AND e.date<='2024-04-15 5:0:0' AND e.DeviceLoginName='2676' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-14 20:00:00' AND g.time<='2024-04-15 02:00:00' AND g.DeviceLoginName='2676' GROUP BY g.time, g.Distance; CountAzimuth:31 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-14 23:0:0' AND e.date<='2024-04-15 5:0:0' AND e.DeviceLoginName='4865' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-14 20:00:00' AND g.time<='2024-04-15 02:00:00' AND g.DeviceLoginName='4865' GROUP BY g.time, g.Distance; CountAzimuth:56 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-14 23:0:0' AND e.date<='2024-04-15 5:0:0' AND e.DeviceLoginName='2964' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-14 20:00:00' AND g.time<='2024-04-15 02:00:00' AND g.DeviceLoginName='2964' GROUP BY g.time, g.Distance; CountAzimuth:17 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-19 0:0:0' AND e.date<='2024-03-24 23:0:0' AND e.DeviceLoginName='356078111277071' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-18 21:00:00' AND g.time<='2024-03-24 20:00:00' AND g.DeviceLoginName='356078111277071' GROUP BY g.time, g.Distance; CountAzimuth:15271 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-02 0:0:0' AND e.date<='2024-03-02 23:0:0' AND e.DeviceLoginName='356078111277071' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-03-01 21:00:00' AND g.time<='2024-03-02 20:00:00' AND g.DeviceLoginName='356078111277071' GROUP BY g.time, g.Distance; CountAzimuth:336 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-01 0:0:0' AND e.date<='2024-03-02 23:0:0' AND e.DeviceLoginName='356078111277071' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-02-29 21:00:00' AND g.time<='2024-03-02 20:00:00' AND g.DeviceLoginName='356078111277071' GROUP BY g.time, g.Distance; CountAzimuth:929 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-15 0:10:24' AND e.date<='2024-04-15 14:10: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-04-14 21:10:24' AND g.time<='2024-04-15 11:10:24' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:640 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-15 6:10:58' AND e.date<='2024-04-15 14:10:58' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-15 03:10:58' AND g.time<='2024-04-15 11:10:58' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:377 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-25 0:20:29' AND e.date<='2024-04-15 14:20:29' AND e.DeviceLoginName='4884' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-24 21:20:29' AND g.time<='2024-04-15 11:20:29' AND g.DeviceLoginName='4884' GROUP BY g.time, g.Distance; CountAzimuth:10039 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-15 2:20:40' AND e.date<='2024-04-15 16:20:40' AND e.DeviceLoginName='356078111301566' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-04-14 23:20:40' AND g.time<='2024-04-15 13:20:40' AND g.DeviceLoginName='356078111301566' GROUP BY g.time, g.Distance; CountAzimuth:995