Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 20:51:47' AND e.date<='2024-10-04 7:51:47' AND e.DeviceLoginName='356078111469876' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-03 17:51:47' AND g.time<='2024-10-04 04:51:47' AND g.DeviceLoginName='356078111469876' GROUP BY g.time, g.Distance; CountAzimuth:5 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 17:51:47' AND e.date<='2024-10-04 7:51:47' AND e.DeviceLoginName='356078111469876' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-03 14:51:47' AND g.time<='2024-10-04 04:51:47' AND g.DeviceLoginName='356078111469876' GROUP BY g.time, g.Distance; CountAzimuth:7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 15:51:47' AND e.date<='2024-10-04 7:51:47' AND e.DeviceLoginName='356078111469876' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-03 12:51:47' AND g.time<='2024-10-04 04:51:47' AND g.DeviceLoginName='356078111469876' GROUP BY g.time, g.Distance; CountAzimuth:329 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 0:50:38' AND e.date<='2024-10-01 23:50:38' AND e.DeviceLoginName='2846' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09-30 21:50:38' AND g.time<='2024-10-01 20:50:38' AND g.DeviceLoginName='2846' GROUP BY g.time, g.Distance; CountAzimuth:636 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 0:50:38' AND e.date<='2024-10-02 23:50:38' AND e.DeviceLoginName='2846' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-01 21:50:38' AND g.time<='2024-10-02 20:50:38' AND g.DeviceLoginName='2846' GROUP BY g.time, g.Distance; CountAzimuth:1041 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 0:54:23' AND e.date<='2024-10-03 23:54:23' 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-10-02 21:54:23' AND g.time<='2024-10-03 20:54:23' AND g.DeviceLoginName='356078118082904' GROUP BY g.time, g.Distance; CountAzimuth:697 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-04 0:54:23' AND e.date<='2024-10-04 23:54:23' 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-10-03 21:54:23' AND g.time<='2024-10-04 20:54:23' AND g.DeviceLoginName='356078118082904' GROUP BY g.time, g.Distance; CountAzimuth:440 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 0:54:23' AND e.date<='2024-09-29 23:54:23' AND e.DeviceLoginName='2623' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09-22 21:54:23' AND g.time<='2024-09-29 20:54:23' AND g.DeviceLoginName='2623' GROUP BY g.time, g.Distance; CountAzimuth:2388 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-23 0:54:23' AND e.date<='2024-09-29 23:54:23' AND e.DeviceLoginName='2623' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09-22 21:54:23' AND g.time<='2024-09-29 20:54:23' AND g.DeviceLoginName='2623' GROUP BY g.time, g.Distance; CountAzimuth:2388 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 0:38:7' AND e.date<='2024-10-03 23:59:7' AND e.DeviceLoginName='358021081838710' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 21:38:07' AND g.time<='2024-10-03 20:59:07' AND g.DeviceLoginName='358021081838710' GROUP BY g.time, g.Distance; CountAzimuth:4147 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>='2024-10-03 21:00:00' AND g.time<='2024-10-04 07:39:10' AND g.DeviceLoginName='358021081838710' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='358021081838710' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 21:00:00' AND e.date<='2024-10-04 07:39:10' Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 0:39:11' AND e.date<='2024-10-03 23:39:11' AND e.DeviceLoginName='358021081838710' AND e.EventType=7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 19:39:17' AND e.date<='2024-10-04 10:39:17' AND e.DeviceLoginName='358021081838710' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-03 16:39:17' AND g.time<='2024-10-04 07:39:17' AND g.DeviceLoginName='358021081838710' GROUP BY g.time, g.Distance; CountAzimuth:325 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 21:39:11' AND g.time<='2024-10-03 20:39:11' AND g.DeviceLoginName='358021081838710' GROUP BY g.time, g.Distance; CountAzimuth:4147 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 21:45:24' AND e.date<='2024-10-03 23:45:24' AND e.DeviceLoginName='AI3421' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-03 18:45:24' AND g.time<='2024-10-03 20:45:24' AND g.DeviceLoginName='AI3421' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 19:45:24' AND e.date<='2024-10-03 23:45:24' AND e.DeviceLoginName='AI3421HP' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-03 16:45:24' AND g.time<='2024-10-03 20:45:24' AND g.DeviceLoginName='AI3421HP' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 0:46:27' AND e.date<='2024-10-03 23:46:27' AND e.DeviceLoginName='358021081838710' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 21:46:27' AND g.time<='2024-10-03 20:46:27' AND g.DeviceLoginName='358021081838710' GROUP BY g.time, g.Distance; CountAzimuth:4147 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>='2024-10-03 21:00:00' AND g.time<='2024-10-04 08:17:23' AND g.DeviceLoginName='352353083473741' Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-04 05:07:11' AND TIME<='2024-10-04 05:17:11' AND DeviceLoginName='352353083473741' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-04 05:13:06' AND TIME<='2024-10-04 05:23:06' AND DeviceLoginName='352353083473741' AND speed=0 Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353083473741' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 21:00:00' AND e.date<='2024-10-04 08:17:23' Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-04 05:07:11' AND TIME<='2024-10-04 05:17:11' AND DeviceLoginName='352353083473741' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-10-04 05:13:06' AND TIME<='2024-10-04 05:23:06' AND DeviceLoginName='352353083473741' AND speed=0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 0:24:22' AND e.date<='2024-09-30 23:24:22' AND e.DeviceLoginName='352353086180491' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09-29 21:24:22' AND g.time<='2024-09-30 20:24:22' AND g.DeviceLoginName='352353086180491' GROUP BY g.time, g.Distance; CountAzimuth:1600 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 0:29:14' AND e.date<='2024-09-30 23:29:14' AND e.DeviceLoginName='352353086182380' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09-29 21:29:14' AND g.time<='2024-09-30 20:29:14' AND g.DeviceLoginName='352353086182380' GROUP BY g.time, g.Distance; CountAzimuth:1056 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>='2024-10-03 21:00:00' AND g.time<='2024-10-04 08:32:48' 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>='2024-10-03 21:00:00' AND e.date<='2024-10-04 08:32:48' Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 0:32:42' AND e.date<='2024-10-01 23:32:42' AND e.DeviceLoginName='352353086182380' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09-30 21:32:42' AND g.time<='2024-10-01 20:32:42' AND g.DeviceLoginName='352353086182380' GROUP BY g.time, g.Distance; CountAzimuth:6 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 0:39:12' AND e.date<='2024-10-02 23:39:12' AND e.DeviceLoginName='352353086182380' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-01 21:39:12' AND g.time<='2024-10-02 20:39:12' AND g.DeviceLoginName='352353086182380' GROUP BY g.time, g.Distance; CountAzimuth:1622 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 23:0:0' AND e.date<='2024-10-01 5:0:0' AND e.DeviceLoginName='3056' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09-30 20:00:00' AND g.time<='2024-10-01 02:00:00' AND g.DeviceLoginName='3056' GROUP BY g.time, g.Distance; CountAzimuth:172 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 23:0:0' AND e.date<='2024-10-01 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-09-30 20:00:00' AND g.time<='2024-10-01 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:190 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 23:0:0' AND e.date<='2024-10-01 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-09-30 20:00:00' AND g.time<='2024-10-01 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-09-30 23:0:0' AND e.date<='2024-10-01 5:0:0' 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>='2024-09-30 20:00:00' AND g.time<='2024-10-01 02:00:00' AND g.DeviceLoginName='2954' GROUP BY g.time, g.Distance; CountAzimuth:274 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 23:0:0' AND e.date<='2024-10-01 5:0:0' AND e.DeviceLoginName='2665' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09-30 20:00:00' AND g.time<='2024-10-01 02:00:00' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:4 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 23:0:0' AND e.date<='2024-10-01 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-09-30 20:00:00' AND g.time<='2024-10-01 02:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:227 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 23:0:0' AND e.date<='2024-10-01 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-09-30 20:00:00' AND g.time<='2024-10-01 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY g.time, g.Distance; CountAzimuth:28 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 23:0:0' AND e.date<='2024-10-01 5:0:0' AND e.DeviceLoginName='2624' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09-30 20:00:00' AND g.time<='2024-10-01 02:00:00' AND g.DeviceLoginName='2624' GROUP BY g.time, g.Distance; CountAzimuth:153 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 23:0:0' AND e.date<='2024-10-01 5:0:0' AND e.DeviceLoginName='2809' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09-30 20:00:00' AND g.time<='2024-10-01 02:00:00' AND g.DeviceLoginName='2809' GROUP BY g.time, g.Distance; CountAzimuth:50 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 23:0:0' AND e.date<='2024-10-01 5:0:0' AND e.DeviceLoginName='352353084150330' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09-30 20:00:00' AND g.time<='2024-10-01 02:00:00' AND g.DeviceLoginName='352353084150330' GROUP BY g.time, g.Distance; CountAzimuth:308 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-30 23:0:0' AND e.date<='2024-10-01 5:0:0' AND e.DeviceLoginName='2888' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.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-09-30 20:00:00' AND g.time<='2024-10-01 02:00:00' AND g.DeviceLoginName='2888' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 23:0:0' AND e.date<='2024-10-02 5:0:0' AND e.DeviceLoginName='4849' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-01 20:00:00' AND g.time<='2024-10-02 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:247 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 23:0:0' AND e.date<='2024-10-02 5:0:0' AND e.DeviceLoginName='2874' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-01 20:00:00' AND g.time<='2024-10-02 02:00:00' AND g.DeviceLoginName='2874' GROUP BY g.time, g.Distance; CountAzimuth:13 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 23:0:0' AND e.date<='2024-10-02 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-10-01 20:00:00' AND g.time<='2024-10-02 02:00:00' AND g.DeviceLoginName='3081' GROUP BY g.time, g.Distance; CountAzimuth:2 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 23:0:0' AND e.date<='2024-10-02 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-10-01 20:00:00' AND g.time<='2024-10-02 02:00:00' AND g.DeviceLoginName='2633' GROUP BY g.time, g.Distance; CountAzimuth:155 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 23:0:0' AND e.date<='2024-10-02 5:0:0' AND e.DeviceLoginName='862531041041535' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-01 20:00:00' AND g.time<='2024-10-02 02:00:00' AND g.DeviceLoginName='862531041041535' GROUP BY g.time, g.Distance; CountAzimuth:58 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 23:0:0' AND e.date<='2024-10-02 5:0:0' AND e.DeviceLoginName='3092' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-01 20:00:00' AND g.time<='2024-10-02 02:00:00' AND g.DeviceLoginName='3092' GROUP BY g.time, g.Distance; CountAzimuth:235 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 23:0:0' AND e.date<='2024-10-02 5:0:0' AND e.DeviceLoginName='2846' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-01 20:00:00' AND g.time<='2024-10-02 02:00:00' AND g.DeviceLoginName='2846' GROUP BY g.time, g.Distance; CountAzimuth:50 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 23:0:0' AND e.date<='2024-10-02 5:0:0' AND e.DeviceLoginName='3061' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-01 20:00:00' AND g.time<='2024-10-02 02:00:00' AND g.DeviceLoginName='3061' GROUP BY g.time, g.Distance; CountAzimuth:51 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 23:0:0' AND e.date<='2024-10-02 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-10-01 20:00:00' AND g.time<='2024-10-02 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY g.time, g.Distance; CountAzimuth:26 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-01 23:0:0' AND e.date<='2024-10-02 5:0:0' AND e.DeviceLoginName='3205' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-01 20:00:00' AND g.time<='2024-10-02 02:00:00' AND g.DeviceLoginName='3205' GROUP BY g.time, g.Distance; CountAzimuth:112 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 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-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='9010' GROUP BY g.time, g.Distance; CountAzimuth:122 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='2554' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='2554' GROUP BY g.time, g.Distance; CountAzimuth:7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='5131' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='5131' GROUP BY g.time, g.Distance; CountAzimuth:121 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='8992' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='8992' GROUP BY g.time, g.Distance; CountAzimuth:147 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='4849' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:140 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 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>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='3238' GROUP BY g.time, g.Distance; CountAzimuth:270 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='3025' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='3025' GROUP BY g.time, g.Distance; CountAzimuth:85 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='4966' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:26 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 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-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='3081' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='862531041050148' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:16 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='3063' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='3063' GROUP BY g.time, g.Distance; CountAzimuth:148 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='3124' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='3124' GROUP BY g.time, g.Distance; CountAzimuth:104 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='2662' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='2662' GROUP BY g.time, g.Distance; CountAzimuth:103 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='352353085616701' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='352353085616701' GROUP BY g.time, g.Distance; CountAzimuth:10 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='4862' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 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>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='3061' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='3061' GROUP BY g.time, g.Distance; CountAzimuth:14 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 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-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY g.time, g.Distance; CountAzimuth:45 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='5132' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='5132' GROUP BY g.time, g.Distance; CountAzimuth:128 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='356078116291259' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='356078116291259' GROUP BY g.time, g.Distance; CountAzimuth:172 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-02 23:0:0' AND e.date<='2024-10-03 5:0:0' AND e.DeviceLoginName='2964' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 20:00:00' AND g.time<='2024-10-03 02:00:00' AND g.DeviceLoginName='2964' GROUP BY g.time, g.Distance; CountAzimuth:22 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 23:0:0' AND e.date<='2024-10-04 5:0:0' AND e.DeviceLoginName='3176' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-03 20:00:00' AND g.time<='2024-10-04 02:00:00' AND g.DeviceLoginName='3176' GROUP BY g.time, g.Distance; CountAzimuth:198 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 23:0:0' AND e.date<='2024-10-04 5:0:0' AND e.DeviceLoginName='4863' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-03 20:00:00' AND g.time<='2024-10-04 02:00:00' AND g.DeviceLoginName='4863' GROUP BY g.time, g.Distance; CountAzimuth:120 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 23:0:0' AND e.date<='2024-10-04 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-10-03 20:00:00' AND g.time<='2024-10-04 02:00:00' AND g.DeviceLoginName='3081' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 23:0:0' AND e.date<='2024-10-04 5:0:0' AND e.DeviceLoginName='4862' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-03 20:00:00' AND g.time<='2024-10-04 02:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:261 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 23:0:0' AND e.date<='2024-10-04 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-10-03 20:00:00' AND g.time<='2024-10-04 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY g.time, g.Distance; CountAzimuth:17 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 23:0:0' AND e.date<='2024-10-04 5:0:0' AND e.DeviceLoginName='3172' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-03 20:00:00' AND g.time<='2024-10-04 02:00:00' AND g.DeviceLoginName='3172' GROUP BY g.time, g.Distance; CountAzimuth:151 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 23:0:0' AND e.date<='2024-10-04 5:0:0' AND e.DeviceLoginName='4819' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-03 20:00:00' AND g.time<='2024-10-04 02:00:00' AND g.DeviceLoginName='4819' GROUP BY g.time, g.Distance; CountAzimuth:64 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-03 2:40:15' AND e.date<='2024-10-04 22:40:15' AND e.DeviceLoginName='2554' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-02 23:40:15' AND g.time<='2024-10-04 19:40:15' AND g.DeviceLoginName='2554' GROUP BY g.time, g.Distance; CountAzimuth:1089