Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-09 9:40:0' AND e.date<='2025-04-10 9:40:0' AND e.DeviceLoginName='ai5815' 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>='2025-04-09 06:40:00' AND g.time<='2025-04-10 06:40:00' AND g.DeviceLoginName='ai5815' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-09 9:40:0' AND e.date<='2025-04-10 9:40: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>='2025-04-09 06:40:00' AND g.time<='2025-04-10 06:40:00' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:1739 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 0:3:22' AND e.date<='2025-04-10 10:3:22' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-09 21:03:22' AND g.time<='2025-04-10 07:03:22' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:288 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-09 10:4:19' AND e.date<='2025-04-09 23:4:19' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-09 07:04:19' AND g.time<='2025-04-09 20:04:19' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1028 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-05 0:5:7' AND e.date<='2025-04-05 23:5:7' AND e.DeviceLoginName='356078111282600' 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>='2025-04-04 21:05:07' AND g.time<='2025-04-05 20:05:07' AND g.DeviceLoginName='356078111282600' GROUP BY g.time, g.Distance; CountAzimuth:1825 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-05 0:5:7' AND e.date<='2025-04-10 23:5:7' AND e.DeviceLoginName='356078111282600' 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>='2025-04-04 21:05:07' AND g.time<='2025-04-10 20:05:07' AND g.DeviceLoginName='356078111282600' GROUP BY g.time, g.Distance; CountAzimuth:7018 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-09 0:51:20' AND e.date<='2025-04-09 23:51:20' AND e.DeviceLoginName='2530' 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>='2025-04-08 21:51:20' AND g.time<='2025-04-09 20:51:20' AND g.DeviceLoginName='2530' GROUP BY g.time, g.Distance; CountAzimuth:1342 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-09 11:0:33' AND e.date<='2025-04-10 11:0:33' 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>='2025-04-09 08:00:33' AND g.time<='2025-04-10 08:00:33' AND g.DeviceLoginName='2623' GROUP BY g.time, g.Distance; CountAzimuth:1323 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-09 11:0:33' AND e.date<='2025-04-09 13:0:33' 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>='2025-04-09 08:00:33' AND g.time<='2025-04-09 10:00:33' AND g.DeviceLoginName='2623' GROUP BY g.time, g.Distance; CountAzimuth:216 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 0:13:17' AND e.date<='2025-04-10 11:13:17' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-09 21:13:17' AND g.time<='2025-04-10 08:13:17' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:302 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 5:13:31' AND e.date<='2025-04-10 11:13:31' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-10 02:13:31' AND g.time<='2025-04-10 08:13:31' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:201 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 0:13:59' AND e.date<='2025-04-10 11:13:59' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-09 21:13:59' AND g.time<='2025-04-10 08:13:59' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:94 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 3:14:23' AND e.date<='2025-04-10 11:14:23' AND e.DeviceLoginName='358021081803706' 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>='2025-04-10 00:14:23' AND g.time<='2025-04-10 08:14:23' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:232 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 2:14:44' AND e.date<='2025-04-10 11:14:44' AND e.DeviceLoginName='356078116278207' 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>='2025-04-09 23:14:44' AND g.time<='2025-04-10 08:14:44' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:376 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 1:15:25' AND e.date<='2025-04-10 11:15:25' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-09 22:15:25' AND g.time<='2025-04-10 08:15:25' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:302 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-09 9:0:33' AND e.date<='2025-04-09 13:0:33' AND e.DeviceLoginName='3191' 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>='2025-04-09 06:00:33' AND g.time<='2025-04-09 10:00:33' AND g.DeviceLoginName='3191' GROUP BY g.time, g.Distance; CountAzimuth:1389 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 5:24:16' AND e.date<='2025-04-10 11:24:16' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-10 02:24:16' AND g.time<='2025-04-10 08:24:16' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:239 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-08 9:0:33' AND e.date<='2025-04-08 23:0:33' AND e.DeviceLoginName='4825' 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>='2025-04-08 06:00:33' AND g.time<='2025-04-08 20:00:33' AND g.DeviceLoginName='4825' GROUP BY g.time, g.Distance; CountAzimuth:339 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 2:24:59' AND e.date<='2025-04-10 11:24:59' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-09 23:24:59' AND g.time<='2025-04-10 08:24:59' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:430 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-08 0:0:33' AND e.date<='2025-04-08 23:0:33' AND e.DeviceLoginName='4825' 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>='2025-04-07 21:00:33' AND g.time<='2025-04-08 20:00:33' AND g.DeviceLoginName='4825' GROUP BY g.time, g.Distance; CountAzimuth:641 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-09 11:26:41' AND e.date<='2025-04-10 11:26:41' AND e.DeviceLoginName='2556' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-09 08:26:41' AND g.time<='2025-04-10 08:26:41' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:269 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 4:26:56' AND e.date<='2025-04-10 11:26:56' AND e.DeviceLoginName='3075' 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>='2025-04-10 01:26:56' AND g.time<='2025-04-10 08:26:56' AND g.DeviceLoginName='3075' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-09 0:0:33' AND e.date<='2025-04-09 23:0:33' AND e.DeviceLoginName='4825' 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>='2025-04-08 21:00:33' AND g.time<='2025-04-09 20:00:33' AND g.DeviceLoginName='4825' GROUP BY g.time, g.Distance; CountAzimuth:1005 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>='2025-04-09 21:00:00' AND g.time<='2025-04-10 08:32:32' AND g.DeviceLoginName='9012' Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 05:12:28' AND TIME<='2025-04-10 05:22:28' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 05:18:13' AND TIME<='2025-04-10 05:28:13' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 05:45:18' AND TIME<='2025-04-10 05:55:18' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 05:54:58' AND TIME<='2025-04-10 06:04:58' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 06:58:33' AND TIME<='2025-04-10 07:08:33' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 07:11:33' AND TIME<='2025-04-10 07:21:33' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 07:17:48' AND TIME<='2025-04-10 07:27:48' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 07:56:48' AND TIME<='2025-04-10 08:06:48' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 08:08:38' AND TIME<='2025-04-10 08:18:38' AND DeviceLoginName='9012' AND speed=0 Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='9012' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2025-04-09 21:00:00' AND e.date<='2025-04-10 08:32:32' Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 05:12:28' AND TIME<='2025-04-10 05:22:28' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 05:18:13' AND TIME<='2025-04-10 05:28:13' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 05:45:18' AND TIME<='2025-04-10 05:55:18' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 05:54:58' AND TIME<='2025-04-10 06:04:58' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 06:39:48' AND TIME<='2025-04-10 06:49:48' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 06:46:28' AND TIME<='2025-04-10 06:56:28' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 06:58:33' AND TIME<='2025-04-10 07:08:33' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 07:06:33' AND TIME<='2025-04-10 07:16:33' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 07:11:33' AND TIME<='2025-04-10 07:21:33' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 07:17:48' AND TIME<='2025-04-10 07:27:48' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 07:56:48' AND TIME<='2025-04-10 08:06:48' AND DeviceLoginName='9012' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2025-04-10 08:08:38' AND TIME<='2025-04-10 08:18:38' AND DeviceLoginName='9012' AND speed=0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-09 0:0:33' AND e.date<='2025-04-09 23:0:33' AND e.DeviceLoginName='5126' 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>='2025-04-08 21:00:33' AND g.time<='2025-04-09 20:00:33' AND g.DeviceLoginName='5126' GROUP BY g.time, g.Distance; CountAzimuth:485 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-08 0:0:33' AND e.date<='2025-04-08 23:0:33' AND e.DeviceLoginName='5126' 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>='2025-04-07 21:00:33' AND g.time<='2025-04-08 20:00:33' AND g.DeviceLoginName='5126' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-07 0:0:33' AND e.date<='2025-04-09 23:0:33' AND e.DeviceLoginName='5126' 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>='2025-04-06 21:00:33' AND g.time<='2025-04-09 20:00:33' AND g.DeviceLoginName='5126' GROUP BY g.time, g.Distance; CountAzimuth:485 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-04 0:0:33' AND e.date<='2025-04-09 23:0:33' AND e.DeviceLoginName='5126' 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>='2025-04-03 21:00:33' AND g.time<='2025-04-09 20:00:33' AND g.DeviceLoginName='5126' GROUP BY g.time, g.Distance; CountAzimuth:1672 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 4:39:3' AND e.date<='2025-04-10 11:39:3' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-10 01:39:03' AND g.time<='2025-04-10 08:39:03' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:577 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 5:42:23' AND e.date<='2025-04-10 11:42:23' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-10 02:42:23' AND g.time<='2025-04-10 08:42:23' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:585 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 5:51:53' AND e.date<='2025-04-10 11:51:53' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-10 02:51:53' AND g.time<='2025-04-10 08:51:53' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:651 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-08 12:24:54' AND e.date<='2025-04-08 19:24:54' AND e.DeviceLoginName='356078111472854' 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>='2025-04-08 09:24:54' AND g.time<='2025-04-08 16:24:54' AND g.DeviceLoginName='356078111472854' GROUP BY g.time, g.Distance; CountAzimuth:859 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-20 12:24:54' AND e.date<='2025-03-20 19:24:54' AND e.DeviceLoginName='356078111472854' 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>='2025-03-20 09:24:54' AND g.time<='2025-03-20 16:24:54' AND g.DeviceLoginName='356078111472854' GROUP BY g.time, g.Distance; CountAzimuth:821 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 3:37:49' AND e.date<='2025-04-10 12:37:49' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-10 00:37:49' AND g.time<='2025-04-10 09:37:49' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:763 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 3:38:14' AND e.date<='2025-04-10 12:38:14' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-10 00:38:14' AND g.time<='2025-04-10 09:38:14' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:579 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 3:38:44' AND e.date<='2025-04-10 12:38:44' AND e.DeviceLoginName='356078116278207' 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>='2025-04-10 00:38:44' AND g.time<='2025-04-10 09:38:44' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:738 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-08 0:24:54' AND e.date<='2025-03-20 19:24:54' AND e.DeviceLoginName='356078111472854' 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>='2025-04-07 21:24:54' AND g.time<='2025-03-20 16:24:54' AND g.DeviceLoginName='356078111472854' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-08 0:24:54' AND e.date<='2025-04-10 19:24:54' AND e.DeviceLoginName='356078111472854' 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>='2025-04-07 21:24:54' AND g.time<='2025-04-10 16:24:54' AND g.DeviceLoginName='356078111472854' GROUP BY g.time, g.Distance; CountAzimuth:5339 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 5:4:53' AND e.date<='2025-04-10 13:4:53' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-10 02:04:53' AND g.time<='2025-04-10 10:04:53' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:936 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-04 0:24:54' AND e.date<='2025-04-04 19:24:54' AND e.DeviceLoginName='3076' 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>='2025-04-03 21:24:54' AND g.time<='2025-04-04 16:24:54' AND g.DeviceLoginName='3076' GROUP BY g.time, g.Distance; CountAzimuth:2128 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-23 0:24:54' AND e.date<='2025-02-23 19:24:54' AND e.DeviceLoginName='5134' 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>='2025-02-22 21:24:54' AND g.time<='2025-02-23 16:24:54' AND g.DeviceLoginName='5134' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-02-21 0:24:54' AND e.date<='2025-02-24 19:24:54' AND e.DeviceLoginName='5134' 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>='2025-02-20 21:24:54' AND g.time<='2025-02-24 16:24:54' AND g.DeviceLoginName='5134' GROUP BY g.time, g.Distance; CountAzimuth:332 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 3:15:21' AND e.date<='2025-04-10 14:15:21' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-10 00:15:21' AND g.time<='2025-04-10 11:15:21' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:938 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 9:33:0' AND e.date<='2025-04-10 15:33:0' AND e.DeviceLoginName='354836080167561' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-10 06:33:00' AND g.time<='2025-04-10 12:33:00' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:400 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-10 9:33:17' AND e.date<='2025-04-10 15:33:17' AND e.DeviceLoginName='352353083458635' AND e.EventType=7 Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2025-04-10 06:33:17' AND g.time<='2025-04-10 12:33:17' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:637