Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-20 0:46:45' AND e.date<='2025-01-22 23:46:45' AND e.DeviceLoginName='2665' 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>='2025-01-19 22:46:45' AND g.time<='2025-01-22 21:46:45' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:3497 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-21 9:11:54' AND e.date<='2025-01-22 9:11:54' AND e.DeviceLoginName='2665' 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>='2025-01-21 07:11:54' AND g.time<='2025-01-22 07:11:54' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:1181 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-13 0:11:54' AND e.date<='2025-01-13 23:11:54' AND e.DeviceLoginName='2665' 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>='2025-01-12 22:11:54' AND g.time<='2025-01-13 21:11:54' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:898 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-14 0:11:54' AND e.date<='2025-01-14 23:11:54' AND e.DeviceLoginName='2665' 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>='2025-01-13 22:11:54' AND g.time<='2025-01-14 21:11:54' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:1467 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-15 0:11:54' AND e.date<='2025-01-15 23:11:54' AND e.DeviceLoginName='2665' 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>='2025-01-14 22:11:54' AND g.time<='2025-01-15 21:11:54' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:1692 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-16 0:11:54' AND e.date<='2025-01-16 23:11:54' AND e.DeviceLoginName='2665' 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>='2025-01-15 22:11:54' AND g.time<='2025-01-16 21:11:54' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:1671 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-17 0:11:54' AND e.date<='2025-01-17 23:11:54' AND e.DeviceLoginName='2665' 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>='2025-01-16 22:11:54' AND g.time<='2025-01-17 21:11:54' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-18 0:11:54' AND e.date<='2025-01-19 23:11:54' AND e.DeviceLoginName='2665' 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>='2025-01-17 22:11:54' AND g.time<='2025-01-19 21:11:54' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:437 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-20 0:11:54' AND e.date<='2025-01-20 23:11:54' AND e.DeviceLoginName='2665' 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>='2025-01-19 22:11:54' AND g.time<='2025-01-20 21:11:54' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:1341 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-15 0:11:54' AND e.date<='2025-01-15 23:11:54' AND e.DeviceLoginName='354836080091142' 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>='2025-01-14 22:11:54' AND g.time<='2025-01-15 21:11:54' AND g.DeviceLoginName='354836080091142' GROUP BY g.time, g.Distance; CountAzimuth:1380 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-20 0:11:54' AND e.date<='2025-01-20 23:11:54' AND e.DeviceLoginName='2665' 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>='2025-01-19 22:11:54' AND g.time<='2025-01-20 21:11:54' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:1341 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-21 0:11:54' AND e.date<='2025-01-21 23:11:54' AND e.DeviceLoginName='2665' 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>='2025-01-20 22:11:54' AND g.time<='2025-01-21 21:11:54' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:1847 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-22 0:11:54' AND e.date<='2025-01-22 23:11:54' AND e.DeviceLoginName='2665' 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>='2025-01-21 22:11:54' AND g.time<='2025-01-22 21:11:54' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:183 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-01 0:46:19' AND e.date<='2025-01-22 9:46:19' AND e.DeviceLoginName='2709' 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-12-31 22:46:19' AND g.time<='2025-01-22 07:46:19' AND g.DeviceLoginName='2709' GROUP BY g.time, g.Distance; CountAzimuth:31532 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-13 9:47:3' AND e.date<='2025-01-19 9:47:3' AND e.DeviceLoginName='2833' 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>='2025-01-13 07:47:03' AND g.time<='2025-01-19 07:47:03' AND g.DeviceLoginName='2833' GROUP BY g.time, g.Distance; CountAzimuth:17095 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-21 9:49:3' AND e.date<='2025-01-22 9:49:3' 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>='2025-01-21 07:49:03' AND g.time<='2025-01-22 07:49:03' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:119 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-20 9:49:32' AND e.date<='2025-01-22 9:49:32' 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>='2025-01-20 07:49:32' AND g.time<='2025-01-22 07:49:32' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:850 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-21 9:58:10' AND e.date<='2025-01-22 9:58: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>='2025-01-21 07:58:10' AND g.time<='2025-01-22 07:58:10' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:119 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-22 3:1:34' AND e.date<='2025-01-22 10:1:34' 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>='2025-01-22 01:01:34' AND g.time<='2025-01-22 08:01:34' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-21 10:45:11' AND e.date<='2025-01-22 10:45:11' 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>='2025-01-21 08:45:11' AND g.time<='2025-01-22 08:45:11' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:119 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-22 4:29:7' AND e.date<='2025-01-22 11:29:7' 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>='2025-01-22 02:29:07' AND g.time<='2025-01-22 09:29:07' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:291 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-21 1:29:49' AND e.date<='2025-01-22 11:29:49' 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>='2025-01-20 23:29:49' AND g.time<='2025-01-22 09:29:49' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:894 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-21 0:30:20' AND e.date<='2025-01-21 23:30: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>='2025-01-20 22:30:20' AND g.time<='2025-01-21 21:30:20' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:603 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-21 4:45:53' AND e.date<='2025-01-21 23:45: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>='2025-01-21 02:45:53' AND g.time<='2025-01-21 21:45:53' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:603 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-22 0:47:52' AND e.date<='2025-01-22 11:47: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>='2025-01-21 22:47:52' AND g.time<='2025-01-22 09:47:52' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:702 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-22 4:29:7' AND e.date<='2025-01-22 12:29:7' 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>='2025-01-22 02:29:07' AND g.time<='2025-01-22 10:29:07' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:266 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-21 13:33:3' AND e.date<='2025-01-22 13:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-21 11:33:03' AND g.time<='2025-01-22 11:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:1110 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-13 0:33:3' AND e.date<='2025-01-13 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-12 22:33:03' AND g.time<='2025-01-13 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:93 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-14 0:33:3' AND e.date<='2025-01-14 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-13 22:33:03' AND g.time<='2025-01-14 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:504 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-15 0:33:3' AND e.date<='2025-01-15 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-14 22:33:03' AND g.time<='2025-01-15 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:2115 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-16 0:33:3' AND e.date<='2025-01-16 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-15 22:33:03' AND g.time<='2025-01-16 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:1527 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-17 0:33:3' AND e.date<='2025-01-17 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-16 22:33:03' AND g.time<='2025-01-17 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:1016 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-20 0:33:3' AND e.date<='2025-01-20 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-19 22:33:03' AND g.time<='2025-01-20 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:1566 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-21 0:33:3' AND e.date<='2025-01-21 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-20 22:33:03' AND g.time<='2025-01-21 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:936 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-22 0:33:3' AND e.date<='2025-01-22 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-21 22:33:03' AND g.time<='2025-01-22 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:953 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-21 0:33:3' AND e.date<='2025-01-21 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-20 22:33:03' AND g.time<='2025-01-21 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:936 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-01 0:33:3' AND e.date<='2025-01-01 23:33:3' AND e.DeviceLoginName='2724' 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-12-31 22:33:03' AND g.time<='2025-01-01 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-09 0:33:3' AND e.date<='2025-01-09 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-08 22:33:03' AND g.time<='2025-01-09 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-06 0:33:3' AND e.date<='2025-01-09 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-05 22:33:03' AND g.time<='2025-01-09 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:2886 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-10 0:33:3' AND e.date<='2025-01-10 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-09 22:33:03' AND g.time<='2025-01-10 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-10 0:33:3' AND e.date<='2025-01-12 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-09 22:33:03' AND g.time<='2025-01-12 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-15 0:33:3' AND e.date<='2025-01-15 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-14 22:33:03' AND g.time<='2025-01-15 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:2115 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-16 0:33:3' AND e.date<='2025-01-16 23:33:3' AND e.DeviceLoginName='2724' 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>='2025-01-15 22:33:03' AND g.time<='2025-01-16 21:33:03' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:1527 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-20 0:42:59' AND e.date<='2025-01-20 23:42:59' AND e.DeviceLoginName='9379' 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>='2025-01-19 22:42:59' AND g.time<='2025-01-20 21:42:59' AND g.DeviceLoginName='9379' GROUP BY g.time, g.Distance; CountAzimuth:4508 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-22 6:34:26' AND e.date<='2025-01-22 14:34:26' 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>='2025-01-22 04:34:26' AND g.time<='2025-01-22 12:34:26' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:559 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-21 16:21:6' AND e.date<='2025-01-22 16:21:6' AND e.DeviceLoginName='2950' 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>='2025-01-21 14:21:06' AND g.time<='2025-01-22 14:21:06' AND g.DeviceLoginName='2950' GROUP BY g.time, g.Distance; CountAzimuth:1550 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-01 0:21:6' AND e.date<='2025-01-01 23:21:6' AND e.DeviceLoginName='2950' 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-12-31 22:21:06' AND g.time<='2025-01-01 21:21:06' AND g.DeviceLoginName='2950' GROUP BY g.time, g.Distance; CountAzimuth:8 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-02 0:21:6' AND e.date<='2025-01-02 23:21:6' AND e.DeviceLoginName='2950' 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>='2025-01-01 22:21:06' AND g.time<='2025-01-02 21:21:06' AND g.DeviceLoginName='2950' GROUP BY g.time, g.Distance; CountAzimuth:821 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-23 0:21:6' AND e.date<='2025-01-23 23:21:6' AND e.DeviceLoginName='2950' 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>='2025-01-22 22:21:06' AND g.time<='2025-01-23 21:21:06' AND g.DeviceLoginName='2950' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-20 0:21:6' AND e.date<='2025-01-20 23:21:6' AND e.DeviceLoginName='2950' 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>='2025-01-19 22:21:06' AND g.time<='2025-01-20 21:21:06' AND g.DeviceLoginName='2950' GROUP BY g.time, g.Distance; CountAzimuth:1239 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-21 0:21:6' AND e.date<='2025-01-21 23:21:6' AND e.DeviceLoginName='2950' 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>='2025-01-20 22:21:06' AND g.time<='2025-01-21 21:21:06' AND g.DeviceLoginName='2950' GROUP BY g.time, g.Distance; CountAzimuth:4011 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-01-06 0:21:6' AND e.date<='2025-01-06 23:21:6' AND e.DeviceLoginName='2950' 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>='2025-01-05 22:21:06' AND g.time<='2025-01-06 21:21:06' AND g.DeviceLoginName='2950' GROUP BY g.time, g.Distance; CountAzimuth:2014