Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 7:13:44' AND e.date<='2024-11-19 23:13:44' 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-19 05:13:44' AND g.time<='2024-11-19 21:13:44' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1606 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 5:14:46' AND e.date<='2024-11-20 7:14:46' 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-20 03:14:46' AND g.time<='2024-11-20 05:14:46' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:323 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 5:38:13' AND e.date<='2024-11-20 7:38:13' 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-20 03:38:13' AND g.time<='2024-11-20 05:38:13' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:187 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 6:17:1' AND e.date<='2024-11-20 9:17:1' 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-20 04:17:01' AND g.time<='2024-11-20 07:17:01' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:168 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:32:9' AND e.date<='2024-11-18 23:32:9' AND e.DeviceLoginName='356078111292955' 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-17 22:32:09' AND g.time<='2024-11-18 21:32:09' AND g.DeviceLoginName='356078111292955' GROUP BY g.time, g.Distance; CountAzimuth:2029 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-05 0:37:31' AND e.date<='2024-10-06 23:37:31' AND e.DeviceLoginName='2470' 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-04 22:37:31' AND g.time<='2024-10-06 21:37:31' AND g.DeviceLoginName='2470' GROUP BY g.time, g.Distance; CountAzimuth:20 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-12 0:37:31' AND e.date<='2024-10-13 23:37:31' AND e.DeviceLoginName='2470' 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-11 22:37:31' AND g.time<='2024-10-13 21:37:31' AND g.DeviceLoginName='2470' GROUP BY g.time, g.Distance; CountAzimuth:19 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-19 0:37:31' AND e.date<='2024-10-20 23:37:31' AND e.DeviceLoginName='2470' 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-18 22:37:31' AND g.time<='2024-10-20 21:37:31' AND g.DeviceLoginName='2470' GROUP BY g.time, g.Distance; CountAzimuth:938 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-26 0:37:31' AND e.date<='2024-10-27 23:37:31' AND e.DeviceLoginName='2470' 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-25 22:37:31' AND g.time<='2024-10-27 21:37:31' AND g.DeviceLoginName='2470' GROUP BY g.time, g.Distance; CountAzimuth:353 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:14:27' AND e.date<='2024-11-18 23:14:27' AND e.DeviceLoginName='353173060488002' 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-17 22:14:27' AND g.time<='2024-11-18 21:14:27' AND g.DeviceLoginName='353173060488002' GROUP BY g.time, g.Distance; CountAzimuth:2354 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 11:0:11' AND e.date<='2024-11-20 11:0:11' AND e.DeviceLoginName='3133' 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-19 09:00:11' AND g.time<='2024-11-20 09:00:11' AND g.DeviceLoginName='3133' GROUP BY g.time, g.Distance; CountAzimuth:2033 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-01 0:0:11' AND e.date<='2024-11-01 23:0:11' AND e.DeviceLoginName='3133' 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-31 22:00:11' AND g.time<='2024-11-01 21:00:11' AND g.DeviceLoginName='3133' GROUP BY g.time, g.Distance; CountAzimuth:2790 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 0:0:11' AND e.date<='2024-11-04 23:0:11' AND e.DeviceLoginName='3133' 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:00:11' AND g.time<='2024-11-04 21:00:11' AND g.DeviceLoginName='3133' GROUP BY g.time, g.Distance; CountAzimuth:1369 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 0:0:11' AND e.date<='2024-11-05 23:0:11' AND e.DeviceLoginName='3133' 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-04 22:00:11' AND g.time<='2024-11-05 21:00:11' AND g.DeviceLoginName='3133' GROUP BY g.time, g.Distance; CountAzimuth:1690 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-06 0:0:11' AND e.date<='2024-11-06 23:0:11' AND e.DeviceLoginName='3133' 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-05 22:00:11' AND g.time<='2024-11-06 21:00:11' AND g.DeviceLoginName='3133' GROUP BY g.time, g.Distance; CountAzimuth:1666 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-11 0:0:11' AND e.date<='2024-11-17 23:0:11' AND e.DeviceLoginName='3133' 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:00:11' AND g.time<='2024-11-17 21:00:11' AND g.DeviceLoginName='3133' GROUP BY g.time, g.Distance; CountAzimuth:637 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-11 0:2:29' AND e.date<='2024-11-11 23:2:29' AND e.DeviceLoginName='2783' 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:02:29' AND g.time<='2024-11-11 21:02:29' AND g.DeviceLoginName='2783' GROUP BY g.time, g.Distance; CountAzimuth:187 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 4:27:57' AND e.date<='2024-11-20 12:27: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-20 02:27:57' AND g.time<='2024-11-20 10:27:57' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:469 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 9:46:38' AND e.date<='2024-11-20 12:46: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-20 07:46:38' AND g.time<='2024-11-20 10:46:38' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:158 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 5:48:10' AND e.date<='2024-11-20 13:48: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-20 03:48:10' AND g.time<='2024-11-20 11:48:10' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:451 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 3:48:54' AND e.date<='2024-11-20 13:48:54' AND e.DeviceLoginName='3075' 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-20 01:48:54' AND g.time<='2024-11-20 11:48:54' AND g.DeviceLoginName='3075' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 14:17:33' AND e.date<='2024-11-20 14:17:33' AND e.DeviceLoginName='3075' 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-19 12:17:33' AND g.time<='2024-11-20 12:17:33' AND g.DeviceLoginName='3075' GROUP BY g.time, g.Distance; CountAzimuth:8 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 5:17:59' AND e.date<='2024-11-20 14:17:59' 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-20 03:17:59' AND g.time<='2024-11-20 12:17:59' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:539 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 2:19:24' AND e.date<='2024-11-20 14:19: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-20 00:19:24' AND g.time<='2024-11-20 12:19:24' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:13 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 11:40:10' AND e.date<='2024-11-20 14:40:10' 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-20 09:40:10' AND g.time<='2024-11-20 12:40:10' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:218 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 13:10:53' AND e.date<='2024-11-20 15:10:53' 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-20 11:10:53' AND g.time<='2024-11-20 13:10:53' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:224 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 5:21:20' AND e.date<='2024-11-20 15:21:20' 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-20 03:21:20' AND g.time<='2024-11-20 13:21:20' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:823 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 15:31:4' AND e.date<='2024-11-20 15:31:4' AND e.DeviceLoginName='2630' 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-19 13:31:04' AND g.time<='2024-11-20 13:31:04' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:266 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-01 0:31:4' AND e.date<='2024-11-01 23:31:4' AND e.DeviceLoginName='2630' 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-31 22:31:04' AND g.time<='2024-11-01 21:31:04' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:988 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-04 0:31:4' AND e.date<='2024-11-04 23:31:4' AND e.DeviceLoginName='2630' 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:31:04' AND g.time<='2024-11-04 21:31:04' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:636 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-09 0:31:4' AND e.date<='2024-11-10 23:31:4' AND e.DeviceLoginName='2630' 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:31:04' AND g.time<='2024-11-10 21:31:04' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-11 0:31:4' AND e.date<='2024-11-11 23:31:4' AND e.DeviceLoginName='2630' 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:31:04' AND g.time<='2024-11-11 21:31:04' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:914 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 0:31:4' AND e.date<='2024-11-12 23:31:4' AND e.DeviceLoginName='2630' 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:31:04' AND g.time<='2024-11-12 21:31:04' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:942 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-13 0:31:4' AND e.date<='2024-11-13 23:31:4' AND e.DeviceLoginName='2630' 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 22:31:04' AND g.time<='2024-11-13 21:31:04' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:314 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-14 0:31:4' AND e.date<='2024-11-14 23:31:4' AND e.DeviceLoginName='2630' 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-13 22:31:04' AND g.time<='2024-11-14 21:31:04' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:78 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-15 0:31:4' AND e.date<='2024-11-15 23:31:4' AND e.DeviceLoginName='2630' 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-14 22:31:04' AND g.time<='2024-11-15 21:31:04' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:163 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 0:31:4' AND e.date<='2024-11-17 23:31:4' AND e.DeviceLoginName='2630' 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-15 22:31:04' AND g.time<='2024-11-17 21:31:04' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:30 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:31:4' AND e.date<='2024-11-18 23:31:4' AND e.DeviceLoginName='2630' 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-17 22:31:04' AND g.time<='2024-11-18 21:31:04' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:815 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:31:4' AND e.date<='2024-11-19 23:31:4' AND e.DeviceLoginName='2630' 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-18 22:31:04' AND g.time<='2024-11-19 21:31:04' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:332 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:31:4' AND e.date<='2024-11-20 23:31:4' AND e.DeviceLoginName='2630' 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-19 22:31:04' AND g.time<='2024-11-20 21:31:04' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:55 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 15:57:37' AND e.date<='2024-11-20 15:57:37' AND e.DeviceLoginName='356078118085311' 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-19 13:57:37' AND g.time<='2024-11-20 13:57:37' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:1078 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:57:37' AND e.date<='2024-11-20 15:57:37' AND e.DeviceLoginName='356078118085311' 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-19 22:57:37' AND g.time<='2024-11-20 13:57:37' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:665 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-16 0:57:37' AND e.date<='2024-11-17 23:57:37' AND e.DeviceLoginName='356078118085311' 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-15 22:57:37' AND g.time<='2024-11-17 21:57:37' AND g.DeviceLoginName='356078118085311' GROUP BY g.time, g.Distance; CountAzimuth:1778 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 16:0:11' AND e.date<='2024-11-20 16:0:11' AND e.DeviceLoginName='8988' 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-19 14:00:11' AND g.time<='2024-11-20 14:00:11' AND g.DeviceLoginName='8988' GROUP BY g.time, g.Distance; CountAzimuth:896 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:0:11' AND e.date<='2024-11-20 16:0:11' AND e.DeviceLoginName='8988' 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-18 22:00:11' AND g.time<='2024-11-20 14:00:11' AND g.DeviceLoginName='8988' GROUP BY g.time, g.Distance; CountAzimuth:1169