Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-07 0:6:17' AND e.date<='2024-11-07 23:6:17' AND e.DeviceLoginName='3084' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-06 22:06:17' AND g.time<='2024-11-07 21:06:17' AND g.DeviceLoginName='3084' GROUP BY g.time, g.Distance; CountAzimuth:1375 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-08 0:6:17' AND e.date<='2024-11-08 23:6:17' AND e.DeviceLoginName='3084' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-07 22:06:17' AND g.time<='2024-11-08 21:06:17' AND g.DeviceLoginName='3084' GROUP BY g.time, g.Distance; CountAzimuth:2632 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 5:15:36' AND e.date<='2024-11-12 7:15:36' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 03:15:36' AND g.time<='2024-11-12 05:15:36' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:250 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 6:16:24' AND e.date<='2024-11-12 7:16:24' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 04:16:24' AND g.time<='2024-11-12 05:16:24' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:2 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 5:16:38' AND e.date<='2024-11-12 7:16:38' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 03:16:38' AND g.time<='2024-11-12 05:16:38' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:69 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 2:35:59' AND e.date<='2024-11-12 7:35:59' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 00:35:59' AND g.time<='2024-11-12 05:35:59' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:5 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:58:50' AND e.date<='2024-10-07 23:58:50' AND e.DeviceLoginName='352353084656807' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-06 22:58:50' AND g.time<='2024-10-07 21:58:50' AND g.DeviceLoginName='352353084656807' GROUP BY g.time, g.Distance; CountAzimuth:2168 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:0:55' AND e.date<='2024-10-07 23:0:55' AND e.DeviceLoginName='2749' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-06 22:00:55' AND g.time<='2024-10-07 21:00:55' AND g.DeviceLoginName='2749' GROUP BY g.time, g.Distance; CountAzimuth:2350 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-08 0:6:14' AND e.date<='2024-10-08 23:6:14' AND e.DeviceLoginName='2749' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-07 22:06:14' AND g.time<='2024-10-08 21:06:14' AND g.DeviceLoginName='2749' GROUP BY g.time, g.Distance; CountAzimuth:2175 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-20 0:6:31' AND e.date<='2024-10-20 23:6:31' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-19 22:06:31' AND g.time<='2024-10-20 21:06:31' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:77 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-11 0:9:45' AND e.date<='2024-11-12 9:9:45' AND e.DeviceLoginName='353173066828375' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-10 22:09:45' AND g.time<='2024-11-12 07:09:45' AND g.DeviceLoginName='353173066828375' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 0:9:45' AND e.date<='2024-11-08 23:9:45' AND e.DeviceLoginName='353173066828375' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-03 22:09:45' AND g.time<='2024-11-08 21:09:45' AND g.DeviceLoginName='353173066828375' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 0:14:50' AND e.date<='2024-10-09 23:14:50' AND e.DeviceLoginName='2749' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-08 22:14:50' AND g.time<='2024-10-09 21:14:50' AND g.DeviceLoginName='2749' GROUP BY g.time, g.Distance; CountAzimuth:4019 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-10 0:18:59' AND e.date<='2024-10-10 23:18:59' AND e.DeviceLoginName='2749' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-09 22:18:59' AND g.time<='2024-10-10 21:18:59' AND g.DeviceLoginName='2749' GROUP BY g.time, g.Distance; CountAzimuth:1716 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 0:22:9' AND e.date<='2024-10-11 23:22:9' AND e.DeviceLoginName='2749' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-10 22:22:09' AND g.time<='2024-10-11 21:22:09' AND g.DeviceLoginName='2749' GROUP BY g.time, g.Distance; CountAzimuth:1566 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:42:5' AND e.date<='2024-10-07 23:42:5' AND e.DeviceLoginName='3209' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-06 22:42:05' AND g.time<='2024-10-07 21:42:05' AND g.DeviceLoginName='3209' GROUP BY g.time, g.Distance; CountAzimuth:4326 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-08 0:45:22' AND e.date<='2024-10-08 23:45:22' AND e.DeviceLoginName='3209' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-07 22:45:22' AND g.time<='2024-10-08 21:45:22' AND g.DeviceLoginName='3209' GROUP BY g.time, g.Distance; CountAzimuth:2350 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 0:48:13' AND e.date<='2024-10-09 23:48:13' AND e.DeviceLoginName='3209' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-08 22:48:13' AND g.time<='2024-10-09 21:48:13' AND g.DeviceLoginName='3209' GROUP BY g.time, g.Distance; CountAzimuth:2713 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-10 0:51:40' AND e.date<='2024-10-10 23:51:40' AND e.DeviceLoginName='3209' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-09 22:51:40' AND g.time<='2024-10-10 21:51:40' AND g.DeviceLoginName='3209' GROUP BY g.time, g.Distance; CountAzimuth:947 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 0:54:28' AND e.date<='2024-10-11 23:54:28' AND e.DeviceLoginName='3209' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-10 22:54:28' AND g.time<='2024-10-11 21:54:28' AND g.DeviceLoginName='3209' GROUP BY g.time, g.Distance; CountAzimuth:2401 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:59:20' AND e.date<='2024-10-07 23:59:20' AND e.DeviceLoginName='2906' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-06 22:59:20' AND g.time<='2024-10-07 21:59:20' AND g.DeviceLoginName='2906' GROUP BY g.time, g.Distance; CountAzimuth:485 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-08 0:4:57' AND e.date<='2024-10-08 23:4:57' AND e.DeviceLoginName='2906' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-07 22:04:57' AND g.time<='2024-10-08 21:04:57' AND g.DeviceLoginName='2906' GROUP BY g.time, g.Distance; CountAzimuth:1038 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 0:20:47' AND e.date<='2024-10-09 23:20:47' AND e.DeviceLoginName='2906' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-08 22:20:47' AND g.time<='2024-10-09 21:20:47' AND g.DeviceLoginName='2906' GROUP BY g.time, g.Distance; CountAzimuth:1522 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-10 0:23:51' AND e.date<='2024-10-10 23:23:51' AND e.DeviceLoginName='2906' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-09 22:23:51' AND g.time<='2024-10-10 21:23:51' AND g.DeviceLoginName='2906' GROUP BY g.time, g.Distance; CountAzimuth:717 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 0:26:29' AND e.date<='2024-10-11 23:26:29' AND e.DeviceLoginName='2906' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-10 22:26:29' AND g.time<='2024-10-11 21:26:29' AND g.DeviceLoginName='2906' GROUP BY g.time, g.Distance; CountAzimuth:548 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:30:5' AND e.date<='2024-10-07 23:30:5' AND e.DeviceLoginName='354836080173346' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-06 22:30:05' AND g.time<='2024-10-07 21:30:05' AND g.DeviceLoginName='354836080173346' GROUP BY g.time, g.Distance; CountAzimuth:13 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-08 0:32:47' AND e.date<='2024-10-08 23:32:47' AND e.DeviceLoginName='354836080173346' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-07 22:32:47' AND g.time<='2024-10-08 21:32:47' AND g.DeviceLoginName='354836080173346' GROUP BY g.time, g.Distance; CountAzimuth:89 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:34:45' AND e.date<='2024-10-07 23:34:45' AND e.DeviceLoginName='4863' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-06 22:34:45' AND g.time<='2024-10-07 21:34:45' AND g.DeviceLoginName='4863' GROUP BY g.time, g.Distance; CountAzimuth:26 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-08 0:35:25' AND e.date<='2024-10-08 23:35:25' AND e.DeviceLoginName='4863' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-07 22:35:25' AND g.time<='2024-10-08 21:35:25' AND g.DeviceLoginName='4863' GROUP BY g.time, g.Distance; CountAzimuth:186 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 0:36:11' AND e.date<='2024-10-09 23:36:11' AND e.DeviceLoginName='354836080173346' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-08 22:36:11' AND g.time<='2024-10-09 21:36:11' AND g.DeviceLoginName='354836080173346' GROUP BY g.time, g.Distance; CountAzimuth:757 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-10 0:39:16' AND e.date<='2024-10-10 23:39:16' AND e.DeviceLoginName='354836080173346' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-09 22:39:16' AND g.time<='2024-10-10 21:39:16' AND g.DeviceLoginName='354836080173346' GROUP BY g.time, g.Distance; CountAzimuth:1575 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 0:41:45' AND e.date<='2024-10-11 23:41:45' AND e.DeviceLoginName='354836080173346' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-10 22:41:45' AND g.time<='2024-10-11 21:41:45' AND g.DeviceLoginName='354836080173346' GROUP BY g.time, g.Distance; CountAzimuth:1742 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:45:18' AND e.date<='2024-10-07 23:45:18' AND e.DeviceLoginName='2536' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-06 22:45:18' AND g.time<='2024-10-07 21:45:18' AND g.DeviceLoginName='2536' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:46:3' AND e.date<='2024-10-07 23:46:3' AND e.DeviceLoginName='2536' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-06 22:46:03' AND g.time<='2024-10-07 21:46:03' AND g.DeviceLoginName='2536' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-08 0:47:45' AND e.date<='2024-10-08 23:47:45' AND e.DeviceLoginName='2536' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-07 22:47:45' AND g.time<='2024-10-08 21:47:45' AND g.DeviceLoginName='2536' GROUP BY g.time, g.Distance; CountAzimuth:2210 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 0:48:40' AND e.date<='2024-11-12 10:48:40' AND e.DeviceLoginName='355234055558247' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-11 22:48:40' AND g.time<='2024-11-12 08:48:40' AND g.DeviceLoginName='355234055558247' GROUP BY g.time, g.Distance; CountAzimuth:506 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 0:50:30' AND e.date<='2024-10-09 23:50:30' AND e.DeviceLoginName='2536' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-08 22:50:30' AND g.time<='2024-10-09 21:50:30' AND g.DeviceLoginName='2536' GROUP BY g.time, g.Distance; CountAzimuth:1336 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-11 0:48:40' AND e.date<='2024-11-11 10:48:40' AND e.DeviceLoginName='355234055558247' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-10 22:48:40' AND g.time<='2024-11-11 08:48:40' AND g.DeviceLoginName='355234055558247' GROUP BY g.time, g.Distance; CountAzimuth:177 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-11 0:48:40' AND e.date<='2024-11-11 23:48:40' AND e.DeviceLoginName='355234055558247' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-10 22:48:40' AND g.time<='2024-11-11 21:48:40' AND g.DeviceLoginName='355234055558247' GROUP BY g.time, g.Distance; CountAzimuth:896 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-10 0:52:50' AND e.date<='2024-10-10 23:52:50' AND e.DeviceLoginName='2536' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-09 22:52:50' AND g.time<='2024-10-10 21:52:50' AND g.DeviceLoginName='2536' GROUP BY g.time, g.Distance; CountAzimuth:1321 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 0:55:24' AND e.date<='2024-10-11 23:55:24' AND e.DeviceLoginName='2536' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-10 22:55:24' AND g.time<='2024-10-11 21:55:24' AND g.DeviceLoginName='2536' GROUP BY g.time, g.Distance; CountAzimuth:3472 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-07 0:59:14' AND e.date<='2024-10-07 23:59:14' AND e.DeviceLoginName='358021081932786' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-06 22:59:14' AND g.time<='2024-10-07 21:59:14' AND g.DeviceLoginName='358021081932786' GROUP BY g.time, g.Distance; CountAzimuth:3190 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-08 0:1:23' AND e.date<='2024-10-08 23:1:23' AND e.DeviceLoginName='358021081932786' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-07 22:01:23' AND g.time<='2024-10-08 21:01:23' AND g.DeviceLoginName='358021081932786' GROUP BY g.time, g.Distance; CountAzimuth:2386 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-09 0:5:3' AND e.date<='2024-10-09 23:5:3' AND e.DeviceLoginName='358021081932786' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-08 22:05:03' AND g.time<='2024-10-09 21:05:03' AND g.DeviceLoginName='358021081932786' GROUP BY g.time, g.Distance; CountAzimuth:2284 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-10 0:8:12' AND e.date<='2024-10-10 23:8:12' AND e.DeviceLoginName='358021081932786' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-09 22:08:12' AND g.time<='2024-10-10 21:08:12' AND g.DeviceLoginName='358021081932786' GROUP BY g.time, g.Distance; CountAzimuth:1601 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 6:8:50' AND e.date<='2024-11-12 11:8:50' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 04:08:50' AND g.time<='2024-11-12 09:08:50' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:643 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 4:9:32' AND e.date<='2024-11-12 11:9:32' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 02:09:32' AND g.time<='2024-11-12 09:09:32' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:319 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 7:10:9' AND e.date<='2024-11-12 11:10:9' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 05:10:09' AND g.time<='2024-11-12 09:10:09' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:270 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-11 0:12:59' AND e.date<='2024-10-11 23:12:59' AND e.DeviceLoginName='358021081932786' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-10 22:12:59' AND g.time<='2024-10-11 21:12:59' AND g.DeviceLoginName='358021081932786' GROUP BY g.time, g.Distance; CountAzimuth:1785 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 8:32:35' AND e.date<='2024-11-12 11:32:35' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 06:32:35' AND g.time<='2024-11-12 09:32:35' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:494 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 6:43:27' AND e.date<='2024-11-12 11:43:27' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 04:43:27' AND g.time<='2024-11-12 09:43:27' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:359 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 7:16:57' AND e.date<='2024-11-12 12:16:57' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 05:16:57' AND g.time<='2024-11-12 10:16:57' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:583 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 7:40:27' AND e.date<='2024-11-12 12:40:27' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 05:40:27' AND g.time<='2024-11-12 10:40:27' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:399 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 9:40:52' AND e.date<='2024-11-12 12:40:52' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 07:40:52' AND g.time<='2024-11-12 10:40:52' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:684 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 3:41:31' AND e.date<='2024-11-12 12:41:31' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 01:41:31' AND g.time<='2024-11-12 10:41:31' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:988 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 3:42:3' AND e.date<='2024-11-12 12:42:3' AND e.DeviceLoginName='356078116278207' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 01:42:03' AND g.time<='2024-11-12 10:42:03' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:419 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 0:46:39' AND e.date<='2024-11-12 12:46:39' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-11 22:46:39' AND g.time<='2024-11-12 10:46:39' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1005 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 5:47:6' AND e.date<='2024-11-12 12:47:6' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 03:47:06' AND g.time<='2024-11-12 10:47:06' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:503 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 6:56:12' AND e.date<='2024-11-12 12:56:12' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 04:56:12' AND g.time<='2024-11-12 10:56:12' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:268 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 10:57:5' AND e.date<='2024-11-12 12:57:5' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 08:57:05' AND g.time<='2024-11-12 10:57:05' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:532 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 9:0:34' AND e.date<='2024-11-12 13:0:34' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 07:00:34' AND g.time<='2024-11-12 11:00:34' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:487 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 5:27:38' AND e.date<='2024-11-12 13:27:38' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 03:27:38' AND g.time<='2024-11-12 11:27:38' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:655 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 0:40:53' AND e.date<='2024-11-08 23:40:53' AND e.DeviceLoginName='2540' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-03 22:40:53' AND g.time<='2024-11-08 21:40:53' AND g.DeviceLoginName='2540' GROUP BY g.time, g.Distance; CountAzimuth:1725 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-11 0:40:53' AND e.date<='2024-11-12 23:40:53' AND e.DeviceLoginName='2540' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-10 22:40:53' AND g.time<='2024-11-12 21:40:53' AND g.DeviceLoginName='2540' GROUP BY g.time, g.Distance; CountAzimuth:3244 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 0:40:53' AND e.date<='2024-11-08 23:40:53' AND e.DeviceLoginName='2540' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-03 22:40:53' AND g.time<='2024-11-08 21:40:53' AND g.DeviceLoginName='2540' GROUP BY g.time, g.Distance; CountAzimuth:1725 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-09 0:40:53' AND e.date<='2024-11-10 23:40:53' AND e.DeviceLoginName='2540' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-08 22:40:53' AND g.time<='2024-11-10 21:40:53' AND g.DeviceLoginName='2540' GROUP BY g.time, g.Distance; CountAzimuth:179 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 8:51:37' AND e.date<='2024-11-12 13:51:37' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 06:51:37' AND g.time<='2024-11-12 11:51:37' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:118 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 7:12:38' AND e.date<='2024-11-12 14:12:38' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 05:12:38' AND g.time<='2024-11-12 12:12:38' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:942 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 12:13:2' AND e.date<='2024-11-12 14:13:2' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 10:13:02' AND g.time<='2024-11-12 12:13:02' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:101 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 7:14:47' AND e.date<='2024-11-12 14:14:47' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 05:14:47' AND g.time<='2024-11-12 12:14:47' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:303 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 9:31:4' AND e.date<='2024-11-12 14:31:4' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 07:31:04' AND g.time<='2024-11-12 12:31:04' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:308 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 9:45:42' AND e.date<='2024-11-12 14:45:42' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 07:45:42' AND g.time<='2024-11-12 12:45:42' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:333 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 8:48:33' AND e.date<='2024-11-12 14:48:33' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 06:48:33' AND g.time<='2024-11-12 12:48:33' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:975 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 6:49:6' AND e.date<='2024-11-12 14:49:6' AND e.DeviceLoginName='356078116278207' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 04:49:06' AND g.time<='2024-11-12 12:49:06' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:527 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 7:57:40' AND e.date<='2024-11-12 14:57:40' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 05:57:40' AND g.time<='2024-11-12 12:57:40' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:975 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 7:58:3' AND e.date<='2024-11-12 14:58:3' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 05:58:03' AND g.time<='2024-11-12 12:58:03' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:333 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 11:10:36' AND e.date<='2024-11-12 15:10:36' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 09:10:36' AND g.time<='2024-11-12 13:10:36' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:657 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 12:11:0' AND e.date<='2024-11-12 15:11:0' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 10:11:00' AND g.time<='2024-11-12 13:11:00' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:216 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 10:15:12' AND e.date<='2024-11-12 15:15:12' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 08:15:12' AND g.time<='2024-11-12 13:15:12' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:333 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 11:40:37' AND e.date<='2024-11-12 15:40:37' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 09:40:37' AND g.time<='2024-11-12 13:40:37' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:332 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 11:42:10' AND e.date<='2024-11-12 15:42:10' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 09:42:10' AND g.time<='2024-11-12 13:42:10' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:333 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 12:43:52' AND e.date<='2024-11-12 15:43:52' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 10:43:52' AND g.time<='2024-11-12 13:43:52' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:216 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-11 15:58:46' AND e.date<='2024-11-12 15:58:46' AND e.DeviceLoginName='2684' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-11 13:58:46' AND g.time<='2024-11-12 13:58:46' AND g.DeviceLoginName='2684' GROUP BY g.time, g.Distance; CountAzimuth:2863 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 0:58:46' AND e.date<='2024-11-12 15:58:46' AND e.DeviceLoginName='2684' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-11 22:58:46' AND g.time<='2024-11-12 13:58:46' AND g.DeviceLoginName='2684' GROUP BY g.time, g.Distance; CountAzimuth:2431 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 7:1:20' AND e.date<='2024-11-12 16:1:20' AND e.DeviceLoginName='2726' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 05:01:20' AND g.time<='2024-11-12 14:01:20' AND g.DeviceLoginName='2726' GROUP BY g.time, g.Distance; CountAzimuth:341 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 16:25:43' AND e.date<='2024-11-12 20:25:43' AND e.DeviceLoginName='3212' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-12 14:25:43' AND g.time<='2024-11-12 18:25:43' AND g.DeviceLoginName='3212' GROUP BY g.time, g.Distance; CountAzimuth:810